Hi - using VS2005, I'm building a table adapter using the wizard.
I can't figure out why I can't see the Advanced Options box, to allow me to add update/delete/insert queries - I have a fairly standard table, and what I'm putting into the query designer is very straightforward:
SELECT BusinessUnit, Comments, Dateadded, Discipline, Emp_Type, Holiday_allowance, ServiceLine, Status, pos_position, updatehols, user_access, user_dateleft, user_datestarted, user_email, user_id, user_name, user_nt, user_office, user_staffnum, user_team, user_team2 FROM tblaccess WHERE (user_id = @user_id)
The primary/identity key is the user_name field.
Can anyone offer any help?
Thanks, Mark