J
Joel Parker
I have a split database consisting of a Data.mdb file and a Front.mdb
file, accessed with Access 2007. I am sharing this database with one other
coworker, so we've put Data.mdb on a central shared folder, and each of us
have a copy of Front.mdb (actually one of us is running a Front.mde from
the shared folder).
We're having some serious trouble with locking and being able to access
the forms, though. The database contains 5 major forms and maybe 20-30
subforms, all accessing another 20-30 tables with lots of 1:n
relationships.
The problem we're seeing is that it seems as if when one of us has just
one of the forms open, the other can't access any of the forms. When we
try to open one, we get a vague "Error opening form" type message. The
effects vary a bit depending on which forms are open, like for example
when one of us has Form1 open, the other can't access any of Form1-Form5.
But when Form2 is open, the other can access Form4.
I was under the impression that Access could be used in a multi-user
setting without much trouble, just locking the specific records that are
being accessed? This would be a huge hindrance on us if having one form
open on one computer basically locked the other computer out of the
database altogether.
Any thoughts on what might be going on here?
file, accessed with Access 2007. I am sharing this database with one other
coworker, so we've put Data.mdb on a central shared folder, and each of us
have a copy of Front.mdb (actually one of us is running a Front.mde from
the shared folder).
We're having some serious trouble with locking and being able to access
the forms, though. The database contains 5 major forms and maybe 20-30
subforms, all accessing another 20-30 tables with lots of 1:n
relationships.
The problem we're seeing is that it seems as if when one of us has just
one of the forms open, the other can't access any of the forms. When we
try to open one, we get a vague "Error opening form" type message. The
effects vary a bit depending on which forms are open, like for example
when one of us has Form1 open, the other can't access any of Form1-Form5.
But when Form2 is open, the other can access Form4.
I was under the impression that Access could be used in a multi-user
setting without much trouble, just locking the specific records that are
being accessed? This would be a huge hindrance on us if having one form
open on one computer basically locked the other computer out of the
database altogether.
Any thoughts on what might be going on here?