Access & SQL Insert problems

I have an Access database which only consists of reports & forms.
All other objects resides in SQL. One form is based on a view which is based on 2 tables, but insert fails due to one table that has an autonumber field and cannot update thru the view. How can I work around this, besides hard caoding everything???
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!