Access 2007 Connection Fails at Startup

  • Thread starter Thread starter Alan Z. Scharf
  • Start date Start date
A

Alan Z. Scharf

Hi,

When I open an Access 2007 Enterprise ADP, the connection fails.

However, if I then go to Office Button, Servers, Connection and press OK,
the ADP connects.

This happens both in the office, and also on my home system running in
Virtual PC.

My SQL Server Management Studio opens on normally on first try, so there is
nothing really wrong in general witth connecting to SQLServer.

Is there some setting I'm missing?

Thanks.


Alan
 
FOLLOWUP:

My application on startup is using

'Application.CurrentProject.OpenConnection strConnect'to connect at startup.

This app has been starting up with my connection code for several years in
Access 2003 with no problem.

Alan
 
Obviously, you have some piece of code who is setting the value of
strConnect to a (valid?) connection string on startup and this piece of code
doesn't work properly under ADP 2007.
 
It might help if you posted (i) your connection string and (ii) the exact
error number/message that you get.
 
I'd look at the NorthWindCS.adp and make sure that you're doing it the
exact same way that they do.

I've never had to do anything like this; because I just set the
connection string and then keep people away from the option to change
it.

-aaron
 
Back
Top