Access error 3197

[Jim]

I'm having the same problem. This is the second time it
has occurred in about 3 months. I did notice that the
file size had decreased from 31 to 24 megabytes (I backup
daily) which leads me to think that the database file was
somehow truncated during use. The mdb is on a Compaq Evo
6000 running 2000 Pro that is working perfectly and is
used as a file server only. Four workstations are used to
enter billing information into the database. Any
suggestions will be appreciated.

 

[Ken Snell [MVP]]

Sounds as if everyone is using the same copy of the database. This is a very
common source of corruption. For multi-user setups, you should split the
file into a backend and a frontend, keep the backend (tables) on the server,
and give everyone their own copy of the frontend (forms, queries, reports,
etc.).

See Tony Toews' website for more info:
http://www.granite.ab.ca/access/splitapp/index.htm

 

[Jim]

Thanks Ken... I didn't know it mattered. It's been
running like this for over a year with only one other
incident. I would never have figured this one out without
help. Thanks again!