Security Newsgroups: Access Security

Audit trail

rascal - 28 Jan 2006 10:48 PM - 6 messages

I found an Article on creating an audit trail of record changes in a form in Access 2000, Microsoft article ID 197592. It works well except for the fact that it also tracks the fields that haven't been updated. Is there anyway ...

Form Permission Denied

Randy - 27 Jan 2006 10:51 PM - 7 messages

I cannot open my deployed database - when I click the icon, I get a "do not have open/run permission to open it" I split my database into front-end and back-end. The front-end opens a form via MDE file. ...

reinstalled XP w/o decrypting some files stored on another drive

Granny Noir - 27 Jan 2006 10:50 PM - 2 messages

I'm hoping that there has to be some fail safe way to recover encrypted files in this case. I use four physical hard disks on my machine, and have several different backup strategies, BUT, I recently did a clean reinstall of ...

building a web site

admin - 27 Jan 2006 1:23 AM - 3 messages

I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at [link] where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. ...

Trying to set security levels

Cassi - 26 Jan 2006 7:29 PM - 10 messages

I have tried to set security levels in my database. I used the security level wizard and seem to have gotten the result I wanted from my workstation, but not from any others. The database is on a network drive and the security ...

Re: AllowBypassKey

zyus - 26 Jan 2006 10:14 AM - 4 messages

Hi, Ive followed your instruction but cannot get thru Expected = error msg pop up.. any idea? ...

Creating Login

Christy - 26 Jan 2006 1:47 AM - 11 messages

Hi, I am new to AccessVba and was being assigned to complete some security features for a few database within limited time. I will need to create secured login for up to 20 users namely in 4 different groups: User - only read access ...

Hyperlink for read-only form

KErickson - 25 Jan 2006 10:37 PM - 2 messages

I have a few forms that, among other things, contain hyperlinks to PDF. I would like the users to be able to view (not change) the data on the forms and yet still be able to click on the hyperlink to open the PDF associated ...

permission to access a file

Antonio - 25 Jan 2006 9:52 PM - 3 messages

i went through the user-level security wizard and now when i try to open the file i get the following message "you do not have the necessary permission to use the '-file name-' object have your system administrator or the person who created this oject ...

Access to the Database

Martin Hopkins - 25 Jan 2006 8:25 PM - 2 messages

Hello, I currently have a database that can be accessed by trade managers within work. This control clients details etc. However due to a reorg and section changes I need to allow only certain users to access the database. Can you help with the following: ...

Where is the file that holds the password storaged

A. Williams - 25 Jan 2006 7:35 PM - 2 messages

I need to delete the security level of my database back to only the admin level. How can I do that without deleting my entire database. If there is anyone out there whocan help me fic the security errors in my database. I ...

Display of Message "You do not have eclusive access toa database..

Ian Shaw - 25 Jan 2006 6:59 AM - 14 messages

Hi Can someone please help me?? Whenever there is more than one person logged into a networked database we get an icon that says we do not have exclusive excess to the database. if we click the "OK" button 31 times the icon disappears and everythink apears OK. ...

Linking FEs to BEs - XP Problem?

Al Camp - 24 Jan 2006 3:29 PM - 7 messages

Since my customer migrated to XP, I've had problems with using the Linked Table manager in Access 97. The Client has a network, and I am just a single XP Pro user. Occasionally, I receive the files from the client to work on. ...

in query expression 'MSysAccounts.name'. ERROR

Andrew L via AccessMonster.com - 23 Jan 2006 11:40 PM - 11 messages

When I open an existing DB or create a new one, I cannot open tables or queries. I can't open them in design mode either. I just get an alert dialog that says, "unknown" for newly created test DB's. ...

You do not have exclusive access to the database at this time.

p sqrd - 23 Jan 2006 7:24 PM - 7 messages

I support an Access application that is rolled out to approximately 1000 users. The frontend and security file are pushed to a folder on their hard drive and the backend is maintained on a network server. Of the 1000 users only three are getting the error message, "You do not ...

Folder permissions for backend

Todd Lemen - 23 Jan 2006 3:12 PM - 5 messages

Is it possible to set permissions to a network share such that a user group could not view the list of contents of the folder (say in Windows Explorer, My Computer, etc), but read, write, execute, add files... all the things ...

Secure Command Button

Karen - 23 Jan 2006 3:10 PM - 2 messages

I have a command button on my main form and it opens another form. Is it possible to password protect the command button or is there another approach? Thank you ...

Cannot find wrkgadm.exe

Samantha - 23 Jan 2006 2:56 AM - 2 messages

According to all the write-up on setting up security in MsAccess, the first step I need to do is to create a new system database (System.mdw) by opening up the Wrkgadm.exe file. The problem is I can not find the file. I tried finding it using the search ...

do not have send or new message option on microsoft 2000

kay - 22 Jan 2006 6:20 PM - 2 messages

I bought my computer second hand. I am not able to use my Outlook 2000. It does not show the send or new message option. Is there something that I need to set up? ...

Tracking Users on a Shared Database

Kinlene - 22 Jan 2006 4:40 PM - 5 messages

I need better control over my networked access application. Is there any way you can track which all users that are logged in and which machines they are currently using? ...

Is there a way to Retrieve Current Group?

IM - 22 Jan 2006 5:20 AM - 4 messages

Is there a way to get the group of the current user (similar to the currentuser() function) ? Thanks, IzM ...