Messages

1

Automation Interface, Add-Ins and Tools / Re: Importing an MSAccess 2007 data model

« on: January 07, 2020, 09:32:49 pm »

  I think all such things are happening because your Access database accdb file is not supported by the Professional Edition of EA (v.10). so in that case will suggest you to convert .accdb file into .mdb format. Well it’s too easy to convert accdb to mdb. To know complete of it’s step, check out the following link:

http://www.accessrepairnrecovery.com/blog/convert-accdb-to-mdb-file-format

2

Bugs and Issues / Re: Issue synchronizing replicas with the master EAP

« on: August 03, 2018, 05:04:16 pm »

 :-[When I ran Access, I got the error:
File sharing lock count exceeded.
The File sharing lock count exceeded error went away when I changed

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Jet 4.0\MaxLocksPerFile from 9500 to 95000.

solution:

At that time I have tried this manual steps to resolve this issue:
1.   Press Windows Key + Rtogether this will open the run window.
2.   Type regedit in Run window and hit Enter to open the Registry Editor.

Navigate Here:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\x.0\Access Connectivity Engine\Engines\ACE (if you’re 32-bit Windows edition)
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\x.0\Access Connectivity Engine\Engines\ACE (if you’re 64-bit Windows edition)
Substitute the placeholder x.0 with 15.0 for Outlook 2013, 14.0 for Outlook 2010, 12.0 for Outlook 2007, and 11.0 for Outlook 2003.

3. In right pane of the registry location, search for the MaxLocksPerFile named registry DWORD (REG_DWORD) whose default value is the main cause of this issue. the default value here is 9500 in decimal base, so make a double tap on the same DWORD to get this:
4. Now in the Edit DWORD Valuebox, increase the Value data from default one to your requirement. Set it to 15000. But make sure the selected base is the Decimal one and click OK.
5. After then close the Registry Editor and restart Windows/File Explorer to see the changes. Now try the file sharing simultaneously and this time you won’t face any issue.

This will surely resolve your issue. but if it won’t then try out the other fixes mentioned here:
http://www.accessrepairnrecovery.com/blog/fix-access-file-sharing-lock-count-exceeded-error