updating a SQL server table from an access form 1

[gwilym40]

I've created a table in SQL which links to an ASP - the user submits data through the asp which updates SQL.
The owner needs a front-end access 97 database whereby he'll get a form showing the data from the SQL table (I've done this bit as a pass-through query which a form reads off)
what i'd like now though is to create another table in SQL which the owner could update, so from access he'd see the user details form, but then be able to double-click an entry and update a second access form (i.e. the 2nd SQL table) - fields such as work agreed, date sent etc
I haven't a clue how to do this - any help appreciated

thanks
Kim

 

[WB786]

You will need to link the SQL tables to your MDB. Click on File-->Get External Data -->Link Tables and then point your ODBC connection to the server (if you have not setup an ODBC connection you will have to as it will prompt you to do so.) To cread another table on this MDB you can then upzise this data to your SQL in the same database or create a new one just for this table.

Check Access help for a detalied answer to how to upzise your data.

WB