Convert table data to a linked table

M

Mike Brown

I have an existing Access 2000 database with internal tables and existing
forms, reports, etc that use those tables. I want to dump the data out to SQL
which I know how to do. The questikon is: Is there a painless way to switch
the existing forms and reports to use the linked table(s) rather than the old
internal table(s)? Thanks for any help.
 
D

Duane Hookom

Dump the tables to SQL, link them back in, rename dbo_tblEmployees to
tblEmployees, and you might be ready to roll. However there are potential
issues with permissions, primary keys, data-types, referential integrity,...
 

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

Internal Data Integrity (Type 4) Details Needed 1
How do I clear a form? 0
Excel does not accept text format! 0
Cross-reference Insert Default Change 0
linking tables and relationships 3
Table Security in Access 2013 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
query to show where no data in a stated column 0

Top