Access Security - Week 3, 2007

Hidden data

Gloria - 20 Jan 2007 3:20 AM - 3 messages

I have a database and I hid the tables, queries, reports so that when somebody opens the database, just the main page appears. If I want to se the tables, queries, etc. I need to go to to the menu, select Window, Unhide and ...

Creating User Level Security

Julius - 19 Jan 2007 10:49 PM - 2 messages

I apologize I should have created this in my other question. However now that mdw issue has been resolved, I need to setup user level security for two groups one is called Quality and need to have full rights, and the other will ...

TagASaurus

camaz - 19 Jan 2007 10:38 PM - 2 messages

Lately my Spybot Search & Destroy has been unusually slow - many "stall" points. Ultimately it shows it has detected TagASaurus, which I then remove. Next time around, there it is again. When Googling, I get a great ...

Undoing MS Access Security

Julius - 19 Jan 2007 9:01 PM - 3 messages

Good day all, I really need your help, sometime ago I setup up what I thought was user permission for my access db, however whenever I try to open access at my computer it is asking for a password, however when I log on at another ...

Difficulty with form security

Cameron - 19 Jan 2007 8:35 PM - 5 messages

I have taken over a database that is distributed to various branches of the corporation. I would like to define the security on each form for the users, but I am a bit baffled by the security. I did have forms assigned based on ...

Multiple Databases Question

Lythandra - 19 Jan 2007 8:21 PM - 4 messages

Hi there, I have several databases that reside in the same location on our server. I want to set up some security only on two of the databases really just to limit access to them. I first just had the a password set up to open the ...

Access 2003, Force user to change pasword every xx days

Larry - 18 Jan 2007 1:44 PM - 3 messages

I have a database that is setup with security. Users are required to use a password to access the database and this has worked well for the last year. Users have the capability to change their password at their convience but now ...

Can I retreive my data after compacting failed?

Lee5352 - 18 Jan 2007 4:32 AM - 4 messages

I had a user compact a 900,000 KB database and now the file size is 1620 KB and all the data is gone. I can see files left from the compacting routine, db1, db2,db3,etc. When I try to link to or import data from these files I get the message ...

Bypass Shift Key Problems...Help Please

satdist - 17 Jan 2007 6:54 PM - 7 messages

I have been trying to disable the shift key following a previous post. I made a new module and pasted the following code, (also I changed the sequence of the ADO and DAO references) pressed Ctrl-G and pasted faq_DisableShiftKeyBypass("c:\path to your db\whatever.mdb", True) ...

use windows username?

Miez - 17 Jan 2007 3:27 PM - 2 messages

Hi, is it possible to use the windows username of the logged on user in the access data base? I need only one form to be different for 2 users, and i do not want to completely securde the whole database with users and groups. ...

Urgent, Panic, Can't access my database

RobUCSD - 17 Jan 2007 3:00 AM - 3 messages

I just was checking out the security of a Access 2003 I have been working on and now when I try to open it, it prompts me for a user name and password. The user name and password I supplied is not working. Please Help! Please ...

Workgroup Help

dawnecia - 16 Jan 2007 8:15 PM - 2 messages

I have an Access database on the network and I have created a workgroup on the network. (I've joined the database to the workgroup) However, users are using the database without getting an error message that they need to join ...

can view access on network

Melinda - 16 Jan 2007 4:37 AM - 3 messages

Recently my boss is unable to open our database (access 2002) which is on our shared network. It previously worked but I was wondering if a recent upgrade to IE 7 is the culprit. I get this message "Microsoft Access cannot open this ...

Setting up User & Group Permissions & Accounts

Rahul - 15 Jan 2007 11:31 AM - 4 messages

I am developing a database application in VB.NET 2005 & using Access as my database backend. The application itself is in advanced stages of completion, but I am still wrestling with Access for setting up Groups & Accounts properly. I have tried ...

SQL Server security

zloc - 14 Jan 2007 7:54 PM - 3 messages

Hello everyone Does anyone know something about implementing SQL Server security in MSAccess Project ()adp front-end ? How to use SQL server DB roles to grant rigts on Forms controls ? thanks in advance ...

Database security on a Local Network

Rahul - 14 Jan 2007 10:02 AM - 13 messages

This is regarding general protection of a database hosted on a network. I am developing a database application for my college library using VB.NET, that will reside on a network. For some reasons, I did not want to hardcode the Database location in the ...

how can recreate .mdw

Al - 14 Jan 2007 1:36 AM - 8 messages

I lost my .mdw file. no back ups. I am the admin. I know what my id and password was. can I create a new .mdw and add an account with the same ID and Password as the deleted file? how do I do that if this is going to work? ...