Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #11725 > unrolled thread

A2003 database with invisible objets

Back to article view | Back to comp.databases.ms-access

Contents

  A2003 database with invisible objets Bruno Campanini <brunocam@libero.it> - 2016-04-02 17:14 +0200
    Re: A2003 database with invisible objets Mike P <mikewpayne@tiscali.co.uk> - 2016-04-03 02:54 -0700
    Re: A2003 database with invisible objets pstanton54@gmail.com - 2016-04-03 10:16 -0700
    Re: A2003 database with invisible objets DFS <nospam@dfs.com> - 2016-04-05 02:41 -0400
      Re: A2003 database with invisible objets Bruno Campanini <brunocam@libero.it> - 2016-04-05 14:46 +0200
        Re: A2003 database with invisible objets Patrick Finucane <patrickfinucanetx@gmail.com> - 2016-04-05 06:05 -0700
        Re: A2003 database with invisible objets DFS <nospam@dfs.com> - 2016-04-05 10:21 -0400
          Re: A2003 database with invisible objets Bruno Campanini <brunocam@libero.it> - 2016-04-05 19:52 +0200
            Re: A2003 database with invisible objets DFS <nospam@dfs.com> - 2016-04-05 15:49 -0400
              Re: A2003 database with invisible objets Bruno Campanini <brunocam@libero.it> - 2016-04-06 14:28 +0200
                Re: A2003 database with invisible objets DFS <nospam@dfs.com> - 2016-04-06 13:45 -0400
            Re: A2003 database with invisible objets Patrick Finucane <patrickfinucanetx@gmail.com> - 2016-04-05 13:09 -0700

#11725 — A2003 database with invisible objets

I have an A2003 db with the database window containing only local
and linked tables, no more Modules, Forms, Reports.
I can display Hidden & System Objets and I see they contain
all the Modules, Forms and Reports I'm looking for.

I've tried to compact/repair the file but I get only the response:
"... you and another user  are attempting to change the
same data at the same time."

As per the file size (7.06 mb) it appears the file
contains all the objects I need.
The file opens with both A2003 & A2016.

Any suggestions for recovering all the missed objects?

Bruno

[toc] | [next] | [standalone]

#11726

On Saturday, April 2, 2016 at 4:14:34 PM UTC+1, Bruno Campanini wrote:
> I have an A2003 db with the database window containing only local
> and linked tables, no more Modules, Forms, Reports.
> I can display Hidden & System Objets and I see they contain
> all the Modules, Forms and Reports I'm looking for.
> 
> I've tried to compact/repair the file but I get only the response:
> "... you and another user  are attempting to change the
> same data at the same time."
> 
> As per the file size (7.06 mb) it appears the file
> contains all the objects I need.
> The file opens with both A2003 & A2016.
> 
> Any suggestions for recovering all the missed objects?
> 
> Bruno

If the 'hidden' property of an object is set could you switch it to unset?

Mike P.

3/4/16

[toc] | [prev] | [next] | [standalone]

#11727

On Saturday, 2 April 2016 16:14:34 UTC+1, Bruno Campanini  wrote:
> I have an A2003 db with the database window containing only local
> and linked tables, no more Modules, Forms, Reports.
> I can display Hidden & System Objets and I see they contain
> all the Modules, Forms and Reports I'm looking for.
> 
> I've tried to compact/repair the file but I get only the response:
> "... you and another user  are attempting to change the
> same data at the same time."
> 
> As per the file size (7.06 mb) it appears the file
> contains all the objects I need.
> The file opens with both A2003 & A2016.
> 
> Any suggestions for recovering all the missed objects?
> 
> Bruno

Try 

Application.SetHiddenAttribute acForm, "FormName", False

Phil

[toc] | [prev] | [next] | [standalone]

#11728

On 4/2/2016 11:14 AM, Bruno Campanini wrote:
> I have an A2003 db with the database window containing only local
> and linked tables, no more Modules, Forms, Reports.
> I can display Hidden & System Objets and I see they contain
> all the Modules, Forms and Reports I'm looking for.
>
> I've tried to compact/repair the file but I get only the response:
> "... you and another user  are attempting to change the
> same data at the same time."
>
> As per the file size (7.06 mb) it appears the file
> contains all the objects I need.
> The file opens with both A2003 & A2016.
>
> Any suggestions for recovering all the missed objects?
>
> Bruno


Create a new .mdb and import the 'hidden' objects into it.

[toc] | [prev] | [next] | [standalone]

#11730

It happens that DFS formulated :
> On 4/2/2016 11:14 AM, Bruno Campanini wrote:
>> I have an A2003 db with the database window containing only local
>> and linked tables, no more Modules, Forms, Reports.
>> I can display Hidden & System Objets and I see they contain
>> all the Modules, Forms and Reports I'm looking for.
>>
>> I've tried to compact/repair the file but I get only the response:
>> "... you and another user  are attempting to change the
>> same data at the same time."
>>
>> As per the file size (7.06 mb) it appears the file
>> contains all the objects I need.
>> The file opens with both A2003 & A2016.
>>
>> Any suggestions for recovering all the missed objects?
>>
>> Bruno
>
>
> Create a new .mdb and import the 'hidden' objects into it.

