Hello,
Thank you in advance for your assistance.
Issue MS Access:
I have been using Workdays Function I found in Microsoft help with no problems, but I started getting the error "Error 3052: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry" with a header of "Workdays" at the top. I had previously fixed this with the following:Private Sub Form_Load()
DAO.DBEngine.SetOption dbMaxLocksPerFile, 3000000
End Sub
Now it has started again when I am running a query using Workdays([Date1],[Date2]).
Troubleshooting (none of which have worked):
I made sure that the Microsoft Office 14.0 Objects Library was selected.
This database is 257,312 KB, therefore I split it
I did a Compact & Repair
I opened a blank database and imported in the information
P.S. I do not know SQL; everything I am using is either copied or I had help with.