There is a PK. A unique INT Indentity field.
The database is not huge. About 1gb in total (mdf). The table itself is about 20 mixed fields (mainly nvarchar) and 21,000 records.
Just been tinkering and tried adding a record manually and it added fine. Now I can add any record through Access I...
Very odd one. Running SQL Server under XP, with Access front end using ODBC. All works fine, but one particular table has a field Company, nvarchar(50), nulls allowed. It used to be fine, but if I try and add any record (or modify an existing one) with the contents starting 'Tow' it fails with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.