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

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 DEWEY
Build a little - Test a little


"ChuckW" wrote:

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,

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.


--
Chuck W


"KARL DEWEY" wrote:

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 DEWEY
Build a little - Test a little


"ChuckW" wrote:

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 dont think there is anything wrong with my query or form.
Test it!
--
KARL DEWEY
Build a little - Test a little


"ChuckW" wrote:

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.


--
Chuck W


"KARL DEWEY" wrote:

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 DEWEY
Build a little - Test a little


"ChuckW" wrote:

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