How do I link one database inside another?

J

julrankay

I am wanting to be able to click on a button in one database and open
another database. Thanks.
 
J

Jeff Boyce

Why? As in "why open a separate database?"

Would it be sufficient to have the tables from both databases linked into a
common front-end file?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

dbahooker

if you used Access Data Projects then _ALL_ of your databases would be
available via one application

hows' that for code reuse-- it 'just works right out of the box'
 
T

Tony Toews [MVP]

[email protected] said:
if you used Access Data Projects then _ALL_ of your databases would be
available via one application

hows' that for code reuse-- it 'just works right out of the box'
Click to expand...

As it would be from an MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
D

dbahooker

no tony.. with MDB you have to link TABLES not SERVERS and thus I can
link to 1 server than contains 100 DATABASES in a single operation

and meanwhile you're still be looking up the connection strings

ADP is a superior platform; it doesn't take any maintenance in order
to refer to information in the accounting database; for example


but on the high end-- there are enterprise level tools like DTS,
Informatica and SSIS

MDB has the silly Docmd... I mean get real kid
 
Top