Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

security 2

Status
Not open for further replies.
mrk2

mrk2

Technical User
Aug 19, 2002
76
0
0
US
I have setup user and group accounts on my database and while working locally on my machine the securirty works. But the database is sitting on a file server and when I load the database and the "workgroup information" file it only prompts myself for passwords and usernames and no one else accessing the file server. Any thoughts on this problem?
thanks
 
Sort by date Sort by votes
This Thread may help you

thread702-397741 Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!
 
Upvote 0 Downvote
while that is an interesting thread. I am looking to use access's built in secuirty group levels. Please post any other suggestions.
 
Upvote 0 Downvote
It's sort of awkward but the way it's done is;
1. make a copy of your SYSTEM.MDW file (it contains all the security info) and put it on your server.
2. at each workstation, find a file called WRKGADM.EXE. Run it to join that workgroup, i.e. browse to the server version of the SYSTEM.MDW and click OK.

This has to be done on each workstation.
Note: it won't work to copy WRKGADM.EXE to the server. It seems that each version of windows has it's own version of WRKGADM.EXE and one version won't likely work with another OS version. You'll need to search for the WRKGADM.EXE on each workstation to make this work.
 
Upvote 0 Downvote
this seems kind of ridiculous. you can only apply password security to people who you want to use the database, but anyone else with access to the server has free run of the program?
 
Upvote 0 Downvote
The other way is to use the secure database wizard, but it has it's own drawbacks. It does really secure the database.
 
Upvote 0 Downvote
how does the wizard not secure the database?
 
Upvote 0 Downvote
Hi,

If you have security set up correctly then only those users you have given permissions to will be able to access the database.

Once you have created your own MDW secure the database with the wizard. Ensure that you have made yourself a member of the Admins usergroup, (do this while logged on as the defaul user Admin, if I recall correctly). Then log off the database, and logback in as yourself. Go to the usergroups and names and make sure that the Admin Name has the Admins group removed. Then go and set the security on all the forms report tables, queries etc (do this by group for ease) and you should have a secure database.

Heres a good link to help you set up security


Also create a short cut for users to use to open the database which will ensure they have joined the correct workgroup (MDW). This will look a bit like

"C:\Program Files\Microsoft Office\Office\msaccess.exe" C:\XXXXX.mdb /wrkgrp C:\YYY.MDW

Where Green is the location of Access,
Red is the location of your database
Blue is the location of you security file.

Hope this helps
Rob![BigCheeks]
 
Upvote 0 Downvote
how can i create a link that includes these three componets?
"""""""""""
"C:\Program Files\Microsoft Office\Office\msaccess.exe" C:\XXXXX.mdb /wrkgrp C:\YYY.MDW

Where Green is the location of Access,
Red is the location of your database
Blue is the location of you security file.
"""""""""""
 
Upvote 0 Downvote
On your Desktop screen right click and go to new Shortcut, and in the command line add the above line with your DB detail in it.

hope this helps Rob! [Bigcheeks]
 
Upvote 0 Downvote
Below is line command line options. The system tells me that the text contains "options" that access can't work with. See any problems?
C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE C:\209.243.34.9\Registration\db1.mdb
C:\209.243.34.9\Registration\System4.mdw
 
Upvote 0 Downvote
Try this

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\209.243.34.9\Registration\db1.mdb" /wrkgrp
"C:\209.243.34.9\Registration\System4.mdw"

The Wrkgrp was missing, and I've enclosed it in "" which helps on my computer
Rob! [Bigcheeks]
 
Upvote 0 Downvote
no that dosnt seem to work either. what does the /wrkgrp do am i suppose to replace the "wrkgrp" with something spcecific to my database?
 
Upvote 0 Downvote
The wrkgrp joins you to the MDW. I have heard it said that there can be problems if the files are to many folder deep. Try putting the MDB file and the MDW file in a higher folder.

do you get an error message, if so what does it say Rob! [Bigcheeks]
 
Upvote 0 Downvote
Rob is definitely right that a properly secured database will not allow users without the correct permissions into the database. And the link to the Access security FAQ is key--read that thing three times and you'll know everything you need to know to make a database fully secure.

I have a write-up in the developers' section of my website that discusses how to deploy databases. In this write-up I go into making batch files and shortcuts to get this job done.

If you do check it out, I'd love to hear back from you about how helpful it was.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

Take a look at the Developer's section of the site for some helpful fundamentals.
 
Upvote 0 Downvote
ok, I have succesfully made the shorcut work with the help of all your tips. But I still have a problem, with a direct link to the database on file server it will let you in without a user name or password. How do I secure the database so that if a person does not use the link i created it will not let them in?
 
Upvote 0 Downvote
That means that the database has not been properly secured. Follow the steps in the security faq and it will not be possible to do that.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

Take a look at the Developer's section of the site for some helpful fundamentals.
 
Upvote 0 Downvote
Jeremy, I simply have to send you a star! I just followed the instructions on your website about using a batch file and I love it. It works wonderfully and will be a tremendous time saver for me from now on. Thanks for sharing with us. Ann
 
Upvote 0 Downvote
Jeremy, I forgot to ask something. When my db opens (with the logon screen) it only occupies the bottom half of my screen. The batch file is in the top half. Did I miss something in your instructions? Ann
 
Upvote 0 Downvote
Ann,

Glad it's working out for you. I will actually be updating that page in the next week to show some more stuff I've learned. Bug me in a week if it hasn't changed.

I've never seen the screen-splitting behaviour you describe. I do know that you can right click on the task bar icon when the batch file is open and tweak the settings to make it get displayed where you want. I just changed my window position numbers to get it to hide behind the task bar, so users won't see it (though the task bar icon is still there until the datbase closes--I can change that in win 95, but not win 2K pro). Maybe tweaking those settings will help?

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

Take a look at the Developers' section of the site for some helpful fundamentals.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

LimitedTech
  • Locked
  • Question
Errors, I believe related to Macro security
Replies
2
Views
34
LimitedTech
LimitedTech
robertsquestion
  • Locked
  • Question
mdw security error: "cannot open a database created with a previous version of your application 1
Replies
5
Views
87
combo
combo
PugnaxX
  • Locked
  • Question
Many to Many With Privacy/Security (without a combo box)
Replies
5
Views
43
TheAceMan1
TheAceMan1
Pack10
  • Locked
  • Question
Security for an Audit Log table
Replies
10
Views
56
MazeWorX
MazeWorX
hoofit
  • Locked
  • Question
Security
Replies
2
Views
15
assets
assets

Part and Inventory Search

Sponsor

Back
Top