Web Development

General discussion


Yet again another Access Question!

By Makita ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Joseph Moore In reply to Yet again another Access ...

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.

Collapse -

by Makita In reply to

Thank-you! It works great!

Collapse -

by pnakiet In reply to Yet again another Access ...

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,

Collapse -

by Makita In reply to

Poster rated this answer.

Collapse -

by Makita In reply to Yet again another Access ...

This question was closed by the author

Related Discussions

Related Forums