Fix Sharing Lock Count Exceeded;  

or Data File Too Old to Update error

The number of files that can be simultaneously open and locked while replacement files are being processed in the same database is determined by settings in your Windows Registry (specifically its Microsoft "Jet" Access database engine). This limit is primarily a security feature to prevent databases from becoming unstable and corrupted due to too many file changes in a single open session.

A file share lock count exceeded (or data file too old) error when updating CTI Navigator indicates that the MLS data in your computer is too out-of-date, or the data file (Mls.mdb) on this computer has been corrupted. To fix this problem, close CTI Navigator desktop and either set Navigator to use data over the Internet, or install new MLS data as follows.

  1. Set Navigator to Internet Data: click the Setup button on the login screen and change the Data Files setting from "This Computer" to Internet. Note that when using MLS data over the Internet there is no Update button on the login screen because you are not using the data on your computer;  OR

  2. Install new MLS data: new data can be installed either over the Internet or from disk.<\p>

    1. To install over the Internet: click here to run CTI's Data Downloader to reinstall the MLS listing data over the Internet. When you run CTI's Data Downloader, check "MLS Data" on the Downloader screen, click the Download button, and click Yes to replace the existing data with the new data file (even if it appears to be newer). For more details on installing data over the Internet, select "Download CTI Navigator program, or MLS Data" on CTI's Help and Support website.
    2. <\p>

    3. To install from current installation CD(s): insert disk 1 > select Install Listing Data only > un-check Photos (and uncheck Taxes, if listed) but leave "Listing Data" checked > click install. 

Update after reinstalling data. To easily observe the update process, select Start > All Programs > CTI Navigator  > Update Manager > click the Update button. To keep from having an excessive number of changes in any one update session, you should either update more frequently (at least once every week); or, if your computer is always connected to the Internet, set CTI Navigator to access MLS data over the Internet (as described in step 1 above).

It is not usually necessary, but sometimes a corrupted data file must be deleted before the new file can be saved. If the existing Mls.mdb file cannot be replaced automatically (step 2 above), close CTI Navigator (and Update Manager) > browse to  {see note 1 below}\CTI Navigator\{YourMLScode}\Data\ > select Mls.mdb and delete this file (do not delete Mlss.mdb or MLS.mdw). 

Security filtering programs can sometimes corrupt downloaded files, especially program update files. If you incur another error during updates, ensure that the security is properly configured on your computer to allow CTI Navigator to update (as described in the related article below, "Configure Security Settings..."). Otherwise, follow the instructions in the related article below, "Update Problems."

Note 1. The path to the "\CTI Navigator\{YourMLScode}\Data\"  folder for your MLS data depends on when you installed the CTI Navigator Desktop program, and into which version of Windows it was installed.

Note 2: Where instructions refer to {YourMLScode}, substitute CTI's 3-letter code for your local MLS. This code can be determined by opening the CTI Navigator login screen > click the Setup button > the MLS code is the first 3 letters in the Internet Server Address box.

Note 3: It is not recommended (see warning below), but you can change the file share lock count setting in Windows as follows: 

  1. Go to Start > Run > enter Regedit in the Open box
  2. Scroll down the left pane and progressively select HKEY_LOCAL_MACHINE > SOFTWARE > Microsoft > Jet 4.0 > Engines > Jet4.0
  3. On the right pane, select MaxLocksPerFile
  4. Click Edit > Modify 
  5. Under Base, select Decimal
  6. Under Value Data, add one zero to the end of the number (typically change 9500 to 95000)
  7. Click OK button > File > Exit.

Warning: Always be extremely careful making any changes in your Windows Registry (since mistakes in the Registry could cause Windows not to run). Also beware that increasing the file share lock count could increase the chances that any database on your computer might corrupt itself when recording changes to a large number of files. (For details, see "File sharing lock count exceeded" article by Microsoft in related articles below.) 

Back to the top of this page È


Related articles and Internet links:

To return to CTI's menu of Error Fixes, click here or use the back arrow at the top of your Internet browser.

 

 

rev. 05.02.2012