But what if it's a virus causing this Windows error? If you manage to find the fix, it's something best done by professional technicians or a professional Windows Repair program.
The recommended solution is to use the Reimage professional Windows system repair software which runs a deep scan of your Windows system, finds and automatically fixes system files and components that are causing those Windows errors.
Open "Provider=oledb.12.0; Data Source =G:\Logistik\Enhet Grngesberg\Tidsrapportering\Tidsrapport.accdb" Recordset.
I've change from Share deny Write in one of the dataconnection strings and did following test : 1) write data via VBA to db - OK 2)Updated the table from db via dataconnection - OK 3)added data to write to db and runned the VBA - FAIL.
The Old Value of a combo bound to a multi-valued field yields the current value, not the old value. Because if i update any of the Data Connections in excel for import new data in table format and then tries to run the VBA code that write data into DB the error occurs again. I believe that there is all other data connections that are causing this trouble.Access 2007 introduced major new functionality in both the engine and the interface.Seasoned developers discovered new things are possible, and casual users found more things within their grasp.