exporting from a remote computer

[Kevin]

I have a Access 2002 database used for estimating projects. I'd like to have
the ability to use the database remotely, as in a lap top off site, but then
transfer the records into the "home" database which is on a network. I have
never imported or exported data in Access. What is the easiest way to
achieve this? Do I just save a copy of the database to the lap top and use
the TransferDatabase action? Also, what about the possibilities of
transfering the data via email?

Thanks for any suggestions!

 

[Roger Carlson]

You need to look into Replication. There is an MS newsgroup for that.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[John Nurick]

Hi Kevin,

If the laptop will be connected to the network often enough to update
that way, and email is not required, Access's built-in Replication
facility may be just what you need - but research it carefully first
because there are some non-obvious consequences and limitations.

Otherwise, a lot depends on the size and structure of the database and
whether you want to keep the laptop and "home" versions synchronised or
whether the transfers just go from laptop to home. One common technique
is to write code that

1) creates a new, empty mdb file
2) uses TransferDatabase or make-table queries to copy the relevant data
into it

Then email or upload the "transfer" file to the home system where the
contents are imported.