Hello All,
Wondering if I can get some assistance, both methods of querying my access (.accdb) databases that were working in Office 2010 are now causing Excel to hard lock and crash when opening a connection.
Please Login or Register to view this content.
Maybe try ADO. I have not tested this but maybe something like:
Please Login or Register to view this content.
Both ADO and DAO result in a hard crash
Sounds like you may need to reinstall MDAC drivers.
Which version of ADO and DAO reference do you use? Is Office 32 or 64 bit?
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Microsoft ActiveX Data Objects 6.1 Library
Microsoft Access 15.0 Object Library
32 bit
Access 15 is not DAO reference. You mean Access Database Engine?
Is better to Set variables to New object, not declare As New
I apologize, it's "Microsoft Office 15.0 Access Database Engine Object Library"
The crash happens with early or late binding.
Originally Posted by Izandol
Database will open manually with no error?
Correct, and I can query the .accdb using OLEDB with a C# app.
Does code crash with all databases or only this one? If it is all I think you must reinstall MDAC to begin as Kenneth says. This code has worked before with Excel 2013?
All- I've resolved this crash by removing all references from the Excel file in the project editor, saving the file, then re-adding the references.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks