Results 1 to 6 of 6
  1. #1
    Jimbob84 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    1

    How to use AttachDSNLessTable

    Hi

    I've got a Access database that works great linking to SQL database, I want to however roll this out without having to add the ODBC connection to every single person that would use it. I've done some googling and found the AttachDSNLessTable but not sure how to really use it in terms of creating the table in the first place? Do I have to write some VBA for creating the table also?



    Sorry this is probably a very simple question but I haven't touch access for over 16 years since I was at school so I'm a little rusty!!!

    Cheers

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Maybe this link will be helpful: http://www.accessmvp.com/djsteele/DSNLessLinks.html

  3. #3
    barryseymour is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Location
    Los Angeles, CA
    Posts
    7
    RuralGuy: Do you have direct experience with the code in the referenced link, specifically with Access 2016?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    @barryseymour - Sorry Barry but I do not. There are probably some helper that *do* have experience though. I'll try and round up some.

  5. #5
    barryseymour is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Location
    Los Angeles, CA
    Posts
    7
    Don't worry about it. I'm getting ready to jump in after lunch. I've tried using a DSN on a shared folder and it won't meet my needs. Going to try the 'recreate DSNLess connections' and 'relink all tables to that' after lunch. I'll post my results here.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'm watching your other thread too that PBaldy is helping on. Good luck with the project. Paul is "A number one" as far as I'm concerned.

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums