What are the size limits on the fields?
A. They are listed here. Q. When I try to export, I get a long error that looks like “[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider ‘Microsoft.Jet.OLEDB.4.0’ could not INSERT INTO table ‘[]’. The data violated the integrity constraints for one or more columns.” What’s the problem? A. A mandatory field in one or more events is blank, corrupt, or null. Use the switchboard “Show Field Values” function to find the blank field. Also, look in the MSEL Manager tables for incomplete entries. If that doesn’t work, the NxMSEL Database Administrator can search the database for the problem. Problems in the past have included a JMET with a description but no number and a JEPG command with a color but no name.
