Results 1 to 2 of 2
  1. #1
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875

    Security Desogn compatible with both Access 2000 and 2010

    Does anyone here know of a (at least nominally secure) way to authenticate users that will work with both Access 2000 and Access 2010?

    Where I work, we've recently upgraded half the locations from Access 2000 to Access 2010. We can't upgrade the other half because they use systems that only work on Windows 2000 or older systems (and Access 2010 requires at least Windows XP to install). Unfortunately, this has created issues with one of the databases I designed that tracks data across multiple locations.

    I've already thought of one way that should work: You simply prompt the user to log in to Active Directory when they open the database. Unfortunately, this is a fairly unpopular suggestion as it would necessitate adding the various Access Security Groups to Active Directory (yeah, all 7 of them...)



    The only other way I can think of would be to include an encryption/hashing algorithm in Access 2000 (as an API/Class Module). However, I can't find any hints on how to do this.

  2. #2
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Brief update: I've found some code that MIGHT be able to do the job - somewhat. The catch is that the only "real" encryption method it seems to support is 3DES. Also, the encryption/hashing algorithms may be OS dependent (meaning what works on Access 2000/Win7 may not work on Access 2000/WinXP, etc.)

    I'll update again with the code if I can get it working!

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

Similar Threads

  1. Replies: 0
    Last Post: 07-31-2012, 12:25 PM
  2. Replies: 0
    Last Post: 06-19-2012, 12:39 PM
  3. Replies: 0
    Last Post: 02-19-2012, 08:22 AM
  4. Mixing Access 2000 with Office 2010
    By fiveoaks in forum Access
    Replies: 3
    Last Post: 10-20-2011, 09:59 AM
  5. Opening Access 2000 file in Access 2010
    By Jacob in forum Access
    Replies: 10
    Last Post: 02-12-2011, 06:56 AM

Tags for this Thread

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