Allow only one individual at a time

[mattalexx]

Using Access2k VBA, is there a way to limit the number of people who are accessing a backend db from their frontend db to one individual at a time? I don't want to setup Access security.

Any ideas?

[Ecniv]

Doesn't that defeat the point of having a front n back end ?

How about your front ends are readonly OR use a table to distinguish whether they can be read only or write as well ?

Vince

[mattalexx]

Originally posted by Ecniv
Doesn't that defeat the point of having a front n back end ?

How about your front ends are readonly OR use a table to distinguish whether they can be read only or write as well ?

Vince

I want a front/back-end because If I have many people over the network accessing the same mdb file, the file will corrupt more often (and when it does, everyone's out of comission, not just one user).

The frontends need to be read/write. I don't understand: "use a table to distinguish whether they can be read only or write as well"

Thanks for your help

[Ecniv]

I was assuming you wanted only one person to write to the database at a time.

Corrupting as in form corrupting or just mucking up and requiring repairs ?

How many users?


Vince

[mattalexx]

It's unhealthy for an mdb file to be opened on more than one computer on a network, because the file goes bad. Also, the page setup/printer properties can be customized for each user if there is a frontend.

Have you not found this to be true?