SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Apr 2004
    Location
    13th Floor
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Connecting to SQL through Access

    Hi all,

    I need to be able to connect to an SQL database using Access 2000. I know there is a way to do this, but I can't figure out how. I was able to create a system dns to the sql database, but how do I tie that to access?

    Thanks.

  2. #2
    Drupaler bronze trophy greg.harvey's Avatar
    Join Date
    Jul 2002
    Location
    London, UK
    Posts
    3,258
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You need to use an Access Data Project.

    File --> New --> Project (Existing Database)

    Save it where you want it and then you will see the "Data Link Properties" box. It should be pretty self-explanatory from there. You don't need a DSN or anything like that. Just pick your server, give it you login credentials and pick your database. Click ok, and off you go! One SQL Server database within the Access GUI.



Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •