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 tables to linked tables
I have a database which is a duplicate of another database but with the
queries etc. modified. I want to now run the modified queries etc. on the original database tables without changing that database. I simply wnat to swap out the local tables for the linked ones. I tried to reaname but it want's to delete relatuionsships. Will relationship exist to the linked one now if I say OK? |
#2
|
|||
|
|||
alan wrote:
I have a database which is a duplicate of another database but with the queries etc. modified. I want to now run the modified queries etc. on the original database tables without changing that database. I simply wnat to swap out the local tables for the linked ones. I tried to reaname but it want's to delete relatuionsships. Will relationship exist to the linked one now if I say OK? Yes. When using linked tables the only relationships (that matter) are in the back end file. Any you create in the front end are merely for documentation. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Thanks, Rick, I made a copy anyways and itseems to work. Just checking I had
no repercussions. Now I can leave the main db as the user entry and interactive query one and the other as the weekly and monthly batch reports one. "Rick Brandt" wrote: alan wrote: I have a database which is a duplicate of another database but with the queries etc. modified. I want to now run the modified queries etc. on the original database tables without changing that database. I simply wnat to swap out the local tables for the linked ones. I tried to reaname but it want's to delete relatuionsships. Will relationship exist to the linked one now if I say OK? Yes. When using linked tables the only relationships (that matter) are in the back end file. Any you create in the front end are merely for documentation. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filter on query of linked tables | Sunny | Running & Setting Up Queries | 1 | January 7th, 2005 12:45 PM |
VBA: Insert Into-Statement for linked Tables | Sascha Hennig | General Discussion | 10 | January 6th, 2005 01:26 PM |
Linked Tables | Daniel | New Users | 8 | September 2nd, 2004 08:24 PM |
Convert Access Linked Tables from AccessBE to SQL | BC-w2k3s | Database Design | 0 | August 24th, 2004 10:21 PM |