Exclusivity errors when entering data after upgrade

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a situation where several databases are not performing as expected
after upgrade from 97 to 2003 but both are related to exclusivity. In once
case users open a simple form and enter data but if the database is opened by
any other users it is reported as in use. Somehow the form thinks it's being
changed instead of just the data. I have another instance where a report will
open for one person.

There are no problems in the Access 97 version of these databases. Thanks
for any assistance!!!!!!
 
Ann

If you have a multi-user environment, I trust you also have a split database
(data on the server, front-ends on each user's PC)...

If the network permissions aren't set correctly on the folder/path/file
where the back-end (data) lives, you can get a situation in which one person
can open the db, but the others are locked out (This falls into the personal
experience category -- it took me most of a week to discover that the
network folks had changed permissions and not told anyone!)

Good luck

Jeff Boyce
<Access MVP>
 
Thanks for your reply Jeff, unfortunately these are not split which is why
it's so perplexing!
 
Ann

If you are saying that you have a single Access database (.mdb file) that
multiple folks are using, you will run into serious issues with corruption
and competition/exclusive use.

Consider looking into "splitting" your database.

Jeff Boyce
<Access MVP>
 
Back
Top