Data from Access using ADO

[Guest]

Hi,

I am retriving and updating data from an Access database using ADO.
All working fine when I have the Access database open on my machine.
But as soon as I close it down I get the following error:

"
Run-time error '-2147467259 (80004005)':

Cannot open database ". It may not be a database that your application
recognizes, or the file may be corrupt.
"

( I have Microsoft ActiveX Data Objects 2.8 Library tick in my VBAProject
Reference)

Any idea what do I need to be able to have it working without having the
access database open?

Many Thanks

Mark

 

[NickHK]

The db file need not be open to work with ADO.
Post your code.

NickHK

 

[Guest]

Thanks NickHK,
I just found out that the only thing missing was that I did not setup an
ODBC connection - once setup it is working fine.
Cheers,
Mark