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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top