Base table updates from the front-endgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
We have a SQL Server tables that needs to be mainted by the X department. Therefore, I was going to have them makes changes to the tables using something like MS Access front end. Any idea on how to write the VBA script or sql script that will allow the updates of the SQL Server tables from the front-end.
Thanks for your continous helps
-- Anonymous, May 11, 2000
A good start for instruction on how to connect Access to SQL Server is the Access 2000 help article, "Import or link SQL database tables or data from other ODBC data sources".
-- Anonymous, May 19, 2000