J
jwflutterby
I'm thinking this might be some type of user error but I'm not sure how
they are doing it so I'm not sure how to fix it. I have a person that
keeps having trouble with Access files. It started out just happening
when they were working with a file on a network drive that they have
exclusive access to. When they were adding comments in a memo field, an
error would come up when they tried to save the record that says "The
Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."
The contents of the memo field would then be replaced with #Error and
the same error message would come up every few seconds.
When this happens I can do a Compact and Repair on the database which
eliminates the error messages but it replaces the contents of the memo
field with ################. This comment field is an ongoing record of
all contact the user has with a customer, when this problem happens,
they lose all of this information which has caused a lot of headache.
At first we thought it was an issue with the user's Access application
so we re-installed Office. That didn't help so to eliminate the
possibility of something they might have downloaded causing the problem
we gave them a new PC. That didn't help either. We made sure they
didn't have the file open multiple times or anything and verified that
the file was in a folder on the network that no one other than the user
could access (well, sys admins can technically get to it too but we
don't).
We thought possibly the problem was related to the Access file even
though it had been recreated a couple times (they have an empty
template database file that they copy then populate with an individual
user's data) because it was the only file the user was having trouble
with until today. Today she tried to open a copy of someone else's
database that was in a public folder and the same problem happened.
Even though she does not have exclusive access this folder, everyone
else with access was accounted for so we know no one else had it open.
Several people use the "same" database (files created from the same
template but with different data) without any trouble, only this user
is having trouble. It only seems to happen when modifying this comment
memo field, is there some key combination she could be pressing to
cause this? The field contains a lot of text, is there some type of
limit she could be hitting that could cause this problem? Anything I
could be missing? Thank you in advance for any help!!
Jenni
they are doing it so I'm not sure how to fix it. I have a person that
keeps having trouble with Access files. It started out just happening
when they were working with a file on a network drive that they have
exclusive access to. When they were adding comments in a memo field, an
error would come up when they tried to save the record that says "The
Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."
The contents of the memo field would then be replaced with #Error and
the same error message would come up every few seconds.
When this happens I can do a Compact and Repair on the database which
eliminates the error messages but it replaces the contents of the memo
field with ################. This comment field is an ongoing record of
all contact the user has with a customer, when this problem happens,
they lose all of this information which has caused a lot of headache.
At first we thought it was an issue with the user's Access application
so we re-installed Office. That didn't help so to eliminate the
possibility of something they might have downloaded causing the problem
we gave them a new PC. That didn't help either. We made sure they
didn't have the file open multiple times or anything and verified that
the file was in a folder on the network that no one other than the user
could access (well, sys admins can technically get to it too but we
don't).
We thought possibly the problem was related to the Access file even
though it had been recreated a couple times (they have an empty
template database file that they copy then populate with an individual
user's data) because it was the only file the user was having trouble
with until today. Today she tried to open a copy of someone else's
database that was in a public folder and the same problem happened.
Even though she does not have exclusive access this folder, everyone
else with access was accounted for so we know no one else had it open.
Several people use the "same" database (files created from the same
template but with different data) without any trouble, only this user
is having trouble. It only seems to happen when modifying this comment
memo field, is there some key combination she could be pressing to
cause this? The field contains a lot of text, is there some type of
limit she could be hitting that could cause this problem? Anything I
could be missing? Thank you in advance for any help!!
Jenni