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