Web Development

Ask something
Discussion Locked

Yet again another Access Question!

0 helpful
5 replies

by makita 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
OK! I have a database (which is made up of many tables) on a laptop using Access 2002 which a coworker updates while out on the road. On Monday when he returns to work I want him to push a button and the data transfers to my database on my computer. He has a standalone on his laptop and I have standalone application on my desktop. How can I go about doing this? Can this be done?

5 replies

by joseph moore

Yeah, that could be done. You could write an Update Query in Access on the users copy that writes his data (in his tables) that connects to your Access DB using an ODBC connection. The Update Query would just copy each local table in his DB and write via ODBC to the remote tables on your DB copy.
You could embed this query into a button in his Access DB copy.
It is very possible. It is a little involved and tough to explain in a forum as this, but yes, very possible.

by pnakiet

I think you should use REPLICATION that is a tool in all MS Access version to make it done. With this tool, you could synchronize many database data at the same time any times you want data compounded.
Refer to MS Access help for using it.

Have success,
PNAKiet

This discussion is closed to new replies.