Hi All-
I have a small task to achieve. I want to create a form in Access which (Access) would have possibly an ODBC connection to my SQL server database that has a view as my source for data for the form. What i want to be able to do is have the data from the SQL view to display in a form in Access and then if a user needs to update any of the information he does so. But all the updates occur through as stored procedure that i already wrote in sql server. And it has to be only one Form meaning the form that displays the info should open in edit mode. I know how to call a stored a procedure from VBA and how to pass all the parameters from VBA. I just need some good suggestion how to go about doing this. And how to fetch the recordset into the form. My view has 4 fields (Account,compname,compcity,compstate). Thanks in advance.
I have a small task to achieve. I want to create a form in Access which (Access) would have possibly an ODBC connection to my SQL server database that has a view as my source for data for the form. What i want to be able to do is have the data from the SQL view to display in a form in Access and then if a user needs to update any of the information he does so. But all the updates occur through as stored procedure that i already wrote in sql server. And it has to be only one Form meaning the form that displays the info should open in edit mode. I know how to call a stored a procedure from VBA and how to pass all the parameters from VBA. I just need some good suggestion how to go about doing this. And how to fetch the recordset into the form. My view has 4 fields (Account,compname,compcity,compstate). Thanks in advance.
