Disappearing Objects

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maltz - 11 Jan 2008 14:18 GMT

I must have done something wrong here. I have a very simple database, just
one table. I made a form for it, and a query just to test out the query
thing yesterday. Now when I open it up, there is nothing under "Tables",
other than the usual "Create Table in Design View...Create Table by using
Wizard...Create Table by entering data". However, the form is still there,
and I can still go through all the entries. When I right-click on the form
and go to "Object Dependencies," I can see the table and click on it to get
to it. Why isn't it showing up in the "Tables" window?

Also, the query I created yesterday is completely gone, but I'm less worried
about that.

Reply to this Message

Klatuu - 11 Jan 2008 14:49 GMT

It may be that you hid the objects.
From the main menu, select Tools, Options and select the View tab
Check the Hidden Objects under Show. Now see if your table and query show up.

If they do, right click on the object in the database window and select
Properties and uncheck the Hidden property.

Signature

Dave Hargis, Microsoft Access MVP

> I must have done something wrong here. I have a very simple database, just
> one table. I made a form for it, and a query just to test out the query
[quoted text clipped - 7 lines]
> Also, the query I created yesterday is completely gone, but I'm less worried
> about that.

Reply to this Message

Maltz - 11 Jan 2008 14:55 GMT

Thanks for the idea, didn't work though. Any other possibilities?

> It may be that you hid the objects.
> From the main menu, select Tools, Options and select the View tab
[quoted text clipped - 14 lines]
> > Also, the query I created yesterday is completely gone, but I'm less worried
> > about that.

Reply to this Message

Klatuu - 11 Jan 2008 15:03 GMT

Possible corruption.
Try a decompile and a compact and repair. If that doesn't cure it. you may
want to create a new database and copy the objects from the suspisous one.

Here is a link to info on the decompile:

http://www.granite.ab.ca/access/decompile.htm

Signature

Dave Hargis, Microsoft Access MVP

> Thanks for the idea, didn't work though. Any other possibilities?
>
[quoted text clipped - 16 lines]
> > > Also, the query I created yesterday is completely gone, but I'm less worried
> > > about that.

Reply to this Message

Maltz - 11 Jan 2008 16:21 GMT

Brilliant, that worked, thanks. Any way to make sure that doesn't happen
again, or was it just bad luck?

> Possible corruption.
> Try a decompile and a compact and repair. If that doesn't cure it. you may
[quoted text clipped - 24 lines]
> > > > Also, the query I created yesterday is completely gone, but I'm less worried
> > > > about that.

Reply to this Message

Klatuu - 11 Jan 2008 16:24 GMT

Just bad luck. No way to prevent it from happening again. the only solution
is keep backups.

Signature

Dave Hargis, Microsoft Access MVP

> Brilliant, that worked, thanks. Any way to make sure that doesn't happen
> again, or was it just bad luck?
[quoted text clipped - 27 lines]
> > > > > Also, the query I created yesterday is completely gone, but I'm less worried
> > > > > about that.

Reply to this Message