How do I link two databases?

  • Thread starter Thread starter Emma
  • Start date Start date
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?
 
The second database is very large and the first is very small. I'm not sure
how to link the two?
 
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.
 
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.
 
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.
 
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.
 
Back
Top