Table Modification: you can't open the table for modification

S

surya

Hi,

I tried to add a new column for my table in dsign view. I get this message
when i open it for design.

The database was actually converted from Access 97 to 2003.

Please help. it urgent.

Thanks in advance.

Regards,
Surya
 
J

Jerry Whittle

Did you read the rest of the error message carefully? The answer is probably
there.

You can't open the table '<tablename>' 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. Do you
want to open this table as read-only?

If you have opened a query or form bound to this table, close it, and then
try again to open the table in Design view.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table modification : You can't open the table for modification 0
"Compile error in table level validation expression " after format 0
Table Security in Access 2013 1
help with table design for Code Library 2
Access 2013: Form problem in reading data tables; relationship one-to-one 0
SaveRecord: The Command or Action "SaveRecord" isn't available now 11
Newbie problem, Added a link table for a many to many. Can't insertbecause of a foreign key constrai 0
Why won't Access assign a Primary Key ID to my linked SQL Table? 2

Top