Not able to add or edit records from an input form.

[ChuckW]

Hi,

I have an MS Access input form that is based on a query that is based on a
table called Training. The Training table is actually an SQL Server table
that is linked. There are three fields in the table: ID (The primary key),
CustomerName and TrainingDate. I added three records into the table using
SQL Server Enterprise Manager and can add more. However, I can't add them
using my access form. I can view them but cannot add. I can't edit them
either. What setting do I make to allow edit and adding to occur? I posted
this question in the sql server forum and was told to post it here.

Thanks,

Chuck W

 

[KARL DEWEY]

I have an MS Access input form that is based on a query that is based on a
table called Training.
You did not mention whether you could add/edit from the query. Check that
to see if the problem is with the query or form.

 

[ChuckW]

Karl,

I dont think there is anything wrong with my query or form. I recreated the
table in access and can add records. Whenever I move the table to SQL
Server it wont allow me to add or edit but I can still view.

 

[KARL DEWEY]

I dont think there is anything wrong with my query or form.
Test it!