share database without network

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Database developed for local area network but (just found out) the local
network is part of a statewide wide area network and any data entered or
looked up goes to the servers in the capital city and then back to the local
drive. The time delay is about 10 mins. This is outside my control. 3 users
want to be able to use the database on their own computer. The data is
updated approx once a week as roadwork projects are completed at this time of
the year and over the next 3 months.

There is a need to copy the database to 2 other computers each week at this
time of the year. The users open the database using the shortcut on the
desktop. I would like them to be able to copy the database every week onto a
CD or a memory stick without opening the database folder. Then to transfer
the updated database to their own computer without opening the database
folder also.

Could you point me in the direction to go to find a foolproof way to copy
the database onto a CD or memory stick from the shortcut to the database or
from the database itself and them update the database on the other 2
computers. The database will be a single mdb and opened exclusively.

Thanks in advance for suggestions or from anyone who has been there and done
that.
 
Chances are the statewide database isn't an Access database, it may use an
Access database as a front-end for the end user, which has linked tables
from the main server database. So having said this, you probably can't copy
the database to the user's machine nor could you link a new database to the
'backend' as I'm sure the 'powers that be' will prevent this.
 
Back
Top