SQL Express and MS Access 2003

[Stuart]

I am trying to create an Access Project using Access 2003. I downloaded and
installed SQL Express. I opened a new .adp, but cannot seem to get a
database started. When asked what SQL server to use, I enter “(local)â€, but
I get the error message “SQL server does not exist or access deniedâ€. Does
SQL Express work with Access 2003? If so, any clues as to how I get the
interface working?


Thanks, Stuart

 

[Norman Yuan]

Are you sure you installed the SQL Server Express as default instance, not
named instance? By default, the SQL Server Express installer package
installs it as a named instance ("SQLExpress"). So try to specify the server
name as "ComputerName\InstanceName", most likely, it is
"ComputerName\SQLEXPRESS", or ".\SQLEXPRESS".

Note, with Access 2003 ADP, you cannot create/modify SQL
Server2005/Express's server objects (table, view, SP, UDF, diagram...). You
need Access2007 for that.

 

[aaron.kempf]

yeah.. you forgot to include the REASON

the reason is that MS is a bunch of drunk assholes who don't give a
crap about us developers.

that's the REASON that Access 2003 can't play nice with SQL 2005.

for the record, Access 2000 didn't even play nice with SQL 2000 lol
those fuckers owe us all a refund

-Aaron