Inserting Records into SQL tables

[Guest]

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

 

[Guest]

In SQL: did you grant write rights to the View, or is the View read-only?

 

[Guest]

.... that's an interesting question... I didn't do either... I used
Enterprise Manager to create the view. I did try to add a record through the
View in SQL and was able to add a record so I would think that the View has
write rights. Does this sound to be a logical assumption?

I'm very new to SQL so I appreciate any thoughts / ideas.

thanks, GM

 

[Sylvain Lafontaine]

http://support.microsoft.com/kb/q209123/

 

[Guest]

Thanks Sylvain that helped to explain the phenomona...

As an additional note:

As this reference states: "NOTE: You are prompted to specify a unique
record identifier when linking to a view. This can be a single field or a
combination of fields and will allow you to update the view without creating
an index."

I had been identifying the unique fields whenever I linked the tables to the
Access FE; however, what I didn't know was that when you use the Linked table
manager and refresh your links (Not an uncommon operation), this information
as to Unique fields is apparently wiped out and the Linked Table Manager DOES
NOT help you out by asking for them again.

thanks again! George