I have an Access form that authenticates with SQL Server. The user would log in with a user/pass on startup. Is it then possible to change the connection login information as the Access form is running (it will be triggered) so that I can specify a new username and password?
Would this mean that a new connection will need to be made or can we still use the same connection and just specify a new user/pass combination (to perform some additional database updates or inserts)?
Thank you,
Nishant
Would this mean that a new connection will need to be made or can we still use the same connection and just specify a new user/pass combination (to perform some additional database updates or inserts)?
Thank you,
Nishant
