Re: How do I use Access 2003 with SQL Server Express?


Access 2003 is probably not the right tool to choose for developing SQL
Server Express databases. If you really want to use Access to design the
database, you could try using Access 2007. I have done some very basic tests
and have verified that I am able to create tables in a SQL Server Express
database using Access 2007 Beta 2 TR, but I have not done any more extensive
testing than that.

Alternatively you could use Access 2003 and MSDE instead of SQL Server
Express during development and transfer the database to SQL Server Express
when deploying it to the production server.

Alternatives to Access include the Visual Studio 2005 built-in database
designers, and SQL Server Management Studio Express, available as a free
download from Microsoft's web site.

--
Brendan Reynolds
Access MVP

"NGM MS Office" <NGM MS Office@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:76C14533-1146-4A92-A008-967DDDC6DFC4@xxxxxxxxxxxxxxxx
I have SQL Server Express installed and am trying to create an Access 2003
project. When Access asks for an SQL server I specify (local) however I
get
the following error message:


Microsoft SQL Server Login

Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared
Memory]ConnectionOpen(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not
exist
or access denied.

My ultimate goal is to create a website with Visual Web Developer 2005
with
a parametric filter (search engine) to pull records from an SQL database
that
was created via Access 2003.


.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
Loading