Access Security - Week 43, 2007

Access 2002 Full Data User cannot save. Save grayed out.

Briklyn - 26 Oct 2007 8:45 PM - 2 messages

Just changed to permissions in a database. Have users set up as full data users, but the save icon and save under file are grayed out. It will not let her save data. I went through the users and made sure everything was checked ...

compact and repair

NJS - 26 Oct 2007 4:30 PM - 4 messages

Good day All. I have a server-initiated (cmd) VBA batch job that compacts and repairs the Back-End. Periodically a user shuts down before logging off the Access app, and locks up the process. How can I clear road-blocks (Permission denied ...

Database Backend Data password

Roy via AccessMonster.com - 25 Oct 2007 7:02 PM - 3 messages

We are conducting migrating our Access97 & Access2000 databases to Access2003. In doing so a lot of the backend Access databases have a database password prompt. I've use Debug.Print StPasswordOfStDatabase("C:\xData.mdb") ...

Can I copy a user that is on MDW?

Marco - 25 Oct 2007 6:27 PM - 2 messages

I need do duplicate a user. I'm using security system of access and I need to duplicate a user in order to have the same access level. Thanks, Marco ...

Basic Concepts About Security Work Groups

Tom Glasser - 25 Oct 2007 3:28 PM - 4 messages

(1) Can multiple databases be assigned to one work group? (2) Can a user or group belong to more than one work group simultaneously? Thanks, Tom ...

test

Qadeer - 24 Oct 2007 11:55 PM - 2 messages

test ...

Post Package Solution Wizard Question

steve02a - 24 Oct 2007 5:31 PM - 8 messages

I can get through the process of making the package in Access 2007 so I can deploy my DB to end-users - however, upon installing it on their machine (including the 2007 runtimes), the DB never opens. I get a security notice ...

Update Security using VB Code

neil_D - 24 Oct 2007 9:03 AM - 2 messages

I have a database that uses user level security, Certain tables have been allocated Read-Only access, by changing the group security. Unfortunately, the <New Tables/Queries> item in the 'MyUser' Group has no privilages. I Know I can modify the <New Tables /Queries> Security group from within MS ...

Removing A MS Access 97 DB Password Using MS Access 2007

Debbie Rollins - 23 Oct 2007 9:33 PM - 5 messages

Hi everyone. I have several MS Access databases that were created in Access 95/97 and were password protected. I need to remove the passwords from those databases using MS Access 2007, but am not able to do so. ...

Windows username - Access Security Log

arjun.banerjee@gmail.com - 23 Oct 2007 8:01 PM - 2 messages

I am trying to create a security log in MS Access 2003. What I am trying to accomplish is to create a report of all the users who used the database (i.e. username, data & time). Ideally, I would liked to have the Windows login as the username. ...

Security Report -Access

arjun.banerjee@gmail.com - 23 Oct 2007 7:58 PM - 2 messages

I am trying to create a security log in MS Access 2003. What I am trying to accomplish is to create a report of all the users who used the database (i.e. username, data & time). Ideally, I would liked to have the Windows login as the username. ...

Security Warning

rbecker - 23 Oct 2007 5:08 PM - 4 messages

I started a database to keep track of our vehicles. I used my version of Access 2003 that is on my computer but every time I open the database it gives me the following Security Warning: Opening "C:\Doc..." ...

Access 2007 Error 2614 - User level Security

Uncle Buck - 23 Oct 2007 2:51 PM - 4 messages

I am a relatively experienced Access developer, but I am trying something I have not tried for several versions. I have a main form (frmMainMenu), with a listbox (lstMenu) presenting available Forms on the left, and an empty subform control on the right ...

Do Table Permissions Override Query permissions?

lizo.consulting - 22 Oct 2007 9:59 PM - 3 messages

Hi, I administer a database in which the permissions have been "messed up" by another administrator. I need to reset the permissions for all objects in the database, but there are so many user created queries this is a daunting task. ...

acess runtime 2003

Paulo - 22 Oct 2007 7:34 PM - 2 messages

how can i change the administration group file in one access runtime workstation? thanks in advanced ...

dao technique to add column to table in remote ULS db..

nycdon - 22 Oct 2007 6:53 PM - 2 messages

Can I (and if so, how?) pass id/password thru vba/dao so can add column to Table in remote User level secured Back end database? (access 2000)?.. thanx! don ...

User-Level Security problem - app does not trigger logon screen

David Anderson - 22 Oct 2007 4:12 PM - 7 messages

I've done my best to manually set up User-Level Security on an Access 2000 database using the instructions on Joan Wild's website (and the MS Security FAQ) but I've hit a problem. I set everything up while joined to a brand new MDW file of my own creation. ...