Share via

Multiple Users Accessing Database

Anonymous
2010-10-20T21:42:55+00:00

Hi,

I currently have a database sitting on a computer that is sharing the database with other computers.  If someone logs into the database on the computer that it is sitting on first, another user (from another computer) cant go into the database.  If a different user (person that is networked to the database) goes in first, then the user who has it on their computer can go on too.  Any ideas what is going on.  If it makes any difference, there are tables that are linked to this database. 

Thanks

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-10-20T22:04:24+00:00

A shared database should be "split" into a shared Backend (containing only tables), and a Frontend containing all your forms, reports, queries and code. Each user should have their own individual copy of the frontend, all linked to the same backend over the network. Sharing a frontend, or a single database, is a recipe for corruption, bad performance, and the kind of lockouts that you're seeing.

John W. Vinson/MVP

Was this answer helpful?

0 comments

22 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2010-10-20T23:59:23+00:00

    There is a lot to learn when you first start developing.  I've been doing this for more than 10 years and everyday I learn something!

    But, the fact that you ask questions, and are willing to learn means you will get better at what you do.

    Daniel Pineault, 2010-2011 Microsoft MVP

    http://www.cardaconsultants.com

    MS Access Tips and Code Samples: http://www.devhut.net

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-10-20T23:53:58+00:00

    Thanks again for all your help.  I will look into the utility.  If I later decide to look into your script I'll let you know.  I really need to get better at this before I start doing that much on my own.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2010-10-20T23:38:32+00:00

    Yes.  Performance should improve and most importantly, you drastically reduce the risk of your database becoming corrupted!!!

    As for deploying your db.  There are different approaches to do this.  I personally place a copy of the front-end in the same folder as the back-end (on a central server) I then used a vbs script to launch the db.  Part of the script check to see if the version the user currently has is the most recent, if not, copy the new version, then open.  I am more than happy to share this with you if you wish.

    On the other hand, after spending hours, and hours developing, revising,... the vbs script. I became aware of a beautiful utility to deploy the front-end to user.  See:http://www.autofeupdater.com/ 

    One way or another, solutions exist  so that the aspect should not be a problem!

    Daniel Pineault, 2010-2011 Microsoft MVP

    http://www.cardaconsultants.com

    MS Access Tips and Code Samples: http://www.devhut.net

    Was this answer helpful?

    0 comments