Data Corruption

  • Thread starter Thread starter N Lawton
  • Start date Start date
N

N Lawton

We have multi user Access 2000 database.
This application uses an mde front end and an mdb back end.
All machines are Windows 2000 (sp3) and Access 2000 (Jet sp7).
Most of the time different users are in different parts of the database
and/or editing different records and there is no problem, however virtually
any time 2 people try and add a record at the same time we get some form of
corruption or lock up.
Some times it manifests as ####### through each column, sometimes we get
Deleted through each column in the record, others we get a "search key not
found in any record" error and a few others thrown in for good measure.

What am I doing wrong?
Can you not add 2 records at the same time in Access?
I realise that without specifics it may be difficult to say what is wrong,
but if anyone has any pointers as to where to look I would sure appreciate
it.

Thank you.
 
N Lawton said:
We have multi user Access 2000 database.
This application uses an mde front end and an mdb back end.
All machines are Windows 2000 (sp3) and Access 2000 (Jet sp7).
Most of the time different users are in different parts of the database
and/or editing different records and there is no problem, however virtually
any time 2 people try and add a record at the same time we get some form of
corruption or lock up.
Some times it manifests as ####### through each column, sometimes we get
Deleted through each column in the record, others we get a "search key not
found in any record" error and a few others thrown in for good measure.

What am I doing wrong?
Can you not add 2 records at the same time in Access?
I realise that without specifics it may be difficult to say what is wrong,
but if anyone has any pointers as to where to look I would sure appreciate
it.
Click to expand...

Depending upon how the tables and locking are set up, records on the same
page are locked. Try setting your database to lock the edited record,
record-level locking in Tools ... Options ... Advanced tab.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
N Lawton said:
We have multi user Access 2000 database.
This application uses an mde front end and an mdb back end.
All machines are Windows 2000 (sp3) and Access 2000 (Jet sp7).
Most of the time different users are in different parts of the database
and/or editing different records and there is no problem, however virtually
any time 2 people try and add a record at the same time we get some form of
corruption or lock up.
Some times it manifests as ####### through each column, sometimes we get
Deleted through each column in the record, others we get a "search key not
found in any record" error and a few others thrown in for good measure.

What am I doing wrong?
Can you not add 2 records at the same time in Access?
I realise that without specifics it may be difficult to say what is wrong,
but if anyone has any pointers as to where to look I would sure appreciate
Click to expand...

Presumably you mean two records to the same table at the same time.

Does each user have their own copy of the FE? Do all the users have
the same SR and Jet SP version installed?

Hmm, ACC2000: "Search Key Was Not Found in Any Record" Error Message
During Compact or Save http://support.microsoft.com/?id=301474 might
be related.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top