I have recently installed access 2010, and have been transferring data from Access 2003 version.
However files in one of my databases is in excess of 16,000 files.
I can transfer about 6,000 at a time with no difficulty from other forms .. but as soon as i go for large transfers, I get an error message saying ..
"File Sharing lock Exceeded" during large transaction processing ..
Increase MaxLocksPerFile Registry Entry.
I have already gone into Regedit .. but it made no difference.
Does anyone know how I can overcome this problem ?