I constructed a loader from Excel 2007 into Access 2007. Working in VBA for Excel, the macros finds the database in the same folder as the Loader. Everything works fine on my desktop, but when I am working from a shared network drive I get an error on line:
"rst(Cells(1, j).Value) = Cells(lngRow, j).Value" for whichever line is being loaded.
Please see image below for error message: "Current Recordset does not support updating............."
I am pretty familiar with VBA in Excel, but I am relatively new to coding for Access. Please help!
error.JPG
Bookmarks