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,...
 
Back
Top