I have been accessing 64-bit MS Office 2010 .accdb Access files from 64-bit SQL Server 2008 for six months now via linked servers:
EXEC master.dbo.sp_addlinkedserver @server = N'MyLinkedServer', @provider=N'Microsoft.ACE.OLEDB.12.0', @srvproduct=N'OLE DB Provider for ACE', @datasrc=N'C:\MyPath\MyFile.accdb'
Within the last month, deleting or updating too many records (about 5000 or more) has been giving the error:
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "osdmini_agency" returned message "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.".
I went to modify the maxlocksperfile registry value (as I did six months ago to fix this) at HKLM\software\microsoft\office\14.0\access connectivity engine\engines\ace\ , but the error is still being thrown.