CompareWiz

CompareWiz Hangs when comparing a database with large number of tables!

CompareWiz is closing and cleaning objects in the background, comparing table and query fields usually consumes time and system resources.

Resolution:

Don't try to close Microsoft Access, a very large number of tables could take about 20 minutes to be compared.

CompareWiz 2000 and CompareWiz 2002 have the option to not include the table and query fields in the comparison process.

New objects found in my recently compared database with names that starts with ~~XYZ ?

These are CompareWiz Temporary objects and usually it appears in your database if Microsoft Access was shut down improperly, CompareWiz in normal cases deletes these temp objects after it finishes the comparison process.

Resolution:

You can safely delete these objects manually or run CompareWiz again which will automatically delete these objects.

The Compare process takes a long time ?

There could be more than one reason for this delay.

Resolution:

1.     Check if the database has attached tables, usually attached tables take a long time to compare, try to compare these tables from their source.

2.     Comparing databases across network connections could also prove very slow and will slow the network, try-comparing databases locally.

3.     Databases that contain code errors could also be a cause for slow performance, try to resolve any coding errors and do compile and save before the compare process.

4.     Repair and Compact always improves performance and eliminates database fragmentation, so it's a good idea to do so before comparing a database.       

CompareDataWiz

Error 3112, Record(s) can't be read; no read permission on 'Categories'.

You should have at lest Read data permission on the databases you are comparing.

CompareDataWiz is too slow and Takes a long time to compare between Two Tables.

Comparing Databases across the network will take longer and will slow traffic across the network, depending on the size of data in your database, try to compare large databases locally.

Large amount of data will usually take some time to compare, try to compare and compact both databases before running CompareDataWiz.

No Primary Key or Unique Index was found

CompareDataWiz will compare only tables with Primary or Unique index.
 

No Analysis file was found for the required table

CompareDataWiz was not able to create detail compare between the selected tables because:

·         No read permission on the data was found.

·          No primary or unique index was found.

ReplaceWiz

 ReplaceWiz is too slow especially when searching through Tables and Queries?

There are many factors that affect the speed and performance of ReplaceWiz, some of these are:

1.       The Search process will consume system resources and the faster and more RAM you have the quicker the Search will be.

2.       If you are searching and replacing through a large database it is always best to compact your database, which will significantly improve the performance.

3.       Selecting to Search in Table and Query fields in databases that contain large number of tables and queries would slow performance drastically , so unless you need to search and replace through the table and query fields properties ,disable the Searching Table and Query Fields in the Property Selection page of ReplaceWiz.

Unable to replace properties that have "<Read Only Property>" as a replacement string in the Replace with field in the Search Results Form

These Properties are either Read only properties, or properties that are best done through the Microsoft Access interface like the Relationship field names.

 

ReplaceWiz was unable to commit a selected replacement with the following text "<Invalid argument. >" Appearing in the Replace with field in the Search result form.

The replace string is invalid replacement for the current property, or the Current property is Read only and can't be replaced.

 

ReplaceWiz was unable to commit a selected replacement with the following text "<This property is read-only and can't be set.@@@1@@1>" Appearing in the Replace with field in the Search result form.

ReplaceWiz is trying to replace a property that is read only and can't be replaced.

ReplaceWiz was unable to commit a selected replacement with the following text "<Item not found in this collection.>" Appearing in the Replace with field in the Search result form.

ReplaceWiz was unable to commit a selected replacement with the following text "<<Microsoft Access can't find the field 'field name' referred to in your expression. @You may have misspelled the field name, or the field may have been renamed or deleted.@@1@411730@1>" Appearing in the Replace with field in the Search result form.

ReplaceWiz was unable to find the field to replace, that could be due to renaming a field name and then trying to replace a string using the old field name.

ReplaceWiz was unable to commit a selected replacement with the following text "<You entered the control name 'control name,' which is already in use.@You already have a control on the form with this name, or an existing control has its name mapped to this name for Visual Basic. Visual Basic maps spaces in control names to underscores. For example, My Control and My_Control are treated as duplicate names.@@1@611734@1>" Appearing in the Replace with field in the Search result form.

ReplaceWiz is trying to rename a control or a field with a name that already exists in the same collection.

 

ReplaceWiz was unable to commit a selected replacement with the following text "<The Name you have entered already exist for another object of the same type in this database>" Appearing in the Replace with field in the Search result form.

ReplaceWiz is trying to rename an object (form, Table, Query … etc) with a name that already exists in the same collection.