Security Newsgroups: Access Security

Microsoft Jet 4.0 Service Packs - Service Pack 8

Studebaker - 24 Mar 2007 5:56 AM - 4 messages

I installed Access 2003 on my computer which uses Vista Home Basic as the operating system. Access 2003 says the following: "Microsoft Jet 4.0 Service Packs starting with Service Pack 8 include an updated sandbox mode that allows Microsoft Office Access 2003 to block ...

Front End / Back End Permissions

tbl - 23 Mar 2007 5:10 PM - 2 messages

How should permissions be set for the Data Entry group with respect to front end and back end. Should the back end have no permissions for anyone besides the admins group? ...

Log users

sandrao - 23 Mar 2007 4:13 PM - 2 messages

We reciently had a problem with a database. It became corrupt and we can't access it. Is there any why that I could find out Who was the last user, the problem that occurred. Could the problem be logged in a place other that the databse being used. ...

Shared v. Exclusive Access

Bob Bonta - 23 Mar 2007 1:44 PM - 10 messages

Have I misunderstood the difference all along? Can/would anyone out there take just a moment and explain, from Microsoft's point of view, exactly what shared access means and what exclusive access means? Is MS Access capable of allowing multiple users in the same database? If ...

Security newbie

JoeA2006 - 23 Mar 2007 1:25 PM - 2 messages

I need to secure a departmental database with a few different groups of users. The database is split. The backend is in a network folder and each user will get a copy of the front end. My startup up form uses VBA a connection string to connect to the front end ...

Don't need security in Access 2007 or Access 2003

OldManEd - 22 Mar 2007 9:42 PM - 9 messages

When I try to open a secure file (created in Access 2007) in Access 2003 I get error 3033, 'You do not have the necessary permissions.......have your system administrator ....." I AM THE ONLY USER AND, THEREFORE, AM AN ...

Access 2003 and Access 2000

RT - 22 Mar 2007 5:30 PM - 6 messages

I have a database that I have secured following Joan Wild's step by step instructions. After the DB was secured, I then opened Access 2003 (without opening a database) and rejoined the default workgroup system.mdw. If I open the secured database is Access 2003, it asks for a password and ...

RWOP /table permissions question

Beth - 22 Mar 2007 3:42 PM - 7 messages

Hi, I have a database in Access 2000, split into FE/BE and have security set on both sides. The file is converted to an mde before shipping. I am trying to protect the integrity of the program as much as possible as I ...

Problem with Replica

mww - 22 Mar 2007 10:05 AM - 8 messages

I have designed a secured database on my machine. I created a replica on a shared network machine (used only to store the database replica.) I then accessed the replica from a third machine but am having a problem - the user ...

I'm Ready for Security

RobUCSD - 21 Mar 2007 7:53 PM - 4 messages

I've been working on a comprehensive Access data base for managing patients in sub specialty of cardiology. I'm ready to take on security as my next big issue. I have implemented user-based security with the security wizard and encrypted the back end db. I ...

Digital certificate issue

Herb - 21 Mar 2007 12:29 PM - 6 messages

I'm using Access 2003 under WinXP Pro and having trouble with the digital certificate signing process. I created the digital cert on my laptop and then exported it to a file. I moved that file to my desktop computer and imported it to my Personal certs ...

PKI Certificate Authority

Robert - 21 Mar 2007 1:14 AM - 3 messages

Hi, Hope someone can help. I've created an offline root CA and an online issue CA. The certs work fine within my domain and we can sign and encrypt email perfectly. Now, I'd like to know how to make my domain certs trusted outside my ...

Convert a mdb Database (accdb) to a previous version database (mdb

Joao Pedro Malheiro - 20 Mar 2007 10:53 AM - 14 messages

I Have a big proglem. I install the New Microsoft Office 2007, very good design. But something I don't see... How do I convert a database accdb to the format that can be recognize by the ADO in Visual Basic 6, before I use the Convertion to 97 format. ...

Write access without read access

Adam Milligan - 20 Mar 2007 12:10 AM - 5 messages

All- I am running Access 2003 on Windows XP. I have a database that tracks staff incident reports for a school. I would like for anyone to be able to add a record to a table, but then have only a select few be able to review old ...

Access 2003 w/ User Level Security - NOT WORKING

Nick Coppola - 19 Mar 2007 10:24 PM - 3 messages

Hello, I have an Access 2003 that uses user-level security. Here's what I did... 1. Moved the DB and MDW to the directory on the Vista/Access 2007 machine 2. Added the directory to the Trust Center locations ...

Split mdb, Confused User

tbl - 19 Mar 2007 10:02 PM - 15 messages

After splitting an mdb int o "front end/back end", and playing an extended game of "try this", and reading the FAQ and several other writeups, I'm still confused. I *thought* I read that the back end tables could be locked ...

Problem deleting users from User Level Security

NewSysAdmin - 19 Mar 2007 8:23 PM - 3 messages

Hello. I'm using Access 2003 and have setup user level security. I haven't figured out how to delete users who no longer should access the database from the user level security. I've tried going into the wizard, but when I select a user, the Delete ...

How to open the .ldb file and use the info within, current users?

Mac - 19 Mar 2007 2:52 PM - 4 messages

Does anybody have some sample code to allow me to open the .ldb file of the current database running the code. I am running ACCESS 2000, and using ADO on a local database stored on a network shared drive. I need to view a list of the current users logged into the database from the ...