Newbie question on interaction between GUI and server

[itsgoodtobeking]

I have an SQL server with tables I have created. I am trying to use MS Access for the front end GUI of my SQL server. I have made a form to view certain fields of a table, but I can only view this. There is no interaction between. How do I get the interaction between the front end and the SQL server??

 

[SQLSister]

First, When you use SQL Server tables with an Access front end, you cannot do anything except select unless your table has a unique identifier in it. SO you must have a primary key or a unique index or an autonumber field or a GUID field.

Other tahn that the user must have specific permissions to update, insert, delete.

Once you are past those two hurdles you just write a stored procedure to to the update, insert or delete and execute it form your form.

Questions about posting. See faq183-874

 

[itsgoodtobeking]

Thank you I will try your suggestions.