How do I link two databases?

E

Emma

Hi I have a front end database which collects basic demographic material and
a second database which collects more detailed information. I would like the
first database to have a button which opens the second. The second opens now
using a shortcut. Any idea of how to go about doing this?
 
E

Emma

The second database is very large and the first is very small. I'm not sure
how to link the two?
 
K

KARL DEWEY

You are using the term 'databases' but it sounds like you have two tables.
Post the table structure - field names and datatype.
Post sample data.
 
E

Emma

No I actually mean 2 databases. I would like a button on the first database
which is a link or shortcut to openning up the second database. These need to
be 2 different databases as they collect different information. I would call
it a hyperlink in website design, not sure what you call it in database
design.
 
K

KARL DEWEY

These need to be 2 different databases as they collect different information.
You can use the same database for multiple data sets - just use different
tables, queries, forms, and reports.

Someone else will need to answer your question on how to open the second
database. I just go to navigation pane (2007) and click on the other
database listed in Open Recent Database. It closes the current one and opens
the next.
 
J

John W. Vinson

No I actually mean 2 databases. I would like a button on the first database
which is a link or shortcut to openning up the second database. These need to
be 2 different databases as they collect different information. I would call
it a hyperlink in website design, not sure what you call it in database
design.
Click to expand...

You can actually use a hyperlink (to the other database, stored in a table in
your current database) if you wish; or you can use the VBA Shell() function to
execute msaccess.exe passing it the name of the other database.
 
Top