Security Newsgroups: Access Security

Becoming the Owner

Sprinks - 15 Sep 2006 8:21 PM - 6 messages

For some reason, I am not the Owner of my back-end database, which prevents me from setting any permissions regarding new objects. Is there a way to recover from this? Thank you. Sprinks ...

Record-Locking

Sprinks - 15 Sep 2006 7:25 PM - 6 messages

I am currently testing my first multi-user application. User-level security has been implemented, and seems to be working correctly, however, record-locking is not. I have a few questions I hope someone can help with. ...

Multiple users

Marc - 15 Sep 2006 4:15 PM - 2 messages

I will be having multiple users entering data into my database. My question is how can I get the users to only have access to the forms and nothing else? ...

How do I remove permissions in a database?

JMF - 15 Sep 2006 7:11 AM - 2 messages

For some reason, I have put in place security restrictions (even though I don't need them) on my access database accidently. Even the Admin user has no permissions. So I am stuck. I can open the database, but nothing else. ...

Help!!! Erased all permissions, what do I do?

timwood - 15 Sep 2006 3:24 AM - 2 messages

Hi everybody, In the process of trying to limit access to certain folder on my external hard drive, I 1) turned off simple sharing 2) selected the folders and went to security, and I think I got a ...

Removing Security from One MDB

tbl - 15 Sep 2006 12:14 AM - 3 messages

At work (a small state office), a co-worker has an Access db that will only open with the shortcut that provides the paths to access and the MDW file. When opened by the shortcut, there is no logon requirement. ...

Secure Backend

LDanix - 14 Sep 2006 9:13 PM - 2 messages

Hello, I have a backend database and several frontends. The database has sensitive data that only users of one of the frontends are authorized to view and alter. Is there some way to lock down access to the backend by unathorized ...

dynamically reposition controls on a form

Jay - 14 Sep 2006 8:21 PM - 2 messages

Is there a way to know the positioning coordinates of a control on a form? I need a routine that will for example "move all controls on the form 1 inch to the right". The code below would work if I had the value for the variable oldPositionX, ...

Security Problem with Adobe 7.0

rdemyan via AccessMonster.com - 14 Sep 2006 4:24 PM - 4 messages

I've implemented workgroup security and have Admins and PowerUsers group (Users group does not have any permissions to view tables and I use RWOP queries). Everything was fine until one of my clients IT shops started installing Adobe 7.0 Professional on some of the machines. ...

shortcut just to access

S - 14 Sep 2006 3:35 PM - 4 messages

All the examples of shortcuts using workgroup files I have seen involve an existing database. I thought though that to be the owner of a database you have to create it whilst logged on to the workgroup file you want to use to ...

Make mdb Read Only in code?

JohnB - 14 Sep 2006 12:01 PM - 7 messages

Hi. I have not implemented full user security on my mdb, basically because of the number of problems it seems to cause and there is only a small number of users. Instead, I have a simple password checking form. Is there a way of making the mdb Read Only if a particular password is ...

cannot open access database on network but can open all else

sue131974 - 14 Sep 2006 11:24 AM - 4 messages

I am trying to open an access database located on a networked computer. I get the error message "Microsoft Access cannot open this file. This file is located outside yourintranet or on an untrusted site. Microsoft will not open the file due to potential security problems. To open the file ...

Security nightmare

George - 14 Sep 2006 6:01 AM - 5 messages

Dear gurus - need your help again, I helped a friend to secure his access database in his office server - using the User-Level security wizard. Now, he asked me to create some more reports for his database. Issue 1: When i copied the database on my PC does not open. Why? ...

problem with a batch file wkgrp parameter

azpat - 12 Sep 2006 6:17 PM - 6 messages

This is a real bugger. Can someone help me???? I have posted several times trying to get help with attaching a database to a mdw file. I have read the microsoft information and I seem to be doing everything correctly. I have tried both a batch file and the easy updater. ...

Default CurrentUser when not opening form

Carl Colijn - 12 Sep 2006 3:22 PM - 4 messages

Hi group, I found a peculiar situation with my database. When I first use CurrentDB and then show Workspaces(0).UserName in a MsgBox, I get the name of the logged in user. However, when I do not first access CurrentDB and ask for ...

MDW locks, cant add/modify users

Doug Bemis - 12 Sep 2006 1:56 PM - 8 messages

We have been using this database on terminal server for a long time, but recently had to move it to a different server. It used to run on Server 2000 with Access 2000. It is now running on Server 2003 EE with Access 2003. We converted the MDW ...

How do I retrieve a User PID

Hoo-Mee - 11 Sep 2006 9:01 PM - 3 messages

I have inherited a group of databases within a domain, where the users and groups were already set up (long ago, but added to). It appears that users were not deleted as they left due to a concern as to whether there might be ...

Reset Security Utility?

sparker - 11 Sep 2006 5:11 PM - 2 messages

Greetings to all, Does anybody here know of a utility that can be purchased to reset all security for an entire Microsoft Access 2000 system? We have a somewhat complex system that uses a single mdb (user interface) to utilize around 78 mde's and 3 ade's via 18 mod's (mod = mdb dif name) all of ...

Warning message

Matt Dawson - 11 Sep 2006 8:56 AM - 6 messages

When i open my database i get a warning message asking whether it is safe to open depending on the code I have Is there any way to get rid of this? Many Thanks, Matt ...