Trying to add new fields to linked table

  • Thread starter mlthomas007 via AccessMonster.com
  • Start date
M

mlthomas007 via AccessMonster.com

Hi,

I want to add new fields to our database built way back by someone else.
However I keep getting access can't save errors bc of linked tables. It also
shows an error message saying linked table can not be modified.

Is there anyway around this?

Thanks
 
R

Rick Brandt

mlthomas007 said:
Hi,

I want to add new fields to our database built way back by someone
else. However I keep getting access can't save errors bc of linked
tables. It also shows an error message saying linked table can not
be modified.

Is there anyway around this?

Thanks
Click to expand...

The table does not exist in the file you have open, only a link to it. You
have to open the file where the table actually resides and make the changes
there.
 
M

Mr B

In order to add fields to the tables in the linked database, you will need to
open the database file to which your database file is linked.

If you don't know where the linked file is located, just go to the menu of
Access and select Linked Table Manger from the Tools/Database Utilities
option and check to see where the backend database file is located and what
the name of it is.
 
M

mlthomas007 via AccessMonster.com

Thank you all for the help.


Mr said:
In order to add fields to the tables in the linked database, you will need to
open the database file to which your database file is linked.

If you don't know where the linked file is located, just go to the menu of
Access and select Linked Table Manger from the Tools/Database Utilities
option and check to see where the backend database file is located and what
the name of it is.
Hi,
Click to expand...
[quoted text clipped - 5 lines]
Thanks
Click to expand...
Click to expand...
 
Top