Convert table data to a linked table

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

Guest

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.
 
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,...
 
You must log in or register to reply here.

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

Linking Tables 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
linking tables and relationships 3
VBA - retrieve data on last create named range from previous inserted named range 0
Make Table v. Append to Table: Need Some Expert Design Inputs 7
Linking Tables from SQL Server 1
Use vba to change table design 2
tinkering with split databases 0

Back
Top