Have you ever imported 'hidden' object?

Bruno

[toc] | [prev] | [next] | [standalone]

#11731

On Tuesday, April 5, 2016 at 8:47:31 AM UTC-4, Bruno Campanini wrote:
> It happens that DFS formulated :
> > On 4/2/2016 11:14 AM, Bruno Campanini wrote:
> >> I have an A2003 db with the database window containing only local
> >> and linked tables, no more Modules, Forms, Reports.
> >> I can display Hidden & System Objets and I see they contain
> >> all the Modules, Forms and Reports I'm looking for.
> >>
> >> I've tried to compact/repair the file but I get only the response:
> >> "... you and another user  are attempting to change the
> >> same data at the same time."
> >>
> >> As per the file size (7.06 mb) it appears the file
> >> contains all the objects I need.
> >> The file opens with both A2003 & A2016.
> >>
> >> Any suggestions for recovering all the missed objects?
> >>
> >> Bruno
> >
> >
> > Create a new .mdb and import the 'hidden' objects into it.
> 
> Have you ever imported 'hidden' object?
> 
> Bruno

I am in 2013.  Anyway, I set the Display Options to Show System Objects and Show Hidden Objects.  I'm sure there is some setting for A2003 as well as I had a hidden object as well.

[toc] | [prev] | [next] | [standalone]

#11732

On 4/5/2016 8:46 AM, Bruno Campanini wrote:
> It happens that DFS formulated :
>> On 4/2/2016 11:14 AM, Bruno Campanini wrote:
>>> I have an A2003 db with the database window containing only local
>>> and linked tables, no more Modules, Forms, Reports.
>>> I can display Hidden & System Objets and I see they contain
>>> all the Modules, Forms and Reports I'm looking for.
>>>
>>> I've tried to compact/repair the file but I get only the response:
>>> "... you and another user  are attempting to change the
>>> same data at the same time."
>>>
>>> As per the file size (7.06 mb) it appears the file
>>> contains all the objects I need.
>>> The file opens with both A2003 & A2016.
>>>
>>> Any suggestions for recovering all the missed objects?
>>>
>>> Bruno
>>
>>
>> Create a new .mdb and import the 'hidden' objects into it.
>
> Have you ever imported 'hidden' object?
>
> Bruno


Yes.  In both the source and destination .mdb, turn the 'show Hidden 
objects' on.

[toc] | [prev] | [next] | [standalone]

#11733

DFS formulated the question :
> On 4/5/2016 8:46 AM, Bruno Campanini wrote:
>> It happens that DFS formulated :
>>> On 4/2/2016 11:14 AM, Bruno Campanini wrote:
>>>> I have an A2003 db with the database window containing only local
>>>> and linked tables, no more Modules, Forms, Reports.
>>>> I can display Hidden & System Objets and I see they contain
>>>> all the Modules, Forms and Reports I'm looking for.
>>>>
>>>> I've tried to compact/repair the file but I get only the response:
>>>> "... you and another user  are attempting to change the
>>>> same data at the same time."
>>>>
>>>> As per the file size (7.06 mb) it appears the file
>>>> contains all the objects I need.
>>>> The file opens with both A2003 & A2016.
>>>>
>>>> Any suggestions for recovering all the missed objects?
>>>>
>>>> Bruno
>>>
>>>
>>> Create a new .mdb and import the 'hidden' objects into it.
>>
>> Have you ever imported 'hidden' object?
>>
>> Bruno
>
>
> Yes.  In both the source and destination .mdb, turn the 'show Hidden objects' 
> on.

I've switched both Hidden & System Objects on one week ago...
A2016 can't import what is System or Hidden objects, even if
they are visible.
Please don't suggest what you estimate, suggest what you
have experienced!

Bruno

[toc] | [prev] | [next] | [standalone]

#11734

On 4/5/2016 1:52 PM, Bruno Campanini wrote:
> DFS formulated the question :
>> On 4/5/2016 8:46 AM, Bruno Campanini wrote:
>>> It happens that DFS formulated :
>>>> On 4/2/2016 11:14 AM, Bruno Campanini wrote:
>>>>> I have an A2003 db with the database window containing only local
>>>>> and linked tables, no more Modules, Forms, Reports.
>>>>> I can display Hidden & System Objets and I see they contain
>>>>> all the Modules, Forms and Reports I'm looking for.
>>>>>
>>>>> I've tried to compact/repair the file but I get only the response:
>>>>> "... you and another user  are attempting to change the
>>>>> same data at the same time."
>>>>>
>>>>> As per the file size (7.06 mb) it appears the file
>>>>> contains all the objects I need.
>>>>> The file opens with both A2003 & A2016.
>>>>>
>>>>> Any suggestions for recovering all the missed objects?
>>>>>
>>>>> Bruno
>>>>
>>>>
>>>> Create a new .mdb and import the 'hidden' objects into it.
>>>
>>> Have you ever imported 'hidden' object?
>>>
>>> Bruno
>>
>>
>> Yes.  In both the source and destination .mdb, turn the 'show Hidden
>> objects' on.
>
> I've switched both Hidden & System Objects on one week ago...
> A2016 can't import what is System or Hidden objects, even if
> they are visible.
> Please don't suggest what you estimate, suggest what you
> have experienced!


