DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, _
"TEMP", "C:\Users\userA\Desktop\" & iName, True
I have the above code in a VBA module inside Access.
I also have read/write access to the database (and its folder) that was opened prior to this code via the following code
Dim Ac As Object
Set Ac = CreateObject("Access.Application")
Ac.Visible = False
Ac.OpenCurrentDatabase ("\\Fileserver\Everyone\Engineering Database\Database\NM Probill Database\NM Probill Database.accdb")
My problem is, 1/10 times, the database is opened as 'Read-Only' while no-one else is accessing it. This is creating problems for the appending query above.
How do I resolve this? How do I make it force open as 'read-write'?
Thanks for your time!