Corruped data

  • Thread starter Thread starter Wayne Huxman
  • Start date Start date
W

Wayne Huxman

I'm having issues in a multiuser set-up with data fields becoming corrupted.
It appears like carriage return characters are gettign into fields and data
in other fields is getting pushed into the next field etc..

Are ther any special key combination that cound cause this or could it be
asscoiated with pushing the practical limitations of it's mult-user
capability?

If anyone has had a similar issue and has any comments of suggestions it
would be appreciated. Thanks in advance.

Regards,

Wayne Huxman
 
1. Just how many users do you have in the database?

2. When was the last time you compacted the data?

3. Is your database split with only the data residing on the server, and
each user having his own copy on the desktop?

To cure the corruption, make sure that numbers 2 and 3 of the above are
implemented. Having too many users usually causes problems with recordlocks
long before there are corruption problems. The 2 most often causes of
corruption are both generally manifestations of the same reason, i.e.
disruption of a write to the database. If the state is in edit mode and
either a user shuts down inappropriately (just turns off the machine) or a
NIC fails, there can be corruption. Notice, I said, can. Databases don't
automatically corrupt when one of those reasons happens.

Have a look at Tony Toews corruption pages for more information:

http://www.granite.ab.ca/access/corruptmdbs.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
there may be as may as 6 to 8 users at a time. The data is comacted on a
reqular basis. The database is splt with a front end on each desktop.
Thanks.

Wayne
 
Back
Top