Database needs to be repaired error

[maryj]

Client has an Access 2000 database. The database was recently moved from a
Windows 2000 server to a Windows 2003 server. Since then, the following
message comes up:The database needs to be repaired or isn't a database file.
He repairs the file, it works fine for awhile and then gets the same error.

 

[Ron Hinds]

Are they using a wireless network? They can cause corruptions.

 

[Tony Toews]

Client has an Access 2000 database. The database was recently moved from a
Windows 2000 server to a Windows 2003 server. Since then, the following
message comes up:The database needs to be repaired or isn't a database file.
He repairs the file, it works fine for awhile and then gets the same error.

As Ron mentions wireless network computers can definitely cause this
problem. But there are also many other problems. Is the Win 2003
server up to date on it's service packs? While unlikely at this time
older service packs had some troubles with Access particularly with
respect to the OpLocks problem.

Are there any other Access databases residing on that server? Are
they running smoothly? If not then I'd suspect a flaky network card
or slightly loose cable.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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

 

[maryj]

I don't know if the network is wireless. The client did tell me they have
other databases on that server that work fine.