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?
Printable View
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?
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).Quote:
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
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 :D
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
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?