Results 1 to 4 of 4
  1. #1
    Mark@CHP is offline Novice
    Windows XP Access 2002
    Join Date
    Mar 2012
    Posts
    4

    Access security ODBC to SQL Server

    Hope you can help..
    Access 2002 on XP
    I have a secure? client linked to an ODBC SQL Server 2008 db using an mdw file. My question is, if a user has access to the client via a password, what stops the same user from creating another blank mdb and using the same mdw in a path statement to open the data base (SQL Server)?
    Thanks,


    Mark

  2. #2
    Mark@CHP is offline Novice
    Windows XP Access 2002
    Join Date
    Mar 2012
    Posts
    4

    Additional info.

    Let me try this again. Can an ODBC connection with a (File DSN, password saved) be secured?
    Client Access 2002
    BE SQL Server 2008
    OS Win XP

  3. #3
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    I typically use User ODBC DSNs. I have some code which allows me to create the dsn when the program opens. I also have code to create a System dsn but it doesn't work with Windows 7 (MS found out how to stop that.)

    I haven't worked with a File DSN in many years. I recall they were slow though.

  4. #4
    Mark@CHP is offline Novice
    Windows XP Access 2002
    Join Date
    Mar 2012
    Posts
    4
    Frankie,
    Thanks for the reply, I had given up! I would like to see your code that creates the DSN on the fly. I considered that strategy but considered it not doable. Tangential question, do you know of any product that will break Access mdw’s ? I was told that the password was easily sidestepped with a tool.

    Thanks for your help,
    M

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

Similar Threads

  1. ODBC link from Access to SQL Server changes to read-only
    By Petr Danes in forum Import/Export Data
    Replies: 1
    Last Post: 06-08-2011, 09:46 AM
  2. odbc vista SQL Server 2008 Express Slow
    By BrianM in forum Access
    Replies: 2
    Last Post: 02-07-2011, 11:47 AM
  3. Replies: 1
    Last Post: 01-29-2011, 10:52 PM
  4. Replies: 1
    Last Post: 07-17-2010, 08:29 PM
  5. Replies: 5
    Last Post: 03-29-2009, 07:20 AM

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