Takodje sam ustanovio da je promjenjen redosled u indeksiranju tabele Ulaz. Znam da je bitan i raspored polja u indeksu, ali kada pokusam da izmjenim u tabelama Izlaz i IzlazStavke javlja mi gresku:
The changes you requested to the table ware not succesful because they would create duplicate values in the index, primary key or relatinship. Change the data in the field or fields that contain duplicate data, remove the index or redefine the index to permit duplicate entries and try again.
U prozoru Help mi daje sledece objasnjenje:
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.
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.
Zasto mi se ovo desava???
Sve sam fino smislio...
Još samo da propadne. :-)