A form to deal with the connection

  • Thread starter Vadim Pokotilov
  • Start date
V

Vadim Pokotilov

I'm working with an Access 2000 Project file which serves as a front-end for
SQL Server 2000, using OLE DB as the connection method. My problem is that
when a user opens the Access application, it immediately asks for a
username/password (this is a good thing). If the user mistypes it, however,
it does not ask again and just fails to connect to the server. I have created
a startup form to deal with the connection, but I can't figure out how to
force CurrentProject to reconnect. I've tried doing
"CurrentProject.OpenConnection [my usual base connection string]" but I get
an Automation Error. Any ideas?
 
Top