Cannot add new records (rows) to one of 12 tables

J

Joe T

Everytime I upsize to MS Accesss ADP from MDB to SQL Server 2000, I have one table that I cannot add new records to. The Primary key field for the table is just like the rest.

In the table I'm using "Autonumber" to add new records, however the "Autonumber" box does not plug in a new number if I try to create a new record. If I try to save that record, I get the error message, "String or binary data will be truncated" and I lose the data.

Any idea of what's going on?
Joe
 
R

Rodolfo Rughi

may be, the table doesnt have a primary key

Joe T said:
Everytime I upsize to MS Accesss ADP from MDB to SQL Server 2000, I have
Click to expand...
one table that I cannot add new records to. The Primary key field for the
table is just like the rest.
In the table I'm using "Autonumber" to add new records, however the
Click to expand...
"Autonumber" box does not plug in a new number if I try to create a new
record. If I try to save that record, I get the error message, "String or
binary data will be truncated" and I lose the data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Dual primary keys a problem in SQL? 13
Autonumber records inserted in gaps 0
Access 2003 / SQL Express 8 Can't Add Rows to Table 3
One-to-one relationship 2
primary key - concatenated or autonumber? 6
Copy Records within a Table with SQL 7
add records to a table in ADP 3

Top