I've got this error when adding a field to table in replica!
This error can appear if:
You have exceeded the maximum number of columns allowed in a table or the maximum number of locks for a single file.
The indexed property of a field was changed from Yes (Duplicates OK) to Yes (No Duplicates) when duplicate data is already present in the table.
If a table exceeded the maximum number of columns, close the database, select Compact and Repair from the Tools - Database Utilities menu option. This will remove column references from a table definition that were marked as deleted (deletions do not actually occur until the database is compacted and therefore they contribute to the column count).
If the maximum number of locks per file was exceeded, you can increase the number by editing a registry entry for the local computer. However, this is not a recommended option.
Find the MaxLocksPerFile registry value using the Windows registry editor (regedit.exe) and increase the value.
The MaxLocksPerFile value is stored as part of the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0
If you edit a value in the Windows registry, there is no guarantee that the change will not corrupt the registry and render Windows unusable. Edit the registry at your own risk. If you do, it is highly recommended you make a backup of the registry before performing any edits.
If you have changed the Indexed property of a field and duplicate data already exists in the table, you can either reset the Indexed property back to the previous setting, or remove the duplicate records from the table.
So I tried to make a design master from my replica and got this message: How to repair it?
Cannot make the <name> object in <name> container replicable. (Error 3583)
An object (table, form, report, module, macro) in the indicated container cannot be made replicable.
An example of an object that cannot be made replicable is a table that has 253 or more fields. Since replication needs to add a minumum of 3 additional fields, this would exceed the 255 field limit.
This error can appear if:
You have exceeded the maximum number of columns allowed in a table or the maximum number of locks for a single file.
The indexed property of a field was changed from Yes (Duplicates OK) to Yes (No Duplicates) when duplicate data is already present in the table.
If a table exceeded the maximum number of columns, close the database, select Compact and Repair from the Tools - Database Utilities menu option. This will remove column references from a table definition that were marked as deleted (deletions do not actually occur until the database is compacted and therefore they contribute to the column count).
If the maximum number of locks per file was exceeded, you can increase the number by editing a registry entry for the local computer. However, this is not a recommended option.
Find the MaxLocksPerFile registry value using the Windows registry editor (regedit.exe) and increase the value.
The MaxLocksPerFile value is stored as part of the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0
If you edit a value in the Windows registry, there is no guarantee that the change will not corrupt the registry and render Windows unusable. Edit the registry at your own risk. If you do, it is highly recommended you make a backup of the registry before performing any edits.
If you have changed the Indexed property of a field and duplicate data already exists in the table, you can either reset the Indexed property back to the previous setting, or remove the duplicate records from the table.
So I tried to make a design master from my replica and got this message: How to repair it?
Cannot make the <name> object in <name> container replicable. (Error 3583)
An object (table, form, report, module, macro) in the indicated container cannot be made replicable.
An example of an object that cannot be made replicable is a table that has 253 or more fields. Since replication needs to add a minumum of 3 additional fields, this would exceed the 255 field limit.