Question Merging two database and use single form

[shieriel]

Hello. I am having problem with my current project. I dont know how to merge two database and combine all the data for the table, and also use only one Form to update data on the two tables.

We currently have two database, one is for parameter entry and the other is for performance monitoring. These databases have similar data on some point such as Product name, Time started, Started by, and Finished by.

Now instead of opening two databases and encoding data how can i combine the two database so that only one form is opened but updating the tables for each database?

 

[DCrake]

Essentially you would need to build an unbound form to collect the data then have a "Save" button that would run vba code to append/update records in one or more tables based on the information collected.

 

[shieriel]

Essentially you would need to build an unbound form to collect the data then have a "Save" button that would run vba code to append/update records in one or more tables based on the information collected.

Hi Sir, thank you for the reply. Correct me if i am wrong, I will make a table for my unbound form and then create an append query for the two tables? Is this what you mean sir? Ok i will try to do this and return for my feedback. Thanks

 

[Simon_MT]

Why can't the databases be combined?

Simon

 

[shieriel]

Why can't the databases be combined?

Simon

We have 2 databases that need to be combined and i dont know where to start. I tried creating another table where all data for the two tables are there and creating a form from that. But when i created an append query i got an error saying something like i cannot proceed to append query probably because maybe access got confused since two different tables will be appended at the same time.