Re: Corrupt Access File

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

PMFBI:

You said there is no easy way. Is there a hard way?

Yes. Can you program binary, and do you have the specifications for the Jet
database file format so that you can check each bit for what it's supposed
to be? The "hard way" is fairly difficult and time consuming, and just not
worth it. If database corruption is common enough in your environment, then
you need to address what is causing the corruption and eliminate it or else
migrate to a more robust database, such as Oracle or SQL Server.

And determining that the file size isn't a multiple of 4,096 bytes (the size
of each data page) is only one determiner of file corruption, and not a very
common one at that. It happens when the database file has been saved in
another file format by a different application and certain data is
reformatted, removing some of the bytes from what was intended to be a
complete database page in the Jet file format.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


.

Relevant Pages

  • Re: Btrieve legacy migration
    ... The first question is to figur eout your file format and database ... and get the white paper on "Finding Your Database Engine Version". ... do a STAT of one of your data files to determine ... or a description of the file format. ...
    (comp.databases.btrieve)
  • Re: Access 95 to 2000 and back question
    ... but in principle you can use ... DBEngine.CompactDatabase to convert the database to Jet ... version 2 file format and then open it with Access 95 and try to make it ...
    (microsoft.public.access.externaldata)
  • Re: Two questions about moving data between a SQL DB and XML
    ... better method of exporting data to a file format for later reimport be? ... Is there a better option than XML? ... dozen tables from one database and importing them into another database ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: does mdac conflict with .net framework?
    ... > it says that i can't use a old db when two different versions of Jet are ... > latest Jet database file format. ... > read or write to a newer Jet database file format. ... Jet Engines and Jet databases on any one box. ...
    (microsoft.public.vb.database)
  • Re: Database Stuff
    ... You don't have to have Access installed to use it's file format. ... Set ogAccess = Nothing ... End Function ' OpenDataBase ... of separate machines such that each person is accessing the same database ...
    (microsoft.public.vb.general.discussion)