A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

convert tables to linked tables



 
 
Thread Tools Display Modes
  #1  
Old February 9th, 2005, 06:45 PM
alan
external usenet poster
 
Posts: n/a
Default 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  
Old February 9th, 2005, 07:13 PM
Rick Brandt
external usenet poster
 
Posts: n/a
Default

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  
Old February 9th, 2005, 08:01 PM
alan
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter on query of linked tables Sunny Running & Setting Up Queries 1 January 7th, 2005 01:45 PM
VBA: Insert Into-Statement for linked Tables Sascha Hennig General Discussion 10 January 6th, 2005 02: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


All times are GMT +1. The time now is 05:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.