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.