Deconecting / connecting a db via ODBC

A

Ana

Hi,

For security reasons, in a form I'd like the following to take place when I'm
updating a field:

Disconnect the actual user (username/ password),

Connect with a different username/password execute UPDATE....

Disconnect the second user

Connect with the original username/password.

Can it be done and if so, how?

The reason is that the second user has writes rights over the first user.

TIA

Ana

Acc07 connected to SQL05 via odbc
 
Top