Security Newsgroups: Access Security

startup properties

S - 9 Sep 2006 2:43 PM - 5 messages

I want to prevent others from changing the startup properties using VBA in another access file. I don't use User level security because I am not in a position to prevent either the database file being copied onto another ...

Fox Sports not Authorized Message

Reesey275 - 9 Sep 2006 12:16 AM - 2 messages

When i try to lonon to my fox sports fantasy team i get a not authorized message. How do i fix this?? Not Authorized You are not authorized to view the page you requested. It is likely you are not authorized to view this page because you are not ...

Security

Matt Dawson - 8 Sep 2006 4:18 PM - 6 messages

Having created a secured database and now have all the relevant passwords etc, it created a shortcut which i now run from. However, I need to distribute this file on to a shared drive and i cannot find the main file and can only run off the shortcut. ...

User permissions validation text

Matt Dawson - 8 Sep 2006 3:45 PM - 2 messages

Within my database i have set up user groups with passwords and then have related user permissions. When a user tries to access something they aren't allowed to the error message comes up as "There was an error executing the command". ...

Locked Out, what did I do?

bcemail - 8 Sep 2006 1:40 PM - 3 messages

My first try at Access security, I used the wizard, and setup the passwords, etc. Now, when I try to open the DB, I get a message saying I don't have permission, and to contact the Admin (me). Where did I go wrong? It never ...

Security NOT using "mdw" file

Kan D. - 8 Sep 2006 1:14 PM - 11 messages

Greetings. Does anyone know of a way to do this (please read all steps): 1. I want to setup a Design Master and 4 replicas. (I know how) 2. I want to lock out the users from design mode of all objects within the ...

Forgotten password for Access

Al - 8 Sep 2006 2:51 AM - 2 messages

My daughter password protected a file on Access and forgot the password. Now, all of Access is password protected and I can not open any databases. Is there a way to get rid of this password. I have tried to uninstall and ...

Admins Group Unique?

Scott McDaniel - 8 Sep 2006 12:30 AM - 2 messages

Is the Admins group unique for each installation of Access? Not the Admin user, but the Admins Group itself? IOW: If I install Access on machineA and also on MachineB, would the groups be created with the same PID on each? ...

Open Exclusive

Curtis_Hatcher - 7 Sep 2006 9:08 PM - 3 messages

The open default on my database is set on exclusive. However, when I try to reset the password, I get the message that the database must be set on open exclusive in order to alter the password? Please help. ...

Shorcut with pointing to two ACCESS.EXE

erick-flores - 7 Sep 2006 7:47 PM - 3 messages

Hello all I am having a lil problem here. Is there a way to create just ONE shorcut that points to two (2) different folders where the ACCESS.EXE is located? e.g. "C:\Program Files\Microsoft Office2003\OFFICE11\MSACCESS.EXE" ...

Windows Messenger

GrahamB - 7 Sep 2006 12:53 PM - 2 messages

Can anyone explain how an instant message was sent from my account whilst I was logged on without my knowledge ...

MDW deployment?

John - 7 Sep 2006 7:40 AM - 5 messages

Hi again! I have created a front-end and a secured backend. I have also created a synchronized (auto-update) platform where every user will get the latest front-end version on their local machines. However, I'm unsure whether I should also distribute the MDW (security) file. ...

Prevent all Access files from connecting to the same Workgroup?

George W Schalles IV - 6 Sep 2006 9:08 PM - 3 messages

I am trying to post an Access database to a common drive and have only it join to a Microsoft Office Access Workgroup Information file. Unfortunately all of my other Access databases are also joining with this same workgroup information file. How do I prevent this issue? ...

Access 2002

Brian - 6 Sep 2006 3:21 PM - 2 messages

I have a user that cannot open an access .MDB if someone else is already in it. If the user opens it first everyone else can open it. So I need to have everyone get out then I have her open it and then everyone ...

Securing the Back-End

Sprinks - 6 Sep 2006 2:29 PM - 3 messages

I recently secured the front-end of a split database, creating a new workgroup file. I would like to allow no rights at all for the back-end, other than for members of the Admins group. Today I opened the backend file and attempted to reset permissions. Access ...

How can I lock based on certain field?

ArthurMailloux - 5 Sep 2006 8:38 PM - 2 messages

I have created a database that has a form with subforms to enter data, all based on an Incident_Number field. Incident_Number being the link for all data tables. In the main table to store all this data, I have a field for Status, either ...

Users

Matt Dawson - 5 Sep 2006 3:25 PM - 4 messages

I have created a database and applied the necessary passwords and permissions for the relevant users. However, I have one problem in that my lowest scale users can still see the main database window and can create therefore play around with new forms. Is ...

from mdb how to openForm a form in a referenced mde file

Jay - 5 Sep 2006 2:53 PM - 4 messages

From an mdb file I can call procedures and functions from a referenced mde file, but I cannot figure out how to open forms or reports that are in the mde file. my mdb file Code: docmd.openForm "Form1" ...

how do i use passport to my benefit?

Debra D. Newport - 4 Sep 2006 8:24 PM - 2 messages

i am trying to download spreadsheet from the internet. it will go into word and excel but i cant make changed to the document even with the passport. what am i doing wrong? ...

Security restrictions and table linking

John - 4 Sep 2006 3:46 AM - 7 messages

Hi all! I have a backend that is secured and a frontend (mde) that has some vba code that re-links the tables to the backend. My question: Is there any way I can stop a read-only users to open the backend directly? I tried ...

Using Access 2003 security on users with 2002 Access

CAM - 3 Sep 2006 5:32 PM - 3 messages

Hello, I just got Access 2003 for my PC, previously I was using Access 2002. All of my databases and security settings was created using Access 2002. All of my databases are using Access 2000 format the default setting. Many of my ...