Please don't tell me what I have experienced.  If I turn 'show Hidden 
objects' on in both A2003 databases (source and destination), I can see 
and import the Hidden objects into destination, from source.

That's for Tables, Queries, Forms, Reports, Macros and Modules.

When the objects are imported into the destination .mdb, they lose the 
Hidden property.

You seem to have a corrupt .mdb.

Delete any unused .ldb files in the folder.

Try to decompile your database, then try to import the objects into 
another .mdb.

[toc] | [prev] | [next] | [standalone]

#11737

DFS submitted this idea :

> Please don't tell me what I have experienced.  If I turn 'show Hidden 
> objects' on in both A2003 databases (source and destination), I can see and 
> import the Hidden objects into destination, from source.

I've written:
"""
I can display Hidden & System Objets and I see they contain
all the Modules, Forms and Reports I'm looking for.
"""

I didn't write:
"""
I can see as invisible objects all my Forms, Reports, and so on.
"""

I can read from the system tables, when switched visible, the list
of my Forms, Reports, Modules with all their parameters, but
there is no more trace, visible or not, of those Forms, Reports...
Clear enough now?

BTW, I found on the Internet just a program that recovered all
Form, Modules an 6 Reports of 18.
Like a miracle!

Bruno

[toc] | [prev] | [next] | [standalone]

#11739

On 4/6/2016 8:28 AM, Bruno Campanini wrote:
> DFS submitted this idea :
>
>> Please don't tell me what I have experienced.  If I turn 'show Hidden
>> objects' on in both A2003 databases (source and destination), I can
>> see and import the Hidden objects into destination, from source.
>
> I've written:
> """
> I can display Hidden & System Objets and I see they contain
> all the Modules, Forms and Reports I'm looking for.
> """
>
> I didn't write:
> """
> I can see as invisible objects all my Forms, Reports, and so on.
> """
>
> I can read from the system tables, when switched visible, the list
> of my Forms, Reports, Modules with all their parameters, but
> there is no more trace, visible or not, of those Forms, Reports...
> Clear enough now?

As mud.


> BTW, I found on the Internet just a program that recovered all
> Form, Modules an 6 Reports of 18.
> Like a miracle!
>
> Bruno

Glad you got most of it back.

[toc] | [prev] | [next] | [standalone]

#11735

On Tuesday, April 5, 2016 at 1:52:38 PM UTC-4, Bruno Campanini wrote:
> DFS formulated the question :
> > On 4/5/2016 8:46 AM, Bruno Campanini wrote:
> >> It happens that DFS formulated :
> >>> On 4/2/2016 11:14 AM, Bruno Campanini wrote:
> >>>> I have an A2003 db with the database window containing only local
> >>>> and linked tables, no more Modules, Forms, Reports.
> >>>> I can display Hidden & System Objets and I see they contain
> >>>> all the Modules, Forms and Reports I'm looking for.
> >>>>
> >>>> I've tried to compact/repair the file but I get only the response:
> >>>> "... you and another user  are attempting to change the
> >>>> same data at the same time."
> >>>>
> >>>> As per the file size (7.06 mb) it appears the file
> >>>> contains all the objects I need.
> >>>> The file opens with both A2003 & A2016.
> >>>>
> >>>> Any suggestions for recovering all the missed objects?
> >>>>
> >>>> Bruno
> >>>
> >>>
> >>> Create a new .mdb and import the 'hidden' objects into it.
> >>
> >> Have you ever imported 'hidden' object?
> >>
> >> Bruno
> >
> >
> > Yes.  In both the source and destination .mdb, turn the 'show Hidden objects' 
> > on.
> 
> I've switched both Hidden & System Objects on one week ago...
> A2016 can't import what is System or Hidden objects, even if
> they are visible.
> Please don't suggest what you estimate, suggest what you
> have experienced!
> 
> Bruno

Don't be an asshole.  Access 2016 is new, many are not using it.  Be grateful anybody attempts to answer you.  

We didn't hide your forms.  You did.  It's your problem, not ours.

You created a shitty post originally.  We aren't mind readers.  How'd you screw up and hide your forms?  The only way I know how to do that is adding USys to the front of a name.  Ex:  USysMyFormName.  IF you hid it some other way, let us know.  

If you hid it with USys, unhide all the forms.  Then rename each form name to something like MyUsysFormName.  Now you can import into A2016.  They aren't hidden.  Then in a2016, rename back to original name.

IF you hid the forms some other screwy way, let us know.  You might get a valid answer.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web