Security Newsgroups: Access Security

Microsoft Access 2000 User Level Security

pimlotb - 27 Jan 2007 11:26 AM - 2 messages

Hi Im pretty new to Access security and was lloking for some advice. I am looking to setup user level security on a Access db and am having the following problem. When I setup the users and passwords in a standalone environment it ...

Too easy to change data

PureEvil - 26 Jan 2007 11:00 PM - 13 messages

I have a split database that tracks employees, hours, jobs and project numbers. I am a relatively new user. I design/make changes on the database on a stand alone computer and email it to the user where they store both ends ...

Access 2003 - nonAdmins can't run Reports !!

bigpalooka - 26 Jan 2007 5:57 PM - 3 messages

I was installing my Access 2003 on client machines and found everything working normally on the development machine with full Admin rights. I installed on a few client machines and found that any machine with full Admin rights could run reports, but non-Admin machines couldn't. ...

Double Passwords

laliwalden - 26 Jan 2007 4:03 PM - 4 messages

I currently have a database that I created with Access 2003. It is set up with a password to open it. I would like to set up a second password that will open the database, but open it in read only. Anyone know how to do this? ...

read only database

Steve - 25 Jan 2007 2:35 PM - 3 messages

I have an access mdb database that was created by another user who is no longer with the company. I believe it was created with Access 2000 and I am using 2003 to open it. It works fine but will not allow me to add any new ...

prevent access to VBA and db window

Jesse Aufiero - 24 Jan 2007 6:15 PM - 3 messages

When I attempt to turn my access 2003 mdb into an mde i am informed by access that it cannot perform the operation because i have too many objects (or something like that). what are my other options to prevent users from ...

Question about Opening Exclusive

Cindy - 24 Jan 2007 5:01 PM - 5 messages

I have granted Modify Design rights to one of my groups that will need to modify the design of reports at times. However, when I log in as my Test ID for that group I get a message about not having exclusive access to the ...

Assigning Permissions - Modify Design vs. Administer

Cindy - 24 Jan 2007 4:57 PM - 2 messages

I was just wondering if I could get an explanation as to the differences in assigning these types of permissions. I really haven't found a document anywhere that goes into that level of detail. If anyone has a link or a ...

How do i share my database with no security?

dan@darwin - 24 Jan 2007 4:59 AM - 3 messages

Hi, created a mdb with access 2003 and put it on a networked pc and setup an odbc connection for it. It works fine for me from any other pc (using a shortcut to a form within the databse.) However any other user gets a read ...

Secure Database Before or After Split?

Cindy - 23 Jan 2007 11:02 PM - 3 messages

I was just wondering what the school of thought on this is, I haven't been able to find too much information on it other that what is in the Security FAQ. What are the implications of applying security to a database before you ...

User Access to Security Menu

Cindy - 23 Jan 2007 9:54 PM - 5 messages

I have been using Access for a while but am relatively new to the user security aspect of it, having never required it before. I am now in a position where a database I upgraded from an old version of Access (2.0, to ...

Executable Has Changed Since Last Used

AlleyCat - 23 Jan 2007 7:26 PM - 2 messages

Executable Has Changed Since Last Used: Sygate Personal Firewall gave me this warning after trying to open an incomplete avi file. I don't normally give WMP access to the internet anyway, but I just want to know if it's "safe" to allow access. Thanks. ...

Unsafe expressions are not blocked

Max - 23 Jan 2007 7:18 PM - 2 messages

I have several mdbs in Access 200 format in Access 2003. I continuously get error messages starting with "Unknown Publisher" then "Unsafe Expressions are Not Blocked". The next message tells me to download MS Jet 4.0 SP8 (which I ...

Switchboard security

Marie - 23 Jan 2007 4:41 PM - 10 messages

Hello, I'm currently working on a pre-designed database and need to know how to set up a security when users/groups access the Switchboard. Here's the scenario: 1. I created a form (using the Form Wizard) that was specifically designed ...

Avoid SQL injection in MS Access

Mawan - 23 Jan 2007 11:31 AM - 2 messages

I write this on Borland Delphi: command = 'select * from mytable where name = "' + Edit1.Text + '"'; Users can write SQL injection commands in Edit1.Text. How to avoid this? ...

Enter secure database via workgroup admin help please! A2k2

satdist - 23 Jan 2007 12:52 AM - 7 messages

I have a secured, split, and Shiftkey disabled database that gives the user an MDE file with a shortcut from the desktop. What can I do to make certain a user doesn't follow the path in the shortcut to join the ...

Unsecuring a Database

deodev - 22 Jan 2007 9:29 PM - 4 messages

Hello, I have a database that I am using that was created by my Associate who has since left the firm. He was the only one with Admin access and he did not leave the password. I am able to sign in to the database with my own ID ...

What is RWOP and how can I create it?

Tintin via AccessMonster.com - 21 Jan 2007 6:10 PM - 7 messages

Hi, I have same problem with Connie and Rick already answered nicely (below). After days searching until get headached, I still don't get the idea how what to do. Please someone explain to me step by step about what is "Run With ...

Preventing import of tables and other objects

Bill Murphy - 21 Jan 2007 3:31 PM - 5 messages

We have an mdb which contains tables with confidential data like salaries. Although this mdb application is password protected, and salary data is protected by security logic within the application this does not prevent a user from creating a new blank database, then importing all the tables and ...

How do I get Options back in my Tools Menu

Brunopeecees - 21 Jan 2007 2:16 AM - 2 messages

I had a window popping up about Security and somehow I have disabled my Options in the Tools Menu. How can I get it back Bruno ...