Access 2003 locking up.

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
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.
 
Steve said:
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
Click to expand...
 
Back
Top