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
|
|||
|
|||
Linked Tables Twice?
Hi all
Currently we have an access 2000 backend database with front ends on access 2003 and 2007. I am looking at creating a database which references some of the tables in the original backend. Rather than risk disturbing this database I was considering creating another backend database with the original tables linked to the new backend. Then the front ends would link to the new back end and by association, the linked tables in the old back end. Will this work or is it just plain nuts/bad practice? TIA Phil |
#2
|
|||
|
|||
Linked Tables Twice?
TheScullster wrote:
Hi all Currently we have an access 2000 backend database with front ends on access 2003 and 2007. I am looking at creating a database which references some of the tables in the original backend. Rather than risk disturbing this database I was considering creating another backend database with the original tables linked to the new backend. Then the front ends would link to the new back end and by association, the linked tables in the old back end. Will this work or is it just plain nuts/bad practice? TIA Phil You mean you want to link to a database that has no tables in it, only links to tables? I don't know if that would even work... and even if it did, why would you even want to do something like that? Is this a security by obscurity thing? Those are seldom a good idea. -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Linked Tables Twice?
As far as I know, you can't set up a link to a linked table.
John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County PieterLinden via AccessMonster.com wrote: TheScullster wrote: Hi all Currently we have an access 2000 backend database with front ends on access 2003 and 2007. I am looking at creating a database which references some of the tables in the original backend. Rather than risk disturbing this database I was considering creating another backend database with the original tables linked to the new backend. Then the front ends would link to the new back end and by association, the linked tables in the old back end. Will this work or is it just plain nuts/bad practice? TIA Phil You mean you want to link to a database that has no tables in it, only links to tables? I don't know if that would even work... and even if it did, why would you even want to do something like that? Is this a security by obscurity thing? Those are seldom a good idea. |
#4
|
|||
|
|||
Linked Tables Twice?
Phil
Define "disturbing" ... Why not simply create your new front-end and link to the tables you need to see? What is it that you're concerned about happening? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "TheScullster" wrote in message . uk... Hi all Currently we have an access 2000 backend database with front ends on access 2003 and 2007. I am looking at creating a database which references some of the tables in the original backend. Rather than risk disturbing this database I was considering creating another backend database with the original tables linked to the new backend. Then the front ends would link to the new back end and by association, the linked tables in the old back end. Will this work or is it just plain nuts/bad practice? TIA Phil |
#5
|
|||
|
|||
Linked Tables Twice?
"TheScullster" wrote in message
. uk... Hi all Currently we have an access 2000 backend database with front ends on access 2003 and 2007. I am looking at creating a database which references some of the tables in the original backend. Rather than risk disturbing this database I was considering creating another backend database with the original tables linked to the new backend. Then the front ends would link to the new back end and by association, the linked tables in the old back end. Will this work or is it just plain nuts/bad practice? You can have a front-end with some of its tables linked to the old back-end, and some of them linked to the new back-end. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
#6
|
|||
|
|||
Linked Tables Twice?
"Dirk Goldgar" wrote You can have a front-end with some of its tables linked to the old back-end, and some of them linked to the new back-end. -- Thanks Dirk It's a while since I did anything with Access so the fog is taking a while to clear. Yes, the solution you suggest fits with what I am trying to achieve. Phil |
Thread Tools | |
Display Modes | |
|
|