Re: 'Unrecognised database format' error

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Val Mazur (group51a_at_hotmail.com)
Date: 10/06/04 

Date: Tue, 5 Oct 2004 22:30:02 -0400

Hi,

Usually this error occurs in a case if database is corrupted or application
tries to open database in Jet 4.0 format using Jet 3.5. If you are able to
connect sometimes, then most likely you database is corrupted and it could
be in a case if you use bound controls, which would not close recordset.
Also check if your application closes all the opened recordsets/connection.
If you leave some resources opened, then it could lead to the corruption of
the database 

-- 
Val Mazur
Microsoft MVP
"StuartBarrett" <stuart@gsdassociates.co.uk> wrote in message 
news:O3WY%23zfqEHA.2900@TK2MSFTNGP12.phx.gbl...
> Hi
>
>
>
> I have a users site which is getting an intermittent  'Unrecognised 
> database
> format' error when connecting to an MSAccess 2000 database using ADO 
> within
> a Borland Delphi application.
>
>
>
> The  site consists on 10 client machines running a mixture of Win2000 and 
> XP
> machines all with the latest service packs (including XP SP2) and Jet 
> Engine
> SP8 installed. The clients are serviced by a Windows 2000 server with SP4.
>
>
>
> Being an established site running the software successfully for the last 
> 18
> months this error has only been occurring during the last month or so. It
> seems to occur randomly where they can have days without a problem and 
> then
> on another day they have to repair the database 5 or 6 times. Up to now we
> have assumed that there must be a rogue machine causing the data to become
> corrupted but after extensive testing, swapping of LAN Cards and isolation
> of machines over the last month we have not been able to identify the 
> cause
> of the problem. Also as far I can tell from questioning the users IT 
> Manager
> no changes have been made to their systems which might have triggered this
> problem.
>
>
>
> Has anyone else had this problem, if so how did you resolve it, or can
> anyone suggest the likely causes of this error.
>
>
>
> Many thanks
>
>
>
> Stuart
>
>
>

Relevant Pages

  • Re: Possible DB corruption
    ... I think the highest version of Jet is 4.0. ... always work on a copy of the database. ... Then have a look at Tony Toews' Access Corruption FAQ at: ... Click OK, second error msg: Name conflicts with existing module, object ...
    (microsoft.public.access.formscoding)
  • Re: SQL Server corruption chance
    ... Database gets corrupted pretty often. ... > just general statement about SQL Server stability and robustness. ... know folks that have written excellent applications using Jet as a back end ... supporting 30 to 50 users without any corruption. ...
    (microsoft.public.sqlserver.setup)
  • Re: Attempt to fetch logical page
    ... You have a corruption in your database. ... Second, if you are on SQL Server 2000, check the specific recommendations for your error. ... This error occurs when Microsoft® SQL ServerT detects database corruption. ... execute DBCC CHECKDB to determine the extent of the damage. ...
    (microsoft.public.sqlserver.server)
  • Re: Lost Table Definition
    ... data pages are still intact at first, but Jet does housecleaning, and will ... If the corruption is caught quickly enough and the corrupted table ... to reconstruct the table for you in a brand new database file. ... You'll have to use a recovery tool to retrieve the data. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Do Transactions guard against corruption?
    ... when the database is opened and closed. ... meant by 'corruption'. ... Transactions have NEVER been designed as safeguard for those previous ... not used by Access to protect the structure of the database. ...
    (microsoft.public.access.modulesdaovba)