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

Answers

Austin,

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".

Good Luck,

Eric

-- Anonymous, May 19, 2000