Security Newsgroups: Access Security

Switchboard is read only

NES - 3 Feb 2007 3:39 AM - 9 messages

I set up a database with a switchboard. When I opened the DB again and tried to change an item (actually delete an item) on the switchboard, I'm told that it's read only. I don't recall setting any locks on it, and I can't find out ...

change object ownership

cmledbetter - 3 Feb 2007 12:59 AM - 3 messages

I know that in my original research prior to starting this project I found a means to change the ownership of objects after implementing user level security. In an existing Access 2003 db it hs become necessary to implement security and place the db on a network drive. In order to make a clean ...

user lost access security

dchman - 2 Feb 2007 10:26 PM - 3 messages

I inherited a Access database which has user-level security, for which I have little information. Also, I am by no means an expert on Access security. The database exists on a network share. In the same share is a workgroup ...

Workgroup and Security Help

AIR1 - 2 Feb 2007 3:12 PM - 4 messages

I am trying to secure a database that is on a network at work. By running the wizard, I secured the database on my computer, but my co-workers down the hall cannot enter the database. They get the message: you do not have ...

How to eliminate unknown program insistant on accessing my address

ROB - 2 Feb 2007 12:37 PM - 3 messages

I'm on Windows XP and for about a month now when I'm in Outlook I keep getting notification from an unknown programme wanting to access my address book. The buttons offered are YES or NO and HELP. ...

Access 2000

PEZZ - 1 Feb 2007 11:54 PM - 4 messages

Is it possible to prevent my employees from seeing form designs? I want them to be able to operate a form but not to have access to the design, properties, etc. Also, besides the "hidden" property setting, is there any way to hide the ...

can't make MDE

Jesse Aufiero - 1 Feb 2007 4:28 PM - 2 messages

When I attempt to turn my access 2003 mdb into an mde i am informed by access that it cannot perform the operation. What are my other options to prevent users from accessing the underlying vba code or the db window? ...

Re-linking tables

Keith Wilby - 1 Feb 2007 10:27 AM - 12 messages

I'm having a few thoughts about re-linking tables at startup in one of my apps but I was wondering how ULS would affect the process. If my app is set up to run around RWOP queries and users don't have any permissions to any ...

Access Front End - Oracle Backend - Multi User Logon Help!

ckaliveas - 1 Feb 2007 5:10 AM - 2 messages

Have an MS Access Front End with Oracle10G backend. Currently have one Oracle user account (mine) to login through ODBC. Currently each linked table in MS Access has the 'save password' box checked. Currently created MS Access Security Users/Groups to the forms. These users ...

Customized access to the database

Ramtin - 1 Feb 2007 2:47 AM - 2 messages

I need to set up a security which limits access of a group of users only to the forms for reviewing , editing and entering the data; I don't want them to have the access to tables, queries and macros; what is the best way to do it? ...

Keeping a MAC address off the network

John Trask - 1 Feb 2007 1:36 AM - 3 messages

I've got a rogue computer on my network that causing problems. How can I keep it off my network? Or, if I can't keep it off my network, can I make it unusable? I'm in Dallas, the computer in question is in London. No one there seems to ...

Current User

Joy - 31 Jan 2007 10:23 PM - 2 messages

If multiple users use the same form to edit hours entered in a time and billing database, is it possible to prevent a user from viewing other users/employees hours worked. What I'm trying to do is identify if the ...

back-end security

Marco - 31 Jan 2007 6:26 PM - 4 messages

Hi. I createed a security for my front-end. I create the MDW file and for the front end I think there's no problem. but what about my back end? I tried to joined the front-end workgroup but it's not working, if I click two times ...

Expiration Date

rbb101 - 31 Jan 2007 6:09 PM - 6 messages

I am sending an access file to someone to review for 30days. After that 30days I want the database to be non-functional. Is there a way to remove the functionality after 30days, auto-delete, or lock it after a specific ...

Securing a Single Table A97

Kahuna - 31 Jan 2007 5:20 PM - 4 messages

I have a secure back/front-end app in A97. Works fine and some of the config data is held in a second secure database, which can only be accesses by a RWOP query in the front-end. What I'd like to do is have an - Unsecured backend - but with one table ...

Help - Shared MDE - Exclusive Access message box

Suraj - 31 Jan 2007 5:14 PM - 3 messages

Dear firends, I did some research and found several articles about this issue but none helped to resolve. I have a MS Access 2003 database having 3 files: 1. MDB - Back End file (contains: data) 2. MDE - Front End file (contains: forms, reports, queries, VBA) ...

How to modify the shortcut to the front end/security through VBA code

mpfohl - 31 Jan 2007 4:12 PM - 4 messages

I have a secured front end and backend database I'd like to distribute over my network to many computers. The backend will be on the server, each user will get their own version of the front end to be placed on ...

log report

kawther - 31 Jan 2007 4:31 AM - 4 messages

good morning, is it possibile to create a log report for any changes done by the user. i.e user1 insert record one, user2 delete second row and so on. thank you in advance ...

permissions

Everaldo Ricardo - 30 Jan 2007 8:48 PM - 5 messages

how to print group/user permissions ? using User level security(mdw). ...

DB Security isn't working properly.

vwilson - 30 Jan 2007 6:12 PM - 3 messages

Hello, I need to secure my DB. I did the following: -Created a workgroup file and joined it. -Created a new DB while joined to the new workgroup. -In security removed Admin from Admins group and added myself. -Removed all permissions from the Users group. ...

How can I limit user access to records in a table?

Challenged by boss - 30 Jan 2007 5:33 PM - 2 messages

I have a database that contains salary information for each employee. I want each Manager to be able to see/edit only records of their staff. How can I do this? ...

links from Word to Access mdb lost after defining user accounts?

Piet - 29 Jan 2007 5:00 PM - 2 messages

Hi, I have a problem that Word documents referring to an MS Access mdb for merging cannot find the mdb anymore. Even redefining the mdb link from Word does not work. Word says that the mdb was not found on the network location, where it definitely is. ...

Can't Import to Secure Database

EM.Bateman@gmail.com - 29 Jan 2007 3:31 PM - 4 messages

I have a database that I've set up with two security groups - the first is read-only access for general users, the second is an Admin account that should allow full access. I used the instructions that have been posted here a few times. ...

Users Can't Open Access Database Security Or Corruption ??

davstar.f@gmail.com - 29 Jan 2007 2:11 AM - 2 messages

Hi folks, It was suggested I repost this problem here. Please don't yell out about multi posting. I have a problem where I copied the front end of an application to the local office server. If a user opens the front end they get an ...