Go to Top

Wednesday January 9th: Back by popular demand, Optimizing Access with SQL Server!

Join me this Wednesday, January 4th at 6:00 PM EASTERN, 5:00 PM CENTRAL, at the monthly CTAUG,  (Connecticut Access User Group),  meeting.

Access Experts Ready to Help

MS Access Consulting

We will be discussing how to optimize Access with SQL Server:

  • What is the ONE field all of your tables in SQL Server should have? (Hint: It’s not just the a primary key)
  • How do you get a SQL Server view to be editable in Access?
  • How can you make your tables DSNless?
  • How can you retrieve the last primary key inserted into a table? How can it be done in a multi-user setting?
  • What is the ONE thing you should always avoid when querying data in SQL Server?
  • And many more tips and pointers

I look forward to having you there, if you do decide to attend let me know here.

1.   Use this link to attend: https://www2.gotomeeting.com/join/878628578

2.  Use your microphone and speakers (VoIP) – a headset is recommended.  Or, call in using your telephone.

Dial +1 (213) 493-0603
Access Code: 878-628-578
Audio PIN: Shown after joining the meeting

Meeting ID: 878-628-578


About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

5 Responses to "Wednesday January 9th: Back by popular demand, Optimizing Access with SQL Server!"

  • Giorgio Rovelli
    January 15, 2013 - 9:22 pm Reply

    When is the video to the presentation going to be posted?

  • Giorgio
    January 10, 2013 - 5:24 am Reply

    Ok, I finally got connected

    • Ben Clothier
      January 10, 2013 - 6:52 pm Reply

      Glad you could make it!

  • Giorgio
    January 10, 2013 - 5:08 am Reply

    Once again, all my best-laid plans went awry
    At midnight(Italian time) I used the link to attend and the correct message appeared as you see here: http://sdrv.ms/VLvHeT
    but beyond that, nothing else.

    • Ben Clothier
      January 10, 2013 - 5:14 am Reply


      I’m told that the meeting started a bit; try again in 10 more minutes (5:30 PM CST)

Leave a Reply

Your email address will not be published. Required fields are marked *


Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.