X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Setting Up Odbc Drivers With Workgroup Security, Access 2003    
post Dec 4 2018, 06:40 PM

Posts: 1
Joined: 4-December 18


I am trying to setup an ODBC connection to an old MS Access database (2003). It has workgroup security setup.

I am setting up a System DSN and using the 32-bit MS Access driver. I then add my credentials in the Advanced options. Do I need to pass any other information?

I really appreciate any help I can get on this.

Thanks. Sue
Go to the top of the page
Doug Steele
post Dec 4 2018, 07:51 PM

UtterAccess VIP
Posts: 22,207
Joined: 8-January 07
From: St. Catharines, ON (Canada)


The .mdw that contains the user and group information must be present in a location where each user can access it.

Doug Steele, Microsoft Access MVP (2000-2018)
Personal webpage
Microsoft profile
Co-author: Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs, published by Wiley
Co-author: Effective SQL: 61 Specific Ways to Write Better SQL, published by Addison-Wesley Professional
Technical Editor: Access 2010 Bible, Access 2013 Bible, Access 2016 Bible, all published by Wiley
Technical Editor: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition, published by Addison-Wesley Professional
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    22nd October 2019 - 03:47 AM