Inserting Records into SQL tables

Tech-Archive recommends: Fix windows errors by optimizing your registry

I had an Access 2003 database that was split into FE / BE. My recent
"brilliant" add was to push the tables out to SQL so that we can begin to
build some web applications. That all went well...but until we have web apps
built, we need to use the Access forms to insert data. I have linked the
tables and views from sequel to the Access Front End via ODBC. This also
seemed to go well.

While I can add new records via the linked tables; I am unable to INSERT new
records via the Views (which I really would prefer to do) Any ideas of where
to look to resolve this are appreciated. Thanks GM
.

Quantcast