Multiple Users Accessing Database

Question

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

Answer 1

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

Answer 2

Would someone be patient enough to explain to me how to "split" a database so that two remote users can use it?  Can we have the database run from SkyDrive?

You cannot. Access is not designed to work over the Internet. IT SIMPLY WON'T WORK.

Your alternatives are to use A2013 (the 2010 version is buggy) to convert your database to a Web application; to use some type of remote terminal access such as RDP or Citrix Server to let the remote user log on to the computer contaiing the database; or to move your data into SQL/Server and expose the SQL instance to the web, with appropriate nontrivial security provisions of course.

Answer 3

Would someone be patient enough to explain to me how to "split" a database so that two remote users can use it?  Can we have the database run from SkyDrive?