corrupt database question

[Guest]

I have Access 2003. When I open the db, there are forms, queries, and reports
missing. When I go into one of the forms that is available, the data is not
accurate. For instance, I had ~ 200 files listed in a table, and only 17
showed up. Any ideas? Thanks!

 

[Joseph Meehan]

I have Access 2003. When I open the db, there are forms, queries, and
reports missing. When I go into one of the forms that is available,
the data is not accurate. For instance, I had ~ 200 files listed in a
table, and only 17 showed up. Any ideas? Thanks!

Somebody else may have a better idea, but I suggest making a copy of the
mdb file and then do a repair and compact of that copy. Let us know what
happens.

 

[Guest]

TY Joseph. I tried that and it didn't work. Also forgot to mention that I
have SP2 and I am the only user of this db; no one else has access to it.