UtterAccess.com
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    
 
   
suem
post Dec 4 2018, 06:40 PM
Post#1



Posts: 1
Joined: 4-December 18



Hi

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
Post#2


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


welcome2UA.gif

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    18th August 2019 - 04:14 PM