data not saved

A

Adrian Porter

I have created a front end in Access 2003 with data on SQL server. When I
try to create a new record, it won't assign an autonumber (the primary key
field) and fails to save the data. I am entering data through a form based
on a straightforward query. What am I doing wrong?
 
D

Douglas J. Steele

Yes, that's probably the problem. Leave the Autonumber field out, and it
should get assigned a value.
 
A

Adrian Porter

OK - I'll give that a try. Many thanks for your help - I've never used a
group like this before and am impressed with the speed of the reply to my
problem!
 
A

Adrian Porter

No - I'm afraid removing the primary key field from the query didnt work.

I have tried writing data directly into the table and it will not save.
This has not happened before and I am not aware of changing anything.

I get an error message:

ODBC call failed ...... String or binary data would be truncated (#8152)
..... The statement has been terminated (#3621).

I have no problem entering data in other tables - either directly or via
forms based on queries.
 
D

Douglas J Steele

Sounds as though the problem might be with that specific table. It might be
worth asking in a SQL Server group.
 
Top