Which is the best way?

[Guest]

Dear gurus - Need your valuable help again,

I want to export data from one PC (MS-Access) and then import that data in
another PC.
I currently have a macro using the TransferDatabase (in a second mdb file -
just a single table), and then using another macro on the second PC I use a
macro TransferDatabase - Import into a table (which is a temporary one, used
later on using an append query to append data to another table).
Is that correct? - Theoritically will work fine... But is this the best way
or am I waisting my time with complecated tasks?

Thank you in advance

 

[Guest]

The way you want to do it is okay. My question is, what exactly are you
trying to accomplish? Are you just sharing data from one application to
another, or are you trying to make duplicate data in two copies of a database?

 

[Guest]

Dear Klatuu,

What I want to do is to have a main (master) database in my office which
will be updated with all records of several users having their own dataabase.
My database will have the final records of them.

Ο χÏήστης "Klatuu" έγγÏαψε: