Transferring data to laptop

  • Thread starter Thread starter Haim Beyhan
  • Start date Start date
H

Haim Beyhan

Hi,

I have an Access XP project, connected to SQL Server 2000 and it's working
fine in the local network.
I have a laptop that I want to install the project on it and work remotely
with current data.

Is there any possibility to transfer the data from SQL Server to the laptop
in an easy way? There is no
need to update the records or synchronize back. Our goal here is to run the
application in order to get
the reports or enter to some forms in order to check the records.

Any ideas? Any other options for working remotely ?

Thanks in advance.

Haim Beyhan
(e-mail address removed) (remove nospam_ in order to send mail)
 
Many options.

First one, install MSDE (come free with Access) and use one of the
replication models to transfert data (with ou without synchronisation)
beetween MSDE on the Laptop and SQL-Server. You can also use a DTS pump or
make you own VBA code with ADODB to transfert data. Replication and DTS
are fully explained in the SQL-Server help file.

As SQL-Server is your backup, all of the easiest options will use MSDE
as a local database on your laptop. But if you want to, you can also use
MDB as your local database. These methods will work even if your laptop
connect to the SQL Server via Internet as well a via a LAN.

Finally, you can write some sort of code to transfert data via email,
probably using XML as the intermediary format.

S. L.
 
Back
Top