Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Yet again another Access Question!

Locked

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?

Topic

Reply To: Yet again another Access Question!

In reply to Yet again another Access Question!

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.

Reply To: Yet again another Access Question!

In reply to Reply To: Yet again another Access Question!

Thank-you! It works great!

Reply To: Yet again another Access Question!

In reply to Yet again another Access Question!

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

Reply To: Yet again another Access Question!

In reply to Reply To: Yet again another Access Question!

Poster rated this answer.

Reply To: Yet again another Access Question!

In reply to Yet again another Access Question!

This question was closed by the author

[Author]

Replies