The common microsoft answer for this error (which I will post below) does not apply 4 me - because the IUSER_(machine) account has full right to the folder AND the DB.
The error is only when trying to write to the DB - it reads from it fine.
Here it is:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
Can ya help?
10x
The error is only when trying to write to the DB - it reads from it fine.
Here it is:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
Can ya help?
10x