| 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 |
| 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 | |||
Threaded Mode
