Exclusive mode- why it doesn't work?

L

Lanceu

I'm having an issue where a database used for quarterly audits is
getting errors when multiple users try to add records at once. The
simplest solution would be to limit it to one user at a time.
Tools>options>advanced>exclusive seems to fit the bill, but I
implemented this and had another user open the database and it did not
prevent their session. The file lives on the intranet, not sure of the
configs for that.

Any ideas??
 
D

Damian S

Sounds like your front end and back end aren't split... what you want to do
is split your database (tables in one file, everything else in the other
file, with tables linked) and give each user their own copy of the front end.
This will prevent the issues you are experiencing.

Damian.
 
L

Lanceu

All good info - thanks!
I guess more info would help you guys understand this- sorry! The
database is split- with one copy of the front end on a server
accessible via LAN. The reason Exclusive wasn't working was because
that setting was only on the profile I set it on. When I had another
user log on- it was not exclusive. Joseph- your idea of having a copy
for each user seems like the immediately workable answer, but one that
will require routine attention as employees migrate by location and
out of the company, and ~100 potential users over time.

So I guess my direct question was- can I set it so that when other
users open it -it will be exclusive??
Maybe via VB. . ?

Tx,
Lance
 
P

punjab_tom

wow.

you don't need to split.
you need to learn SQL Server.

Move everythign to sql server; learn how to write views and stored
procedures.. and you won't have to deal with any of this headache

MDB has been obsolete for 10 years now; I sure don't spend time
linking tables, updating connection strings; rofl

-Tom
 
L

Lanceu

Yep you are right.
I could migrate it to our SQL server system, I was just wishful in
thinking a few keystrokes could make the problem go away.

Thanks!
-Lance
 
Top