Re: Cannot open Access table with ADO or BDE/ODBC

Doug Stephens wrote:

I'm using Delphi 7 to open an MS Access table and it just runs forever
at 100% cpu. Other tables open OK. I've tried it with both BDE and ADO
- same result. Thought it must be corruption, but I repaired the db in
Access. Also exported to SQL then imported back to Access, no change.
No errors during this process.

If I remove all indexes, then it opens immediately. Put back 1 index
and it runs off into the night like before.

Any ideas?

could you show us your connection string? What version of JET are you
using to connect via ADO? Have you checked the MDAC version or repaired
it?

--
Best regards :)

Guillem Vicens Meier
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages

  • Re: Word 2003 fails to Open
    ... There are two kinds of normal.dot: those that contain some kind of corruption, ... Blog: http://word2007bible.herbtyson.com ... > screen then freezes. ... It never opens a Word document or even an empty ...
    (microsoft.public.word.application.errors)
  • Re: CHANGING from DAO to RDO
    ... > For a long while, Microsoft was heavily promoting ADO, but in recent times, ... > I don't know _where_ you got the idea that ADO and RDO were the only methods ... > DAO and, for them too, DAO was simpler and easier. ... > found about performance and avoiding corruption in the Access - Jet ...
    (microsoft.public.access.modulesdaovba)
  • D7 & ADO with ASA9: EOLEException & Multiple-step error
    ... If I rest my pointer over the ".AsString" part of AdoDataMod.aquGetClipReadOnly.FieldByName.AsString, I get the yellow ribbon hint with the text "Delphi Exception EoleException at ... I tried removing the fields from the ADO query, I tried adding them back in again, I tried closing everything and rebooting - so far so bad... ... The BDE version has been working with identical data for nearly 10 years without a hitch - it still is. ...
    (borland.public.delphi.database.ado)
  • Re: BDE support??
    ... > We have an application that is using controls descended from TDatabase, ... > we'd like to convince the higher ups to ditch the BDE and move to ADO. ... Very nice for unit testing, ...
    (borland.public.delphi.non-technical)
  • Re: Unexpected quit on doc close/quit
    ... standard procedure to uncorrupt documents, ... that these documents contain corruption at the time you first receive them. ... Now quit Word. ... > successfully re-open one of these corrupted docs (the doc actually opens ...
    (microsoft.public.mac.office.word)