Daniel- When you go to another machine, can you open your "secured" database? If so, then it isn't really secured.
If you want users to be prompted for a password, they they must be using your workgroup file. You can specify the workgroup file in an application shortcut so that you don't have to change the user's default workgroup for local databases. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of dtnfwalk Sent: Wednesday, August 29, 2007 5:23 PM To: [email protected] Subject: [ms_access] Security for a shared .mdb not working I have a .mdb in a shared folder. I have created logons and passwords for people who need access. The workgroup file was set up on my computer and stored in the same shared folder as the .mdb. Problem: when I log off of my machine and go to another, Access does not prompt me for my logon or password. I have had other users logon and they are not prompted for their information either. Only my office machine requires users to log on. Can anyone speculate as to what I might be doing wrong? Daniel Yahoo! Groups Links
