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

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

NickHK

"mark" <(E-Mail Removed)> wrote in message
news:1A60625E-C0EF-4468-9735-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:1A60625E-C0EF-4468-9735-(E-Mail Removed)...
> > 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
>
>
>