| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
| How do I access the access data via Excel 2002 with auto update ? | Excel Programming | |||
| Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
| Calculate data from Access and return to Access | Excel Programming | |||
| Access data -work in Excel- save in Access | Excel Programming | |||
Hybrid Mode
