Property value is too large? WTF?!Baza ima jednu tabelu koja ima preko 200 polja. Sve je dobro funkcionisalo do danas, kada sam hteo da promenim par polja u dizajnu tabele (samo nazivi i opis, osobine su ostale iste) i nakon što sam pokušao da snimim, dobio sam sledeću poruku:
Property value is too large
OK
Nakon klika na OK, dobijam novi dijalog u kome piše "Error encountered during save operation", a tu je i dodatni "help" da pojasni celu stvar:
Citat:
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.
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.
Potpuno mi je jasno šta ovaj "help" kaže i jedino mogu reći da je to nebuloza. Ta tabela je bila i veća nego što je sad i radila je sasvim normalno. I u istom obliku radi u starijim verzijama baze. A takođe, compact & repair radim svakodnevno, po barem 50 puta, tako da nije ni to.
Deo sa editovanjem registry-ja takođe nema smisla, pošto bi to (ako bi uopšte rešilo problem) bilo delotvorno samo na mojoj mašini, što je bezveze.
Još nešto - probao sam da importujem istu tu tabelu iz ranijeg backupa, u kome radi (i gde je ta tabela identična) - i ništa. Greška se opet javlja, što implicira da problem i nije do tabele, iako grešku javlja samo u design-view-u tabele.
Ima li neko ideju?
Pozdrav i hvala
