Prev: Still confused on relationship queries and similating a vlooku
Next: Macro Setting
From: TheScullster on 5 Mar 2010 11:02
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


From: PieterLinden via AccessMonster.com on 5 Mar 2010 11:15
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

From: John Spencer on 5 Mar 2010 11:47
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.
>
From: Jeff Boyce on 5 Mar 2010 12:17
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" <phil(a)dropthespam.com> wrote in message
news:scidnd43NOuMtgzWnZ2dnUVZ8h6dnZ2d(a)eclipse.net.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
>


From: Dirk Goldgar on 7 Mar 2010 16:16
"TheScullster" <phil(a)dropthespam.com> wrote in message
news:scidnd43NOuMtgzWnZ2dnUVZ8h6dnZ2d(a)eclipse.net.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)

 |  Next  |  Last
Pages: 1 2
Prev: Still confused on relationship queries and similating a vlooku
Next: Macro Setting