How do I link one database inside another?

[Guest]

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

 

[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

 

[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'

 

[Tony Toews [MVP]]

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'

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

 

[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