Automation error when opening Access database

**GWB** · 04-26-2010, 12:22 PM

This runs but returns an "run time" and "automation error" I dont know why.

Thanks in advance for help

Please Login or Register  to view this content.

**GWB** · 04-26-2010, 12:24 PM

After running debug it shows at this line:

Please Login or Register  to view this content.

**GWB** · 04-26-2010, 01:23 PM

Well, at this line: If Not (.EOF And .BOF) Then

I get: error 3709 Application or object defined error

**romperstomper** · 04-26-2010, 04:55 PM

Your SQL string is incomplete. You have not specified a FROM clause.

**GWB** · 04-26-2010, 05:04 PM

Thank you. I had deleted most of the query to try and troubleshoot it, ended up with:

Please Login or Register  to view this content.

I didnt know I needed to add "strQuery = strQuery &" to every arguement

re: Automation error when opening Access database