Converting linked tables to native?

  • Thread starter Thread starter Douglas J. Steele
  • Start date Start date
D

Douglas J. Steele

Make a copy of your existing frontend. Delete the linked tables in your copy
(don't worry: this just deletes the pointer to the data, not the data
itself) Select File | Get External Data | Import from the menu bar, navigate
to your backend database and import each of the tables into your copy.
You're done.
 
Hello,

How does one convert an Access 97 db with linked tables
into a stand alone DB with all the current data?

I would like to archive a db and not have the data updated
by production changes.

Thanks in advance for any assistance provided.
Steve
 

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

Importing tables from one database to another - help please! 3
How can I TransferDatabase a backend table from the frontend? 2
Split database- linking tables 1
Linked Tables 3
Split DB now what? Transferdatabase!!! 1
Can't link to MS SQL Svr 2005 table (#deleted) 8
Importing table 3
Table linked to ODBC 3

Back
Top