how to add a new field in a developed table

J

james

I am trying to add a new field to a table in my database
but when I try to use the design view, the windows prompt
me that the table's property can't be changed because
it 's linked table.
Then I try to open the TABLE.mdb file directly to change
it but the windows prompt me that it 's just a copy of the
table (all tables with a yellow mark of a double arrow)
and I can only open it in read only mode.
I want to ask where and how can I change and add the
fields to the table for my database ????
Thanx a lot
 
J

John Vinson

I am trying to add a new field to a table in my database
but when I try to use the design view, the windows prompt
me that the table's property can't be changed because
it 's linked table.
Correct.

Then I try to open the TABLE.mdb file directly to change
it but the windows prompt me that it 's just a copy of the
table (all tables with a yellow mark of a double arrow)
and I can only open it in read only mode.

Are you quite certain that this database is in fact the backend to
which your frontend database is linked? If it is, do you have Access
scurity implemented, and do you have authority to make changes?
 

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

Top