Security Newsgroups: Access Security

Link to a RW database from a RO database?

Leif - 27 May 2006 10:07 PM - 12 messages

For security purposes I would like to create an Access database in a directory defined as read-only for a certain class of users. However, I need to programmatically record their access to the database when they open the ...

details

GUESSIMNOTTHEOWNER - 27 May 2006 7:13 PM - 2 messages

my father knows computers inside out. he;s running about 4 machines of his own (pchome, pcwork, laptop, handheld, who knows what else) and my pc on his powerdesk program, which is ridiculous i wish i could put it out for ...

stolen ownership, round 2, isnt this illegal?

GUESSIMNOTTHEOWNER - 27 May 2006 6:58 PM - 6 messages

I'M DUMB. TOOK A YEAR TO REALIZE PC DAD GAVE ME IS ON HIS NETWORK AND UNDER HIS CONTROL, SAME AS ALWAYS. IS THAT NOT ILLEGAL? I THOUGHT I REBOOTED AND DISABLED HARDWARE SUCCESSFULLY WEEKS AGO. THOUGHT I WAS FREE AND CLEAR, ...

Created Database Password Fine Then Used Security Wiz & Can't Open

c21cwag - 25 May 2006 6:29 PM - 2 messages

I am a new Access user and have created a simple table and a simple form. I then went into "Tools", "Security" and "Set Database Password". I closed out of Access, went back in, opened the database, was prompted for password and ...

switchboard w/ 2007 beta?

jasonshohet - 25 May 2006 6:02 PM - 11 messages

I'm kinda new to Access switchboards - and am trying it out on the Access 2007 beta #2. Basically - I just want this: Users (except me - developer) should see only Forms & Reports. NO tables / queries. If anyone has Access 2007 beta, can you explain how to do this, in ...

Cleared 'Admin' Password now can't open database

VBA Dabbler - 25 May 2006 3:22 PM - 12 messages

I have a user-level secured Access 2002-2003 database. I was able to access it this morning, but after clearing the 'Admin' user password can't access the database, receiving the following: "You do not have the necessary permissions to use the <name> object. Have ...

Limit use

Candace - 25 May 2006 3:01 PM - 2 messages

I've created user and admin accounts but Access can't seem to differentiate between the two. I want users to have to log in to the database, not Access and I want them to have VERY limited access to different areas of the ...

Password protection on a specific button?

Matt - 24 May 2006 10:47 PM - 3 messages

From what I understand there is a way to put password protection on a specific button on a form and not have to put it on the entire database. If this correct, does anyone have a step-by step way to handle this, or a link ...

Linked tables and network security

FL Don - 24 May 2006 8:10 PM - 5 messages

Can linked tables in a folder otherwise blocked by network security (NOT Access security) be read/written to from a front end not in a blocked folder? Thanks. ...

Deleting Duplicate Values in a Query

skennd - 24 May 2006 1:24 PM - 3 messages

Here's my problem in exact replication: I have used the find duplicate query in Access, and the query determined the following duplicate values by the following query: In (SELECT [DocNo] FROM [File Name] As Tmp GROUP BY [DocNo] HAVING ...

Read Only

John - 24 May 2006 12:34 PM - 2 messages

Suddenly, my DB on the network opens "Read Only" and I can't figure out how this switch was turned. (perhaps during the last Network Failure???) I am listed as the owner in the Properties, I have changed all the properties on ...

VSS and objects permissions

Eric - 24 May 2006 7:26 AM - 2 messages

Hello, Context : I'm using VSS and the addin for Access 2003 for configuration management. I have an Access database FE/BE with specific mdw (groups and users). I have craeted a VSS project Problem : When I generate my Database from VSS all permissions are lost ! ...

Disallow viewing of hidden objects

Jerry Boggess - 24 May 2006 1:55 AM - 2 messages

I am using Active Directory security in an Access 2003 database and it works very well for contolling what the user can do from a form. I disable the use of the ShiftKey so the user has to work with my form when in my database. ...

Having trouble with a spyware in my comp...

Giordanetto - 23 May 2006 8:03 PM - 3 messages

I downloaded the new Spyware remover from Microsoft and even though it has removed most of the programs, apparently it cannot take one out because it does the scan and says to do a reboot and then the remaining spy/adwares will ...

Database Splitter - Moving FE to local PC

Dorna Tucker - 23 May 2006 1:47 PM - 8 messages

I made a mistake when using the DB splitter to split the DB. The BE and FE is placed on network server in the same folder. Can I copy the FE to each user local PC? How do I create the shortcut on the users PC to run Access ...

How do I get rid of hyperlink warning in Access

pugkayaker - 23 May 2006 12:14 PM - 3 messages

I have a database with hyperlinked operating instructions. How do I get rid of that red screw warning that hyperlinks may be harmful to computer/data? This is SO annoying to all the database users! ...

Disable this warn message???

samer alsaleh - 23 May 2006 8:19 AM - 2 messages

dear all, good day i tried this code by an Access Application DoCmd.SendObject acReport, "Invoice", acFormatRTF, _ "[fax: " & ![SQNo] & "]", , , , , False ...

Make MDE in Access 2003

Gary J. Dikkema - 22 May 2006 4:25 PM - 3 messages

How long should it take to create a MDE file? Is it SLOW or quick? Thanks! ...

Excel files suddenly need a password to open

Edsys - 22 May 2006 10:28 AM - 2 messages

I've got a client who emails Excel files which are created from templates and contain cells which are protected and also a macro with password protection. The password for both cells and macro are the same. The original templates were created with Excel 2000. Now when the ...

User-Security for an item in a database?

Matt - 22 May 2006 12:41 AM - 3 messages

Does anyone know if it is at all possible to place password protection on only a piece of the database? What I am trying to do is allow everyone to open the database but when a specific button is pressed, only a handful of ...