I need to run a process where I am updating Access tables in 3 different databases to information from a live SQL server. We need them in 3 different databases because of the amount of information stored in each table. Is it possible to update all the tables from a couple of buttons on a type of main form. The previous people made it so you had to go into every database and run the updates and I was hoping to eliminate that. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using 1 Form to Access More Than 1 Database?
- Thread starter stazza18
- Start date
Hi
Well you could 'link' the tables in the three mdbs to a single mdb (see File \ Get External data \ link
in most situations this ellows the tabel to be combined into queries etc, and to allow forms to be based on that wery
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
Well you could 'link' the tables in the three mdbs to a single mdb (see File \ Get External data \ link
in most situations this ellows the tabel to be combined into queries etc, and to allow forms to be based on that wery
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
How about something like this?
Dim db as DAO.Database
Dim rs as DAO.Recordset
Set db = "path to your outside database"
Set rs = db.OpenRecordset("SELECT statement")
Code to perform updates on the Recordset
Set rs = Nothing
Set db = Nothing
Randy
Dim db as DAO.Database
Dim rs as DAO.Recordset
Set db = "path to your outside database"
Set rs = db.OpenRecordset("SELECT statement")
Code to perform updates on the Recordset
Set rs = Nothing
Set db = Nothing
Randy
- Status
Similar threads
