Linked Tables Twice?

[TheScullster]

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

 

[PieterLinden via AccessMonster.com]

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.

 

[John Spencer]

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

 

[Jeff Boyce]

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.

 

[Dirk Goldgar]

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.

 

[TheScullster]

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