Adding a Field to a Linked Table

[frankis]

I need to add a field to a table but an alert box comes up telling me that i cant make a change to a linked table. How can I achieve this? To be honest I dont have a clue what a 'linked table'is!
Any help on this is greatly appreciated!

 

[RickSpr]

A linked table is a table that actually resides in another database file, but which is accessed in the current database. Linking a table is a mechanism that makes it appear as if the remote table were actually present in the current database. The help file has a fuller explanation.

To add a field, you must identify the database that contains the actual table, and add the field there.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein