IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

[JonJacobs]

I get this error when I do a select on any of the tables in my latest database. Programatically in my C# app. I can insert records. I can select without a Where clause. But if I use a Where clause I get this error.



I have done this kind of programming on many Access databases with no problem. But something is wrong with this one.

How can I fix it?

Thanks,
Jon

[Rawb]

First thing I'd try is to Compact and Repair the database. That could be caused by corruption (although I kind of doubt it).

Next, I'd double check how you're connecting to the database from your application If you're using an older method (say an old version of Jet Direct) you could be running into compatibility issues between your chosen Provider and Windows/Access. Since I'm not familiar with C# though, I can't be of much more help than that.

Sorry!

[JonJacobs]

Well, compact and repair didn't do the job. I use ADO for connecting to the database. I don't think the version is the issue. I created the database from scratch using ADO extension. I have done the same thing with MANY other databases I created the same way and connect to the same way and had no problem. I guess this one got corrupted in some way that compact and repair did not detect.

[Rawb]

I've done a little searching on the interwebs and it looks like it may be related to the SQL Query itself.

Can you post both versions of the Query (with and without the WHERE clause) for us to look at?

[JonJacobs]

Select MaxId from Track_Specimen_XS

Select MaxId from Track_Specimen_XS Where Prefix = 'IP'

Same results using other fields, and/or other tables.

[Rawb]

OK, I got nothing. That's a simple, perfectly formed SQL statement.