Security Newsgroups: Access Security

Strange permission message

Peter L Reader - 17 Feb 2007 8:11 PM - 4 messages

I have 2 secured 2003 databases, both using the same .mdw file. Both databases also use DAO 3.6. Logging in as a member of the Admin group, I have full permissions on all the objects in both databases; I can open, read, insert, delete, ...

Access 2000 Appending records to a table

geocoy - 16 Feb 2007 7:52 PM - 4 messages

I am using an append query to add records to a linked table in another Access 2000 database. The nature of the information stored on the originating table is such that all fields can not be populated at the instance it is created. ...

User Level Security allowing External Queries

Darren Aiello - 16 Feb 2007 6:05 PM - 7 messages

I am trying to set up a database with User Level Security. I have given read access to the User's group and Full access to a generic password protected profile that is distributed to those who need it. What I am havign trouble doing is allowing anyone (the Users group) to query ...

Access 2007 open mdb (2000) file read-only

X. Zhang - 16 Feb 2007 5:01 PM - 10 messages

I have a Access 2000 mdb file security with mdw file. I use the following shortcut to open the mdb file: "C:\Program Files\Microsoft Office\Office9\MSACCESS.EXE" "C:\Program Files\TIMS Client Access\tims2K.mde" /Runtime /WRKGRP "C:\Program Files\TIMS ...

How to identify groups with database level permissions

sparker - 16 Feb 2007 5:00 PM - 7 messages

I have found hundreds of lines of code posted all over the internet for determining object level permissions (Forms, Queries, Tables, etc...) What about the database itself? Will somebody link or paste an example of a simple routine that returns all of the group names that have permission ...

Product key (25 digit)

scooter - 15 Feb 2007 9:29 PM - 2 messages

I have a genuine copy of Office XP Professional which came with a new PC several years ago.It has since started to malfunction,eveytime I try to access Word ,Excell etc the software asks for the Product Key (25 digit),I no ...

ULS and switchoboard errors

Dave - 15 Feb 2007 8:49 PM - 4 messages

Hi everyone, I have a secured database where work group security is enabled. I Have a switchboard generated by the wizzard controling the navigation. The user permissions work, however, I'm getting errors like "There was an error executing the command" when a user without necessary assigned permissions ...

Securing an Access 2000 database

geocoy - 15 Feb 2007 8:14 PM - 8 messages

I am using the FAQ sheet for securing a database. I created a new workgroup file and set up password protection. I created my own account as the Admins user. Then I created a new database and imported all the objects from my ...

Permissions to link data from a Access database to a MS Word docum

salmosalar - 15 Feb 2007 7:12 PM - 6 messages

I have info in a MS Access data base that I want to insert into a word document. I started to link the database however I get the following error: "Runtime Error '3112' Record(s) canot be read; no read permissions on ...

Access 03 vs 07 vs SQL Server

PhotoFinish - 15 Feb 2007 6:21 PM - 3 messages

My boss wants to start expand our db to have not only metadata about our docs, but also (Pointers?) (OLE?) to PDFs. We already have some 20 -30 users, the database is split, but she wants it much more secure than it is ...

Shortcuts for other users

Graeme at Raptup - 15 Feb 2007 5:26 PM - 4 messages

Hi, I have set up a very simple user level security using the Security Wizard in Acess 2003. The database resides on an S: drive. We set this up for the one user, but now I need to set up the shortcut for ...

Why removing Admin from Admins?

zmxn - 14 Feb 2007 10:25 PM - 3 messages

Everywhere I read that I should remove Admin from the group Admins. But why? I've secured my database using the wizzard and after doing that I put back Admin in Admins. Using the default system.mdw I could not open the database. ...

Why removing Admin from Admins

zmxn - 14 Feb 2007 10:21 PM - 9 messages

To secure a database I read everywhere that I should remove Admin from the group Admins. But why? I've scured a database with the wizzard and after that I put back Admin in the group Admins. Using the default system.mdw I don't have permission to access the ...

How are they opening this form?

RipperT - 14 Feb 2007 2:15 AM - 4 messages

All, I have a split, secured DB with a form called Startup configured to run in startup options under Tools > Startup. I have a user group called LineStaff. Everyone is a member of this base group. The default users ...

Join a Workgroup

Dan - 13 Feb 2007 1:07 AM - 4 messages

I have been having problems with my workgroup. Orginnally I had three databases on a server and I worked out of one workgroup called Secure1. Once I made the workgroup Secure1 I created a shortcut that went through Secure1 ...

Function Key Security

AccessQuestions via AccessMonster.com - 12 Feb 2007 2:59 PM - 2 messages

Can I make it so a specfic user can't use a function key like F11? I know you can stop it from using the start up option. But I want to allow certain users to use it and others not. ...

Security Help

Steve - 12 Feb 2007 12:34 PM - 2 messages

I was wondering if someone could point me in the direction of a good source of information on Access Security. I am trying to set up my database so that 2 people will have the ability to change data and thats it. If somebody other ...