RE: Corrupt Access DB
- From: boblarson <boblarson@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 15 Jul 2008 22:29:21 -0700
Do you have any record locking enabled? We had a client who kept having that
same issue as they kept having two people trying to access the same record at
the same time and we had to implement record-level locking to avoid that.
They haven't had the corruption issue since.
Don't know that it will help in your case, but that is just an idea.
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
"samolito@xxxxxxxxxxx" wrote:
I'm working with a multi-user (front end and back end) Access DB that.
has been behaving very strabgely recently, and I'm not sure why.
Symptoms include: rows in tables changeing to all ###s or to Chinese
or Russian characters, the table or query section being erased (i.e.,
the tables/queries I created all get wiped out, leaving only the
default Access icons), the error message "AOIndex is not an index in
this table," the "unrecognized database format" error message, and
others.
Obviously, this database has become corrupted. However, I can't seem
to fix it. I've compacted and repaired, only to have the problems
return quickly. I've also imported all of the database items into a
blank Access database and rolled that version out to the users, but
the problems still come up. Does anyone have other suggestions for
me?
I'm using Access 2003 on an XP Pro system. This database worked well
for several years, and it's only been in the last few weeks that it's
become very difficult to work with.
Thanks,
Sam
- References:
- Corrupt Access DB
- From: samolito
- Corrupt Access DB
- Prev by Date: Re: Access macro: How to output 3 queries to 3 tabs in 1 Excel wor
- Next by Date: RE: User ID's
- Previous by thread: Corrupt Access DB
- Next by thread: Re: List of Actions and what they do
- Index(es):
Relevant Pages
|
