startup page

T

Tim

Help!! have two seperate databses.. would like to be able to have one ICON
that i click on then showing the two databases. Also is it possible to search
beteen two seperate databases..?? any help would do
 
S

Susie DBA [MSFT]

if you used Access DAta Projects; it would be as easy as


Select * from myDb1.dbo.mytable1
and
Select * from myDb2.dbo.mytable2

with MDB it's a nightmare to deal with

ADP won the war a decade ago
 
S

strive4peace

Hi Tim,

unless you write a program to show the 2 databases and then pick one or
the other (use something like Visual Basic), there is no way with the
Windows interface to do that ...

as for searching between the 2 -- sure! just link to all the table in
the second database from the first one (for instance) and have your
search use a UNION query.

It sounds like your databases have the same data ... why are there 2 of
them instead of 1?


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Top