Hey,
so we distribute .ade files as .accdr files (Renamed so access run time doesn't have a hissy fit).
The .accdr has instructions that load and clear the SQL connection information automatically at close and start up after reading it from the registry.
The problem i am running into is that if the application terminates unexpectedly (end process from task manager, power cut etc etc).
Then the connection information is not cleared and when the DB is run next it prompts for the password used in the connection information previously.
(The code that runs on the unload of a background form)
Due to the fact that we have set up our own login form and system which we maintain, this can prevent the client from logging in or if they are smart enough to have the information it at the least becomes an annoyance as they have to login multiple times.CurrentProject.Connection.CommandTimeout = 10 CurrentProject.Connection.Close CurrentProject.OpenConnection ""
We do start up the db through a launcher (That checks for updates) - Is there any way to have the launcher check for the connection info in the DB and clear it before running if its there? essentially performing the same task that the system performs on shutdown?
The launcher is coded in C#
So what im really looking for is some way to run the above code from C# when the database has already been closed, so it doesn't prompt when started the next time.
Or even from a vbscript i could have the C# system run.
As always thanks in advance!