Exclusive Rights Error in Access 2003?

R

Randy

I have a FrontDesk Access 2003 Program that I have split for multiple
users (2). I have the Front End on their C drive and the Back End on
their G drive which is a shared network drive. Whenever they access
the program at the same time the program is either freezing or they
get and Exclusive Rights error message.

What do I need to do to fix this? The Option settings are set to
shared.
 
J

Jason Sharp

On the Options "Advanced" tab set:
Open database -Shared
Select "Open database using record-level locking."
 
R

Randy

I have done all that with the database, but now it freezes whenever a
staff person is trying to enter a new record.

I think it is because it creates a blank record automatically then when
two people try to create a new record I am getting a conflict. Is
there a way to prevent Access from automatically creating a blank
record when a new record is entered or is there another setting I need
to look at?
 
J

Jason S.

I thought about this quite abit after posting. If your following: Having read
the changes between '97 and 2000, and with** JET4: the handling of requests
in a multiuser environment was significantly overhauled. The software design
is such that you're not actually dealing with the table (per se). The phasing
out of DAO in favor of new technology made these improvements possible. I'm
not hacking DAO, but it could be useful to update procedurely [not simple].
Check your ODBC settings on the file-database server. That said, I don't
know, you're best bet right now is to check the books. Hopefully, there is an
easy solution to what sounds like a simple problem. Create a database schema
report, you'll find this under Tools (documentation).
 
Top