|
Home > Archive > MS Access data conversion > January 2006 > Ghost forms
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I have upgraded a db from Access 97 to 2002 and when running it it complains
of missing forms.
Going back to the original 97 db; and going into VB by looking at the code
in one of the forms; I notice that in the "Microsoft Access Class Objects"
node, there are entries for the missing forms. I can right click on one of
those and select "View Object" and am taken back to Access and shown the
form. (I have a screen print showing the form, with it not being in the
forms list!). Has anyone seen this before? How can I gain access to these
ghost forms so that I can export them to the upgraded database?
| |
| Allen Browne 2006-01-19, 11:24 am |
| I presume these forms do not show in the Database window in Access 97, and
that you have already tried checking the Hidden and System check boxes
under:
Tools | Options | View
If so, the mdb may be corrupt, or they might be marked for deletion (to be
removed from the database next backup.)
Since you know the names of these objects, you could try exporting them to a
text file:
SaveAsText acForm, "Form1", "C:\Form1.txt"
If that works, you could then import them into another database with:
LoadFromText acForm, "Form1", "C:\Form1.txt"
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Ken" <Ken@discussions.microsoft.com> wrote in message
news:DCCEFF97-7FD3-4D65-BE06- B8721CDD5A7A@microso
ft.com...
>I have upgraded a db from Access 97 to 2002 and when running it it
>complains
> of missing forms.
>
> Going back to the original 97 db; and going into VB by looking at the code
> in one of the forms; I notice that in the "Microsoft Access Class Objects"
> node, there are entries for the missing forms. I can right click on one
> of
> those and select "View Object" and am taken back to Access and shown the
> form. (I have a screen print showing the form, with it not being in the
> forms list!). Has anyone seen this before? How can I gain access to
> these
> ghost forms so that I can export them to the upgraded database?
| |
|
| I was not aware of the Hidden and System check boxes. Thanks greatly.
Ken
"Allen Browne" wrote:
> I presume these forms do not show in the Database window in Access 97, and
> that you have already tried checking the Hidden and System check boxes
> under:
> Tools | Options | View
>
|
|
|
|
|