Access 2007 Connection Fails at Startup

[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

 

[Alan Z. Scharf]

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

 

[Sylvain Lafontaine]

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.

 

[Alan Z. Scharf]

Sylvain,

Yes, that states the problem well.

Then the question is why wouldn't it work the same in Access 2007.

Particularly since it is code from MSKB on changing cnnection
programmatically.

http://support.microsoft.com/kb/306881

Alan

 

[bcap]

It might help if you posted (i) your connection string and (ii) the exact
error number/message that you get.

 

[a a r o n . k e m p f]

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