By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,400 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

How to combine 2 Access databases?

P: n/a
Hello,

I have at home and at work a program that adds info to a local Access
data base. That means that my home Access and work Access database are
not in sync.
My question - how to sync both databases?

Thanks,

Zalek

Oct 14 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"zalek" <za********@hotmail.comwrote
I have at home and at work a program that adds info to a local Access
data base. That means that my home Access and work Access database are
not in sync.
My question - how to sync both databases?
For MDB databases (pre-Access 2007 ACCDB, which dropped support for it), you
can use replication, but be aware it is "not for the faint of heart." A
good resource on the subject is Michael Kaplan's site
http://www.trigeminal.com. I would not venture to offer any additional
advice on the subject.

Larry Linson
Microsoft Access MVP
Oct 14 '07 #2

P: n/a
On Sun, 14 Oct 2007 02:51:16 -0000, zalek <za********@hotmail.com>
wrote:

Using Windows Terminal Services or any number of other remote access
programs you can work on your work PC at home. Thus there is only one
database, and the entire problem goes away.

-Tom.

>Hello,

I have at home and at work a program that adds info to a local Access
data base. That means that my home Access and work Access database are
not in sync.
My question - how to sync both databases?

Thanks,

Zalek
Oct 14 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.