If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Convert table data to a linked table
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
|
|||
|
|||
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 | |
Display Modes | |
|
|
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 |