Updating Database with another Database ?

[joe_brennan]

I would like any suggestions on how best to do the following.

I have an Access97 Database on a server with my exe. The users can then click on a shortcut to
run the program from their workstations.

One user connects to the network with a laptop.

She would like to be able to run the program when she's not connected
to the server.

I'm very open to any way of doing this.

I'll need a database on her laptop, but any of the specifics
of implementing this are beyond me.

Thanks a milion in advance.

[JHausmann]

The Access DB can be copied with a simple file copy. You probably should set the program up so that it accesses one of two local DB's. One will be a database of linkages to the server, the other is a copy of the server. Your code will need to figure out 1) if the database on the server is more up-to-date than the one on the laptop and 2) which database you want to use.