Connecting to an External db
Posted on 2006-06-11
Assumming my db was locked out and no user is able to log in. However, I do have a backdoor routine in the back that can reset all the users.
However, since the db is an .mde, manual resetting may be impossible. In this case, I will like to login to the Server from a remote location...let's say from a local work Station in order to access the specific routine in that db that will reset all users.
I do have the sSql figured out as it's being utilized in my db when logged in thru backdoor and utilizing the specific routine ...I just need an idea on how to connect to the external db and .....
....run 3 sSql that will utilize the routine in the db being connected and reset user's passsword fields. Any help will be appreciated.