If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2 Databases on 1 form
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 |
#2
|
|||
|
|||
2 Databases on 1 form
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. -- www.ae911truth.org "heathermarie" wrote: 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 |
#3
|
|||
|
|||
2 Databases on 1 form
On Fri, 10 Aug 2007 08:52:03 -0700, heathermarie
wrote: 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 A bit of jargon he 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] |
Thread Tools | |
Display Modes | |
|
|