Hi All,
Access 2000
I have a form with an "Update" button control.
The "Update" executes a query that updates my table from an SQL Server.
When it is executed, I need to login to the SQL Server with user name and password before the update could take place.
I would like th button to...
1) Login to SQL Server (I need help here)
2) Run update query
3) Logoff SQL Server (I need help here)
TiA
Access 2000
I have a form with an "Update" button control.
The "Update" executes a query that updates my table from an SQL Server.
When it is executed, I need to login to the SQL Server with user name and password before the update could take place.
I would like th button to...
1) Login to SQL Server (I need help here)
2) Run update query
3) Logoff SQL Server (I need help here)
TiA