Data from Access using ADO
 

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

Data from Access using ADO
 

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

NickHK

"mark" wrote in message
...
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

Data from Access using ADO
 

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

"NickHK" wrote:

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

NickHK

"mark" wrote in message
...
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