Recent content by davehill52

When I create the shortcut on another users machine, the shortcut takes you to Access but you then get the error message that they don't have permission to the object (the access database). At that point if they use the Tools drop down menu for Security and open Workgroup Administrator and do...

I have a database that I've applied security to, where Access created a Worgroup Administrator "Security.mdw" file. This file resides in a subdirectory of the directory where the access database resides on a network drive. I want to be able to have the database usable by numerous people within...

Thanks PH. I'll try your suggestions. Dave

How does the other PC User use the .mdw file when opening the .mdb file? I have asked him to open the .mdb file thinking it would know it is secure and look at the .mdw file for the permissions. Am I doing something wrong? Dave

The Security Wizard creates the .mdw file It is located in a sub-folder: \\Erato\dataarch\GAIT\D11b-Data Integration\LI Data Analyst\DA Data Information Repository\Data Files\Security.mdw I can access the user profile and update them.

I have a database: \\Erato\dataarch\GAIT\D11b-Data Integration\LI Data Analyst\DA Data Information Repository\D11b DA Data Repository Application.mdb That I have set up security using the Security Wizard. I have added a User (not myself) and given him the same rights I have (Admin). I am...

Is there a way to set conditions on a field based on who the user accessing the form? I have a field that if the Admin user is accessing the form that I would like the field to show. If it is a normal user, the field would not appear. Dave

Just an update. If I Compact and Repair Database, the switchboard forms work fine. But if I exit and return to database I get the error again. Dave

I have a database that was created in Windows XP. I used the Switchboard Wizard to generate forms for selecting forms and reports to open. It works fine the first time created but when I come back the next day and try to use the switchboard forms it get a message, "The expression On Click you...

I am trying to generate two fields in a query that are equal to the current date -3 and the current date +3. These fields will then be used to compare a date field on a report for conditional formatting. If record.date Beteween First_Date and Last_Date.....