Access2000 Corruption Problems

[Phil Gamble]

I recently converted an Access97 db (fe + be) into
Accesss2000. It is run on a W2000 server with W2000
clients. Since the conversion the db has become very
unstable ie the backend needs to be repaired very
frequently daily. I have installed the W2000 SP4 as
recommended by the Access 2000 web site. Has any one any
ideas what else I can check ? Interestingly the ldb file
appears as Access.Lockfile9 in explorer, why is this ?

 

[Arvin Meyer]

I recently converted an Access97 db (fe + be) into
Accesss2000. It is run on a W2000 server with W2000
clients. Since the conversion the db has become very
unstable ie the backend needs to be repaired very
frequently daily. I have installed the W2000 SP4 as
recommended by the Access 2000 web site. Has any one any
ideas what else I can check ? Interestingly the ldb file
appears as Access.Lockfile9 in explorer, why is this ?

Have a look at Tony Toews corruption page:

http://www.granite.ab.ca/access/corruptmdbs.htm

Access 97 and Windows 2000 is the most stable combination I've ever run. I'd
first suspect a flakey NIC card. There is an OpLocks problem that can cause
corruption on NT 4 and Windows 2000:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;296264

Microsoft has a KB article on keeping an Access 97 database in top working
condition:

http://support.microsoft.com/default.aspx?scid=kb;en-us;303519
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tony Toews]

I recently converted an Access97 db (fe + be) into
Accesss2000. It is run on a W2000 server with W2000
clients. Since the conversion the db has become very
unstable ie the backend needs to be repaired very
frequently daily. I have installed the W2000 SP4 as
recommended by the Access 2000 web site.

To add to Arvin's posting the first thing I'd do is the OpLocks fix.

Interestingly the ldb file
appears as Access.Lockfile9 in explorer, why is this ?

That's just the description Access 2000 gives to LDB file extension
when A2000 is installed. In A97 it's called 'Microsoft Access
Record-Locking Information."

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