Hi all,
i don't know if this is something that's common or not. my company has a HUGE access database (we're up to 7000+ records) and most of the work in access is done in a form with a main form, and then multiple subforms for different parts of the project (writing, billing, etc.), and they are filled in as completed.
for some time now, i've been adding assignments to this database, and just recently, when i enter new information into one of the subforms (if there are existing records already in the subform this doesn't happen), i get the following message:
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." ....and i get this 5 or 6 times in a row.
here's the problem: i'm the only one changing this data at the time!! (and i'm not *changing*, i'm adding information.
if i go back into the fields in question, they say "#Error" however, if i go to the next or previous record in the main form (using the arrows at the bottom of the main form), then return to the record i was just editing, the correct information is there already.
(1) did i explain that clearly?
(2) has anyone else encountered this?
(3) does anyone have an idea what the problem might be and how it can be fixed? (using regular English, i'm not that well-versed in Access language)
thanks!
Trys
i don't know if this is something that's common or not. my company has a HUGE access database (we're up to 7000+ records) and most of the work in access is done in a form with a main form, and then multiple subforms for different parts of the project (writing, billing, etc.), and they are filled in as completed.
for some time now, i've been adding assignments to this database, and just recently, when i enter new information into one of the subforms (if there are existing records already in the subform this doesn't happen), i get the following message:
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." ....and i get this 5 or 6 times in a row.
here's the problem: i'm the only one changing this data at the time!! (and i'm not *changing*, i'm adding information.
if i go back into the fields in question, they say "#Error" however, if i go to the next or previous record in the main form (using the arrows at the bottom of the main form), then return to the record i was just editing, the correct information is there already.
(1) did i explain that clearly?
(2) has anyone else encountered this?
(3) does anyone have an idea what the problem might be and how it can be fixed? (using regular English, i'm not that well-versed in Access language)
thanks!
Trys
Last edited: