how do I modify an existing database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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
 

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

Question about appending new data to an existing table 4
tinkering with split databases 0
Unsplit database 3
{Q} How to modify record in M Access database? 0
Source Database 5
New Table to Existing Database.. 1
reading database information 9
best approach to modifying tables 1

Back
Top