Secured DB: Startup form being bypassed

[Meltdown]

Hi all,

I have a secured DB set up with user and groups, I'm having a problem where one particular group are not being sent to the startup form but are being sent to the back end instead, albeit with no access to any tables or forms. I've checked the permissions and they seem to have all the basix permissions to access the forms, tables, queries.

Anyone know what's going on?

Thanks
Melt

 

[vbaInet]

Have you checked the group persmissions and also each individual user in that group?

Depending on your setup, you could individually give all the users in that group the least rights, then give the right permissions on the group.

 

[ghudson]

How are the users opening the database? If you are using workgroup security, you should give each user a custom shortcut that defines the location of the database and the location of the mdw file they need to open the secured db.

Below is a sample Target value used in the properties of a custom shortcut...

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /wrkgrp "X:\Testing\YourWorkgroupFile.mdw" "X:\Testing\YourDatabaseFrontEnd.mdb" /user TestUser

If the users can access the front end or back end just by clicking on the file from windows explorer then the database is not properly secured.