error '80004005' on Access DB

[scottrod]

I'm building a project using an Access db and PWS. A frames page populates two combo boxes with information from two tables. No problem so far. The choices the user makes will build my SQL statement for reporting. I make the connection using an include, Jet 4.0 Provider. My problem is once I click submit, I'm returned with error '80004005' Unspecified error. I'm learning as I go so I figured something was wrong with the SQL statement. I changed the SQL statement to pull on another table within the DB and it works. I'm receiving the error only in regard to the table I want data from (figures). For example mySQL="SELECT * FROM Months" works but mySQL="SELECT * FROM Names" returns the error. The Months table has two fields, ID and Month, 12 records. The Names table has 14 fields and 85 records. I use a Do While Not EOF to dump out the recordset.
If I haven't provided enough background information, I'll be happy to provide it.

 

[DiamondSyxx]

Since you get the error when you switch to a significantly larger table, it's probably a timeout error. Try changing the DNS timeout settings.

 

[denoxis]

Dump the SQL statement to the screen with response.write, then copy & paste it to the Access Query Editor.

There are some weird reasons that can cause these kind of errors (for example selecting A datatype field after B datatype field etc.)

 

[scottrod]

Forgive me, but I haven't quite experienced all the DSN DSN-less connection strings and haven't found what I'm looking for online. Do I increase the timeout settings with the provider (I'm providing with string in global.asa, first foray there) or when I make the connection (provided in separate include file, more forays) or when I create the recordset object?

 

[scottrod]

Well, I figured it out, but don't understand the problem. I changed the table name (F2, type away) changed my code to reference the new (same old) table. Works like a charm.

Thanks for the assistance though.