Automation error is a little strange when working with ADO. Seems to imply
the problem is not in the ADO commands themselves but in the "server" app,
which in this case would be Jet. Are you sure you are specifying the correct
version of Jet? Do you have other ADO code that is successfully able to
access this database, or any Access database on your machine?

I would suggest checking the connection string as I suggested. Have MSQuery
do the grunt work for you. If you can connect via Query, the settings you
see should be the ones to use; if even Query has trouble connecting then I
think you might need to dig into your Office setup.

Sorry again I can't be of more help; I have some experience with ADO and the
typical errors I get trying to connect but have not run across an automation
error as the problem.

" wrote:

The space is supposed to be there, its not my database. It give a
run-time error...automation error while trying to open the recordset.