2 Databases on 1 form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm tring to link data from one database to another database
Database X and Database Y
I would like to create a form that allows me to search data from database X
and on the same form I want to be able to enter new data to database Y
 
When you import your tables into the database you can link the tables but
please NOTE you CANNOT create relationships between tables from two different
databases (though I know that may sound obvious).

From that just treat it as one database. I can't see why not.
 
I'm tring to link data from one database to another database
Database X and Database Y
I would like to create a form that allows me to search data from database X
and on the same form I want to be able to enter new data to database Y
Click to expand...

A bit of jargon here: An Access Database is a container for multiple forms,
reports, queries, tables etc. - you can't "search a database". You can search
a Table in a database though.

What it sounds like you need is to open Database Y and use File... Get
External Data... Link to connect to one or more tables in Database X. These
linked tables can be used just like local tables; you can create queries based
on them, display their data on forms, etc. The only thing you can't do is
change the design of the table itself (you need to open Database X to do
that).

John W. Vinson [MVP]
 
Back
Top