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

David-W-Fenton wrote:

Note though that the next version of the AutoFEUpdater will almost certainly no longer be free to use.

Will you be maintaining an older version, even a frozen version that

never changes, as a free version?

I haven't decided that but probably not.  I usually keep the current and last version

available for download.  The idea being that if there is a significant bug on the

current version that you can download the slightly older version.

I think I will continue this process and thus cycle the last free version of my

website so folks who are new to the Auto FE Updater will have to pay me the license

fee.

Tony

Answer 3

David-W-Fenton wrote:

Note though that the next version of the AutoFEUpdater will almost certainly no longer be free to use.

And are you giving better support for your pay version? I'm not sure

how you could do that, given how responsive you are, but...

Hehehe.  Exactly.  How can I give better support than I have?  Although occasionally

I do lose track of emails.

Tony

Answer 4

Tony Toews - Access MVP wrote in

news:*** Email address is removed for privacy ***

m:

Note though that the next version of the AutoFEUpdater will almost certainly no longer be free to use.

And are you giving better support for your pay version? I'm not sure

how you could do that, given how responsive you are, but...

---

David W. Fenton                  http://www.dfenton.com/ contact via website only     http://www.dfenton.com/DFA/

Answer 5

Tony Toews - Access MVP wrote in

news:*** Email address is removed for privacy ***

m:

Note though that the next version of the AutoFEUpdater will almost certainly no longer be free to use.

Will you be maintaining an older version, even a frozen version that

never changes, as a free version?

---

David W. Fenton                  http://www.dfenton.com/ contact via website only     http://www.dfenton.com/DFA/