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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChuckW - 27 Nov 2007 18:30 GMT

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

Reply to this Message

KARL DEWEY - 27 Nov 2007 19:21 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> Hi,
>
[quoted text clipped - 10 lines]
>
> Chuck W

Reply to this Message

ChuckW - 27 Nov 2007 19:32 GMT

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.

Signature

Chuck W

> >>I have an MS Access input form that is based on a query that is based on a
> table called Training.
[quoted text clipped - 15 lines]
> >
> > Chuck W

Reply to this Message

KARL DEWEY - 27 Nov 2007 20:22 GMT

>>I dont think there is anything wrong with my query or form.

Test it!

Signature

KARL DEWEY
Build a little - Test a little

> Karl,
>
[quoted text clipped - 21 lines]
> > >
> > > Chuck W

Reply to this Message