Cannot edit table design

[Louie Warren]

I have created a database with numerous tables. At the
present time, there are no links between tables. There
are no forms. There are no queries. I can go to Design
view on all tables but one. On that table I get the
message:

You can't open the table "MyTable" for modification.

A query or form bound to the table is open, you may
not have permission to open this table in Design View,
or another user has the table open.

I have no users, just Admin. No one else knows the
database exists. When I use Windows Explorer, I see
the .ldb is there even when the database is closed. I
edit the .ldb and it shows two entries for Admin on the
server where the database resides.

What is wrong, and how can I fix it? Thanx!

 

[Roger Carlson]

Do you have full network rights to the DIRECTORY where the database lives?
If not, you need those: Delete, Create, and Modify.

 

[Louie Warren]

Yes. I can go into Design view for all tables except one.

 

[John Vinson]

I have created a database with numerous tables. At the
present time, there are no links between tables. There
are no forms. There are no queries. I can go to Design
view on all tables but one. On that table I get the
message:

You can't open the table "MyTable" for modification.

A query or form bound to the table is open, you may
not have permission to open this table in Design View,
or another user has the table open.

I have no users, just Admin. No one else knows the
database exists. When I use Windows Explorer, I see
the .ldb is there even when the database is closed. I
edit the .ldb and it shows two entries for Admin on the
server where the database resides.

What is wrong, and how can I fix it? Thanx!

Just delete the .ldb file altogether (with Access closed). Access will
recreate it as needed.

 

[Roger Carlson]

Hmmmm. This sounds like corruption of some sort. On my website, in the
Other Developer's Libraries, is a document by Jerry Whittle which details
nearly all there is to know about fixing database corruption. Go here:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Whittle,Jerry

 

[Greg Kraushaar]

Looks like the DB crashed at some point & didn't do a proper cleanup.
Simply delete the ldb, and you should be laughing.

BTW i would challenge your assumption that no knows about it if its on
a server, unless you have sole access to the server as well.
SystemAdmin people, hackers & lots of others may know about it & even
have looked at it. Also the Form/Report could be in a different MDB
and linked to your MDB....