Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have discovered a strange apparent bug in MS Access and would like to know if others know it already and hopefully how to get around it.

Trying to count records based on known column categories.

One particular set of records can't be saved or output because of apparently one or more records in that range. They appear to have some corrupt character which is generating a false error message:

"Another user is currently using this record" or words to that effect.

Is there some obscure character (combination) that can cause Access to lock a record? It is physically impossible that anyone else actually has access to the DB.

There could conceivably be all kinds of strange characters in there because the data come from a wide variety of sources.

I think I have narrowed it down to a personal name field but this is not a final verdict...

share|improve this question

1 Answer 1

"Another user is currently using this record" is a misleading error message Access loves to throw out - many times it really indicates you have the table open in another window.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.