Access Security File Problem

[hype261]

So I have a weird issue that I hope somebody has seen before.

I have an Access database that has a security workgroup file. I created a shortcut that has the following target...

"C:\Program Files\Microsoft Office\OFFICE11 \MSACCESS.EXE" "\\*.mdb" /WRKGRP "\\*.mdw"

The * represent the associated path and filenames. Up until today this has worked correctly and required the user to login. Today when I tried to login today it told me I didn't have permissions to use the database and when I clicked User and Group Accounts it said I was logged in under the Admin account(which has no permissions).

To work around this I changed the path to:

"C:\Program Files\Microsoft Office\OFFICE11 \MSACCESS.EXE" "\\*.mdb" /WRKGRP "\\*.mdw" /user

Which forced the user to login.

Has anybody every seen this problem before?

James

[MMcCarthy]

I'll admit most of us don't use the Access Security permissions and build our own because of the mdw file and the ways in which it can cause problems.

The last time I encountered problems with Access Security it was when I was working on a database someone else had designed. If I remember correctly something in the computer's configuration had changed, maybe the computer name and the mdw file had problems recognising the standard login. Not sure if that is what's happening here.

The best link I can give you for Access Security generally is this one. It's a series of articles written by J. M. Wild and one that most clearly explains all the issues of Access Security. It was however, written prior to 2007.

Mary