Convert table data to a linked table

#1 December 16th, 2004, 04:11 PM

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.

#2 December 16th, 2004, 05:54 PM

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

--
Duane Hookom
MS Access MVP

"Mike Brown" Mike wrote in message
...
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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Here's a shocker	Mike Labosh	General Discussion	2	October 26th, 2004 05:04 PM
How do I get 3 series in sync with the x-axis?	zizbird	Charts and Charting	10	October 25th, 2004 01:23 PM
Automatically Delete Duplicated Data in Table	faxylady	Running & Setting Up Queries	3	September 29th, 2004 06:58 PM
Difference betwen linked table and exorted data	Michael Lindekugel	Contacts	1	June 16th, 2004 01:03 AM
Moving data from popup to subform	John Nurick	Database Design	0	May 6th, 2004 06:19 AM