Opinions? -- Automatic Database Login

[dsfcom]

I was asked if it were possible to log into a workgroup secured db without having to enter the username and password and came up with the attached "accessory" db instead of distributing shortcuts with their username and passwords included in the shortcut as others could view the properties of the shortcut to obtain their passwords etc. It's not totally secure by far and could use some more work but thought others may be able to use something like this and modify for their purposes. The code is commented so it's easier to understand what's going on. Simply put, the administrator would enter the path parts (three options: part 1 and part 2, part 1 only, or part 1, Windows logon name, and part 2) for all three strings (workgroup file, database file, and Access executable). I'm planning to continue using this method but would like to know if I'm way off or have come up with something useful. With this method the user only enters their workgroup login information one time. Assuming that their workgroup user name is the same as their Windows login name it works great (I have all my workgroup user names the same as their Windows login names to make things easier on me). All users log in using a shortcut to the same "accessory" db. I'm sure there's more to explain that I'm missing but look forward to other's comments.

 

[odin1701]

I don't bother with workgroup secured DB's.

I just use a table with usernames and access levels. When someone opens the database, it compares their windows username against the usernames in that table. If not there, it won't let you open the database. If it is there, it continues to check access levels and enables/disabled menus according to what functions they are assigned.

This works as we are on a domain. With a workgroup, anyone can type in any username they want unless further windows security is setup, so it wouldn't necessarily work.