Re: Saving A database to the desktop

Ram,

Certinly you could have multiple users using the application independently on their local machines. The problem arises when any data changes made by one user will overwrite the existing data on the server... see what I mean? User A and User B both get a copy of the database to use locally. User A enters or edits some data, and then re-submits his copy of the database to the server. In the meantime, User B is editing data on his local copy. Then when he re-submits his copy of the database to the server, it overwrites User A's work.

Or have I missed your meaning?

--
Steve Schapel, Microsoft Access MVP

ram wrote:
I thought they multiply users would be able to drag it to their respective desktop. Would you suggest a different soultion?

The user experience slowness when ever they try to down load something from the share drive.

.

Relevant Pages

  • Re: Updating DB Locally
    ... >> upload would have more total entries than the old one. ... >> there would be no entries on the new server so there couldn't be any ... > be able to synchronize your databases not overwrite them... ... I am the only one that changes the database entries. ...
    (comp.lang.php)
  • Re: Updating DB Locally
    ... the new version that I would want to upload would ... > have to be online when I want to work on the database. ... > entries on the new server so there couldn't be any duplicate ones in the ... be able to synchronize your databases not overwrite them... ...
    (comp.lang.php)
  • Setup question
    ... a stand alone version of SourceSafe installed on our local machines, ... at the database that is kept on a local server. ... Should we have the Database ...
    (microsoft.public.vstudio.sourcesafe)
  • Re: Access application with linked table to MSSQL server, data not updateable
    ... >data on a microsoft SQL server. ... you will overwrite the changes the other user made.' ... >There is no one else in this database except for me. ...
    (comp.databases.ms-access)
  • RE: Migrating to Terminal Services
    ... It’s very slow to export Excel files from the server to local machines ... You can export Excel files to the server first and then copy Excel ... Also, separate stores ...
    (microsoft.public.fox.programmer.exchange)