Access Security - Week 32, 2006

Need help with security

erick-flores - 11 Aug 2006 8:44 PM - 15 messages

Hello all I need to secure my database. This is the first time I am doing this, so I have no clues oh how to do this. Basically, I have a Expense Report Interface, I want only the manager to be able to look at all ...

Network security

mwest - 11 Aug 2006 4:01 PM - 3 messages

I am using Access 97, I have completed building the program, there will be other users who will be using the program. Is there any way to set it up so that they can view the records, and add new ones, but not be able to alter ...

Logon to Access

Chocolup - 11 Aug 2006 7:04 AM - 3 messages

Some time ago I was experimenting with Access security. As a result, every time I open any Access database, I am asked for a name and password in the "Logon" box. None of my databases have passwords and this box comes up for ...

Splitting database with password

Bernard - 10 Aug 2006 8:13 PM - 2 messages

I wish to split my Access database 2003 which has 25 tables. I used the splitting wizard but the backend database then has no password. When I add a 'be' password the 'fe' cannot access the 'be' because of the new password. I ...

Locking a database

Sabrina - 10 Aug 2006 3:13 PM - 7 messages

I have an Access2000 application with 3 linked databases (tables only). I am trying to lock the application down so users who have full MS Access installed cannot get to the data by going into the database window and opening any table(i.e. they should only be able to view data via forms), this ...

please help

tarchie via AccessMonster.com - 10 Aug 2006 2:27 PM - 3 messages

hi all help needed.. Can I customize the access icon of my database (am very very new to access) ...

database security

Leena - 10 Aug 2006 8:15 AM - 3 messages

I tried to set sercurity for a database. Now when I am trying to open a new or existing database, it is prompting for user name and password. I tried using all the users name that I created but nothing is working. Tried to ...

Instead of Autoexec, can one startup with a module?

Harris - 9 Aug 2006 9:36 PM - 5 messages

Security messages popup if one tries to open a database that has a macro, and Security level has been set to "high". I have only one macro - autoexec - which runs code in a module to check links "checklinks()". Is it possible to have the database automatically ...

Encode/DeCode same as Encrypt?

Robert T - 9 Aug 2006 5:07 PM - 3 messages

Hello: All of the documents I've read on Access 2003 states we can encrypt data in the database and I should look for the Tools/Security/Encrypt Data option. However, I don't see that option, but I do see a Tools/Security/Encode/Decode ...

Snafu 2

Paul Hammond - 9 Aug 2006 2:17 PM - 4 messages

This seemed worth a separate post. I went through the wizard once more, this time using a tutorial from a text book. I created one admin user, myself and one Full Permissions for a user. This time I don't even get a login dialog. I am told "You do not have the ...

CompactRepair on a secured Access db

Jonathan - 9 Aug 2006 1:19 PM - 8 messages

Hello all, Is there a way to run the CompactRepair method on a user secured database? This code works fine on an unsecured db but not on a secured one. VB6.0 code... Dim strSource As String Dim strTarget As String ...

Security Snafu

Paul Hammond - 8 Aug 2006 9:34 PM - 4 messages

I'm a security novice in Access. I was experimenting with setting up Groups and Users and from one PC at least I now cannot open ANY databases. I get asked for user name and password no matter which database I try to open. I ...

Windows 2003 User Share

Mojo - 8 Aug 2006 6:29 PM - 2 messages

On a windows 2003 server, is there anyway to see when (date and time) a certain user was given access to a network share? ...

How do I remove my security.mdw file from my database?

Anna Predslava - 8 Aug 2006 12:42 AM - 3 messages

I ran the MS Access 'User Level Security Wizard' on our in house database. My manager did not like the users having to login. He hates the login screen and wants the users to be able to access the database ...

Re-enable Shift

The Joker via AccessMonster.com - 7 Aug 2006 4:27 PM - 3 messages

Good Afternoon, I have disabled the shift button when entering my database. Well now I need to add some more customization to my custom menu and can't access it. Is there a line of coding or something to that effect that I can put in a module ...

Query using 'start' & 'end' date parameter

pickles - 7 Aug 2006 12:42 PM - 3 messages

Hello, i've created a query that produces all the data held in my database and i've set up a parameter - 'Between [Enter start date] and [Enter end date]' to return only the data received between two specific dates however, when i ...