Corruped data

[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

 

[Arvin Meyer [MVP]]

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

 

[Wayne Huxman]

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

 

[Arvin Meyer [MVP]]

^ to 8 users is light usage. I have 50 in my tables at any given time. I'd
look for one of those users doing something improperly. Perhaps, it is a
recent hire who could use a bit more training.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access