All Access Objects Missing on File Load

[Guest]

We have a network access 2000 multiuser database that is used to manage
projects. When we open it the file loads, menus and toolbars appear but the
whole object sectiion below the toolbars is grayed out (not visible). The
file size is about the same as it was before. Anyway we can correct this
problem.

 

[Guest]

I think you are going to have to provide more information, not sure what you
mean by "whole object section below the toolbars is grayed out".

Is this a database that someone else wrote I assume? Could be that the
database is corrupt? Try making a back up of the database and doing a
Compact/Repair on it.

--Steve Huff

 

[Guest]

What it means is that no Tables, Queries, Forms, etc are present at all.
Also when I look at the network directory where the file is located there is
a small file next to it of Type Access.LockFile.9 which probably means that
the file never got closed out properly.

 

[Guest]

The Access.Lockfile.9 file (known commonly as an LDB file) is created when
someone opens the database and is deleted when the close out. If you crash
out the file gets left hanging around. Delete the LDF file (if you can't it
means someone else is in it) and backup the file and then compact/repair it.

--Steve Huff

 

[Guest]

I have the same problem and it has occurred on several occasions with several
databases. Today, I have a 9MB file and have tried compact and repair but it
doesn't change anything. I can see none of the database objects. I opened a
blank database and copied all the objects from the database whose objects are
not visible and I can then use the new database. This is a bandaid, however.
WHAT IS WRONG and HOW DO I PREVENT FUTURE OCCURRENCES?