Security Newsgroups: Access Security

Can you access the security user signons using a query?

Bunky - 5 Aug 2006 4:13 PM - 3 messages

I have an application that the user must enter their specific code into every record they touch. Is there a way for me to program the application to look at the security data and pull that information into a regular form? ...

Windows XP2 Login Problem

Quamar - 4 Aug 2006 8:08 PM - 3 messages

Since I have ghost this workstation running windows xp Profesional, I am getting this error message" The Local Policy of this system does not permit you to log on Interactively". I can sign in as Administrator, other user can not sign In. This in domain ...

Secuirty On Switchboard

4Ankit - 4 Aug 2006 1:30 PM - 2 messages

Hey All, I am developing a database and need certain features on teh switch board to be username and password protected. For example i want all the options avaiable to view such as : View Customers, View Employees, Create Payslip but i need some of the options when clicked to appear ...

*** Urgent Retrieve UID

Me - 3 Aug 2006 9:29 PM - 5 messages

I am relying on Sql Server Security for linked tables in Access. Now I have a need to know the UID of the user logged on. How can I get it? Based on this UID, I want to restrict access to certain records. ...

deploying secured database shortcut

Jake - 3 Aug 2006 9:28 PM - 2 messages

Hello, I have a secured MS Access db I would like to deploy as a demo. I have tested it on a few machines and it is successful, but I have one problem: I have to modify the shortcut path for the user's machine every time I install ...

MDW lost all users access

celias - 3 Aug 2006 4:51 PM - 8 messages

I use a mdw that I join into all my Access databases at work. The problem is there was an Access database that everyone uses that is in production. I had to make changes to some forms and reports, so I made a copy of it, and moved ...

Can one user be joined to multiple workgroups at the same time?

Donna Rae - 3 Aug 2006 4:46 PM - 3 messages

I have several databases that are secure for which have different workgroups. And sometimes a user needs to be able to work in more than one of these. Is there another way besides unjoining from one database and joining another ...

remove logon popup

paul - 3 Aug 2006 3:19 PM - 2 messages

Good Morning, I tried to deploy an Access 2000 application to my users. Most users seems no problem. But one user, when he run the application, the Logon security will pop up, ask to input password. How can I turn off that feature? ...

How do I reset my Access 2003 start-up options for a database?

Seanster - 3 Aug 2006 1:03 PM - 2 messages

Well, I've managed to turn off all my menu's for my database and I would love to be able to reset my start-up options so that I can continue to make cahnges to my database. Any suggestions for how to solve this problem? ...

Current user's password

sigava77 via AccessMonster.com - 3 Aug 2006 12:48 PM - 6 messages

Hi, How do I access the current user's password? Thanks, Carla ...

Masking Social Security numbers

kjtrip - 3 Aug 2006 2:44 AM - 6 messages

I need to be able to run a query in Access 2003 that takes the information from a field "Social Security Number" and masks all but the last four digits. Is this possible? ...

Task Manager Group Permissions?

adweber - 2 Aug 2006 3:55 PM - 2 messages

Here's my scenario. I need to grant the group "Power Users" the access to view all processes, started by all users. By default, the box on the task manager where you could click "Show Processes from All Users" is ...

Security has gone wild.

RTimberlake - 2 Aug 2006 1:43 PM - 3 messages

I am having some huge problems with my security. For some reason security and all user names and passwords work fine on my computer. However, when I go to my users computers things aren't working correctly. The users can only see the form header of each form, the detail ...

How can I disable the Security warning everytime I open a .dbf

RCaauwe - 2 Aug 2006 1:21 AM - 2 messages

I just installed Office 2003. Now, evertime I open my Access .dbf file, I get this Security warning which is annoying. Is there some way to disable it? ...

Linked Tables Security Problem

Reader1 - 1 Aug 2006 10:05 PM - 6 messages

Hello I'm involved with a project at work where we are using two different databases. The project is split into two areas. I manage one and another colleague manages the other. I'm quite new at this stuff so I posted in here and there and read the ...

Disabling Password in Access...

ksmith56 - 1 Aug 2006 9:45 PM - 4 messages

The company I work for uses Access to keep track of its clients. We are all using Microsoft Access 2000 from a complete Office 2000 Installation. One of the problems we have run into is that when my ...

shift override in split database

inbreda - 1 Aug 2006 2:55 PM - 6 messages

Hi I have a split database, both parts (FE and BE) have been copied to provide a development database. Both use the same workgroup file. When I further develop the database and try to distribute it for live use, all of the security groups and access rights change, so I have to spend ...

In Access 2003, databases are suddenly protected by passwords?

D.A. - 1 Aug 2006 12:36 PM - 2 messages

After Access 2003 set up, certain databases created with the Access 97 are suddenly protected by passwords that neither me nor my colleague have generated. We are now unable to enter these databases, because we do not know the password. Does Access generate these passwords automatically? Is there ...

Database Password

Bruce Mogayzel - 1 Aug 2006 3:18 AM - 3 messages

I want to set the Database password, and then have an AutoExec Macro or Start- up Form launch and automatically (behind the scenes) pass the Database password so that the user does not have to know the passwood (invisable) and ...

Is it a good idea to create my own navigational buttons ??

Wellie - 1 Aug 2006 1:59 AM - 2 messages

I have a new requirement to lock and unlock specify fields on the form such that users can or cannot edit data field depending on the condition of other fields. For example, if the record displayed is Approved by a supervisor ...

application deployment for SP2

Dan Bloomquist - 31 Jul 2006 5:52 PM - 7 messages

Hi, We have a product that uses mdb databases. Because of the security issue on SP2, my clients can't just install and run. Is there some way to get my mdb files signed for the computer they are installing on? ...

how I add an username + posword to a mdb file?

Hugo Polanco - 31 Jul 2006 4:54 PM - 4 messages

I have a homework to do and I don't want no body to open my file just my teacher so how I create a login + password when I double click the .mdb file? Thanks ...

Suggestion on deploying and securing an Access appl

NewAccessUser - 31 Jul 2006 1:48 AM - 3 messages

I'm relatively new the writing Access appl. Just finished a small appl and ready to be deployed. Read about security and still not sure what is the best way to secure and deploy this appl. Read about security from Help and ...

Problem with Multi-users in Access97

JIM - 30 Jul 2006 4:47 PM - 5 messages

I have developed a database linked to SQL server 2000 in access97. When I test the database on two of the three networks available to me, it will allow multi-users to connect. But on one of those networks (the one where ...