#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Posts
    2
    Rep Power
    0

    Connecting to a SQL Server in MS Access


    How do I go about connecting to a SQL server in MS Access? I want to use a different database, but still use the forms in Access. I read somewhere that you can connect to a sql server through Access 2002, but what about 2000? Do I need to download anything?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Posts
    38
    Rep Power
    12

    Connect


    Connecting to SQL Server via ACCESS is a 3 step process.
    To do this you need a SQL Server driver, the DB user Id and password and probably the service name.

    1. Create a DSN that has the SQLserver user ID and password.

    To do that go to the Control Panel/Administrative Tools/Data Source (ODBC). Click the System DSN and and follow the prompts.

    2. Open a new access database. File/Get External Data/Link Tables. Leave everything blank and select ODBC from the bottom list box. You server should be listed there. If not, Step 1 failed

    3. Follow the prompts for logging in and then just pick the tables needed.

    It's ugly but it works.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Posts
    38
    Rep Power
    12
    Here are some screen shots. Nobody could figure this out without help...hang in there

IMN logo majestic logo threadwatch logo seochat tools logo