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

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

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
 
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.
 
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.
 
Back
Top