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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linked Tables Twice?



 
 
Thread Tools Display Modes
  #1  
Old March 5th, 2010, 05:02 PM posted to microsoft.public.access.gettingstarted
TheScullster
external usenet poster
 
Posts: 53
Default 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  
Old March 5th, 2010, 05:15 PM posted to microsoft.public.access.gettingstarted
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default 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  
Old March 5th, 2010, 05:47 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default 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  
Old March 5th, 2010, 06:17 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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  
Old March 7th, 2010, 10:16 PM posted to microsoft.public.access.gettingstarted
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default 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  
Old March 8th, 2010, 10:42 AM posted to microsoft.public.access.gettingstarted
TheScullster
external usenet poster
 
Posts: 53
Default 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

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


All times are GMT +1. The time now is 03:08 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.