Access Security - Week 3, 2009

log in passwords

fishqqq@hotmail.com - 17 Jan 2009 4:13 PM - 4 messages

Our backend data is on a server which requires the users (via their workstations) to log in with a password to access the server. Is there a way to have the workstation ask for this when the user starts their computers? ...

hiding the back end data

fishqqq@hotmail.com - 17 Jan 2009 4:09 PM - 2 messages

I have the back end data that all the users use on a server with "server 2008" and all the users are using a front end program on Access 2003 (operating sys is Windows XP). can someone tell me how to ...

O-2003 mdb with O-2003 and O-2007 users

David - 16 Jan 2009 9:42 PM - 2 messages

I have an Office 2003 database on a LAN share that is being accessed by users running both O-2003 and O-2007. Both the front-end and back end mdb's are on the LAN. Before the O-2007 users came along ...

Database 30 Day Password

Rod - 16 Jan 2009 12:52 PM - 4 messages

I would like to distribute a database for standalone use but have it only work for 30 days at a time. To enable it to work for 30 days at a time I would like to require the user to put in a password which I will provide. ...

How to Identify a Digitially Signed Database ?

Sri - 16 Jan 2009 12:06 PM - 4 messages

hi, I have to identify weather a database is digitally signed or not , thru coding, like we have in excel VBASigned property ...

2007 access to a 2003 database

BCiel - 15 Jan 2009 7:26 PM - 6 messages

Hi I have a database in 2003 that has user-level security. This database is located on a server and 7 people have access to it. One of these people has Access 2007. When they try and open the database they are told that they do ...

User Level Security on Replicated

Mrs. Ugh - 15 Jan 2009 2:59 PM - 3 messages

I have a replicated database (one replica) that I now need to secure with User-Level security. I just plan on using the wizard. I have secured in this manner before without trouble, but I have not done it on a replicated ...

Other methods for preventing "not have exclusive access at this time" message?

jlbaze - 15 Jan 2009 1:55 AM - 4 messages

My users see the 'you don't have exclusive access to the database at this time' message each time they open the database, and they have to click 23 times (I'm not exaggerating) to get it to go away. ...

Linking to a password protected BE from FE

Ryis - 14 Jan 2009 5:35 PM - 11 messages

Hi everybody, I have a FE & BE system in access 2007, I would like to protect the BE from ever being opened but still link from the FE to the BE..can this be done?? I tried to protect the BE but then I cannot connect to it. ...

Secure part of a db?

Sherlock - 14 Jan 2009 4:36 PM - 4 messages

I have a small 2003 or 2007 database (have started in both, trying to accomplish) with just 4 or 5 tables and a handful of forms. One form is a questionnaire that associates are supposed to fill out. The questionnaire ...

recordset not updatabale

JohnLute - 12 Jan 2009 8:58 PM - 3 messages

I have a small, secured application that's split into FE and BE files with the BE placed on a server for global access over a WAN (I can hear your groans). Be that as it may (reality can be ugly) I need help understanding an error ...

Security Problem When Linking Tables

K8Gardner - 12 Jan 2009 6:30 PM - 4 messages

I've designed two databases. One is my main database that one group uses and the other is a satellite database that has a couple of links to tables in the main database. I had no problems linking the tables before I opened it up to ...

read only for forms and tables only

James - 12 Jan 2009 5:29 PM - 2 messages

Is there a way to set a password for the forms and tables so they cannot be changed but, leave full access to the reports so the reports can be changed? ...

2003 or 2007 Security

BrookieOU - 12 Jan 2009 4:05 PM - 2 messages

I have a database that was designed in 2003, but I recently converted it to 2007 (though I still have the backup). I want to be able to set user-level permissions because there will be lower-level data entry people updating ...

vba opendatabase readonly

Laursen.Aarup - 12 Jan 2009 6:13 AM - 8 messages

The following code does not open my frontend in the same way as an open as readonly by manual method! If sUser <> "jrla" Then 'Set user privilege Dim db As Database Set db = OpenDatabase(CurrentProject.Path & "\IOFE.accdb", False, True) ...