password for access

[stuart748]

hi

i have a database and want to control the access to it by having a form with two text boxes and a command button, the text boxes would ask for a user name and a password. i would like the user name and password to be held in a table so it is easy to change. i am using access 2000. thanks in advance for any help

 

[dannyocean]

Why not just use internal Access Security. It would give you more control than just access into the db.

Here are instructions that I have written.

I would add users level security. This allows Access to know how many users are in the db. It also will fix any write errors that may occur.

Here is the instructions to implement security.

I recommend setting up ueser level security. This will allow you to give right to specific items in your db. Here are the basics of setting up security. User level security also helps to aviod write errors your users may have.

1. Set up a mdw file for your db. Use the help instructions in Access for a Workgroup file.

2. After you create the new mdw make sure to rejoin the system.mdw file for your copy of access.

3. Create a shortcut in the target line you will need to fix the sytax. Here is a copyu of one of mine.
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" V:\Puball\UM\Discharg.mdb/wrkgrp V:\Puball\Um\Discharg.mdw

V is the network drive. DOn't go lower than two folder levels. I had trouble and that was an issue.

The shortcut launches access then your db and the associated workgroup.

Once you get the shortcut working. Go into tools, security, user and group accounts. Add you users. Then distribute the shortcut. Make sure to have a working copy of the shortcut on the network so you can retrive it for distribution.

This will allow all users global access to the db, but will fix your Write errors.

Let me know if you have further questions.

HTH
Danny

 

[JeremyNYC]

Danny's got the right answer. The tool is already built in Access. You won't build it better yourself without spending hundreds of hours on the process. And if you do that, you will be without the huge community of developers who know Access security. And you won't have the amazing resource of the Security FAQ, which you can get from MS or my website. Read it several times. Internalize it.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.