data not saved

[Guest]

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?

 

[Douglas J. Steele]

The Autonumber field isn't included in the query by any chance is it?

 

[Guest]

Many thanks for responding. Yes it is - is this the problem?

 

[Douglas J. Steele]

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

 

[Guest]

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!

 

[Guest]

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.

 

[Douglas J Steele]

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