Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2010
    Posts
    36

    Post Unanswered: Programatically link SQL Server tables in a new Access

    Hi Guys

    I need a smart procedure to be able to programatically link SQL Server Tables to a Microsoft Access database.

    Someone please help me with this.

    Thank you

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    pretty certain there is some boiler plate code in Letwin, Getz & Gunderloy's "Access Developer"
    ..there's certainly code their to programtically linjk to JET tables in another MDB/MDE/ACCDB/ACCDE

    but why would you be suing Access and LINKing to a SQL server instance. I would expect you to use pass through queries to leverage the advantages of using a client server DB and the Access RAD front end tools
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2010
    Posts
    36
    I would like to distribute access to several users who are outside in different locations. The user will use access to enter data locally and then connect to internet. After connecting to internet then a button will be pressed that will sync data to SQL server online. I have not used pass through query but i think pass through query maintainance is very difficult as i have to work with every single computer to maintain it. But if it is run automatically, then the maintainance would be much easier.

    Thank for the help

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    query maintenance will be trivial, the query is the query is the query
    but you will need to create a system DSN on each client machine

    but you can reduce the imapct of that by having an installer program to setup the DSN in the registry
    http://superuser.com/questions/25195...the-system-dsn

    https://www.google.co.uk/webhp?sourc...g+a+system+DSN
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Dec 2010
    Posts
    36
    Thanks

    This can be an alternative solution. I will explore and come back to you.

Tags for this Thread

Posting Permissions

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