Post reply

Open SQL Server Express in Access 2003

  • December 16, 2006 at 6:56 pm

    #368574

    Is it possible to open or link to SQL Server Express in Access 2003?

    Thank you,

    Norbert

    meLearnASP.net

  • December 18, 2006 at 6:51 am

    #678627

    Norbert -

    Just create a data source on your machine to the SQL Express instance, then go to File, Get External Data, Link Tables. You should be able to use this as an ODBC data source.

    Also search for adp in Help.

    GTE

  • December 18, 2006 at 6:26 pm

    #678845

    Don't forget that you need the SQL Native Client installed in order for Access to ODBC into Sql 2005. The old SQL Server provider won't work.

  • December 28, 2006 at 8:42 pm

    #680442

    - For some reason I am unable to create a System DSN.

    The SQL Server Express Database is stored on my C drive.

    I am trying to create a connection using SQL Native Client as the driver.

    I don't know what to use for the server name. "Which SQL Server do you want to connnect to?" The dropdown does not find any server.

    Thank you very much for your assistance.

    Norbert

    meLearnASP.net

  • December 28, 2006 at 11:08 pm

    #680451

    I figured it out.

    I entered localhost\SQLEXPRESS for the server name. I was than able to create the connection.

    Greg and William thanks for your help!

    Norbert

    meLearnASP.net

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply