Hi,
I currently have an ongoing issue using ADO with Excel as the BE database.
My application uses an Excel (2010) workbook as a backend to store the required data, then uses another excel workbook to query (Using list objects with data connections) and also manipulate and edit the data in the back end using ADO recordsets. I have used this setup as MS Access is not currently an option, and I need multiple users to be able to manipulate and query data at the same time without read-only restrictions.
The issue is that occasionally the excel BE database seems to go into a "Locked state". When in this "locked state", the recordset appears to update successfully. However, when I open the BE database or requery with a new ADO connection the changes have disappeared.
The only way for me to fix this currently is to open the excel BE Database, hit Save and close the workbook.
The most frustrating part is that most of the time it works without issue.
Any help would be greatly appreciated. An example of my connection string is below...
Bookmarks