Update data in two databases

  • Thread starter Thread starter m stroup
  • Start date Start date
M

m stroup

Database 1:
tblEmployee and multiple others

Database 2:
tblPersonnel

These two databases track a lot of the same information but have different
owners.
Information in Database 2 has Privacy Act info and the owner does not want
the table added to Database 1.

Can I create a form in Database 1 that will write to both databases?
If so, is the best way to use db.OpenRecordset?

Teach me to fish! Thanks for the help.
Pax, M
 
Are you saying that one database has "private" data plus public data, where
the other has only public data?

Have you considered creating one table that contains all public info (in
your "public" db, and shared with the other), and a second table in your
"private" db that contains only private data?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Here is how you open a recordset in a different database:

set xdbf =
dbengine(0).opendatabase("\\SomeServer\SomeFolder\SomeMdb.mdb,false)
set rst = xdbf.openrecordset("tbldivision")
 
Thanks Mark. I played with that and it works. I have to find a way to
secure the information now.
 
Yes, Jeff. On my own, I would create two tables as you suggested. However,
I am at the mercy of others.
 
Thanks for your help Dave. Right now I have them linked. This may not be
satisfactory though, so I may need to open the recordset using opendatabase.
 
Thanks Dave!
That was what I was originally looking for ... and will use, if not in this
scenario, in another!
 
Back
Top