Vista + Access2007 + SQLExpress ADP

[Burton Roberts]

I have just upgraded to Vista and installed Access 2007 and SQL Express to a
named instance. After figuring out how to create an Access Project (why did
they make that difficult?) I tried to link to an existing DB in SQLExpress
using the connection dialog box that pops up. I fill in the info and it
hangs up. It can't find the server. Is this configuration broken for now?
Or did I do something wrong? I am able to use SQL Express using Management
Studio.

Thanks

 

[PFC Sadr]

well if I was Eminem; I would proclaim 'they just dont give a ****'
but I dont think that is true

I think that they just don't have the mental capacity to test software
before shipping it.
I claim that MS has been out of control for a decade; and I call for
the EXECUTION of Sr Management at Microsoft and Ralph Nader to take
over.

MS just doesn't understand the market.

MDB is 'too complex for anything'
and they just don't take Access seriously.

they sit around and call us babies; meanwhile they killed off VB and
replaced it with Visual Fred--- this is only going to happen AGAIN AND
AGAIN

I urge you to leave the MS side of the equation and move to
Dreamweaver / PHP / mySql.
this is a great combination and from what I've seen-- this is the only
protection from 'Visual Fred'



-Aaron MothaFuckin Kempf

 

[David W. Fenton]

I have just upgraded to Vista and installed Access 2007 and SQL
Express to a named instance. After figuring out how to create an
Access Project (why did they make that difficult?) I tried to link
to an existing DB in SQLExpress using the connection dialog box
that pops up. I fill in the info and it hangs up. It can't find
the server. Is this configuration broken for now? Or did I do
something wrong? I am able to use SQL Express using Management
Studio.

Do you mean SQL Server Express? Or is SQL Express a non-Microsoft
product? If the latter, then it probably won't work with an ADP,
which is intimately connected with SQL Server as the data store.

It you do mean SQL Server Express, then I don't know what the
problem would be. I would never use an ADP for anything except
management of a SQL Server in any case.

 

[Burton Roberts]

I'm surprised that no one at MS has responded to this question.

I have SQL Server Express SP2 running in a named instance on a Vista
Ultimate next to Access 2007. I can link to tables in SQL Server from
Access accdb file but I can not establish a connection from an ADP file.
The connection dialog just cannot find my named instance. When I type the
instance name in it still wont make the connection through the dialog.

Is this broken in general? Would it work if I were using the default
instance? (I'd have to try to uninstall and reinstall again. The first
time I reinstalled it created the same named instance without my prompting.)

Thanks