Access 2003 locking up.

[Steve]

Hi,
Using Access 2003, have split the database and each person has their own MDE
file.
Frequently one person will get an error message while entering data into a
form. This locks the database for that person, but everybody needs to get out
before this person can use the database again.

"You can’t save record at this time.
Microsoft Office Access my have encountered an error while trying to save a
record.
If you close this object now, the data changes you made will be lost.
Do you want to close the database object anyway?"

Would appreciate some help with this.

Thanks,
Steve

 

[Jerry Whittle]

Make sure that all users have read, write, create, and delete privileges to
both the BE database file and the folder that holds it.

Being an mde file, it's less likely that it's a corruption issue with the
FE. However you might have network issues causing problems.

 

[De Jager]

Hi,
Using Access 2003, have split the database and each person has their own
MDE
file.
Frequently one person will get an error message while entering data into a
form. This locks the database for that person, but everybody needs to get
out
before this person can use the database again.

"You can’t save record at this time.
Microsoft Office Access my have encountered an error while trying to save
a
record.
If you close this object now, the data changes you made will be lost.
Do you want to close the database object anyway?"

Would appreciate some help with this.

Thanks,
Steve