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

"Alan Z. Scharf" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Alan Z. Scharf" <(E-Mail Removed)> wrote in message
news:eU%(E-Mail Removed)...
> 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
>
> "Alan Z. Scharf" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>
>

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


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:(E-Mail Removed)...
> 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.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
>
> "Alan Z. Scharf" <(E-Mail Removed)> wrote in message
> news:eU%(E-Mail Removed)...
>> 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
>>
>> "Alan Z. Scharf" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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
>>>
>>
>>
>
>

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

"Alan Z. Scharf" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:(E-Mail Removed)...
>> 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.
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: sylvain aei ca (fill the blanks, no spam please)
>>
>>
>> "Alan Z. Scharf" <(E-Mail Removed)> wrote in message
>> news:eU%(E-Mail Removed)...
>>> 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
>>>
>>> "Alan Z. Scharf" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> 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
>>>>
>>>
>>>
>>
>>
>
>

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





On Jul 12, 3:04*pm, "Alan Z. Scharf" <asch...@grapevines.com> wrote:
> 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