how do I modify an existing database?

[smlcherry]

I need to modify a table in an existing database. I want to add a new column
with hyperlinks but when I try to do so it says I can't because the table is
linked. What would be the best way to do this?

 

[Jerry Whittle]

1. Make a complete backup of the database field(s).
2. Get everyone out of the database.
3. Go to Tools, Database Utilities, Linked Table Manager and find out where
the table actually exists.
4. Go to that file; make a backup of it; and then modify the table.

 

[Carl Rapson]

It sounds like the tables actually reside in another MDB file. Is there an
arrow to the left of the table in the Tables view of the Database window? If
so, hover the mouse pointer over the table name in the Tables view of the
Database window, and note what it shows for the path to the table you want
to modify. Then, open that file in Access and modify your table.

Carl Rapson