Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 95 Security Basics

Posted on 1998-07-21
3
Medium Priority
?
282 Views
Last Modified: 2006-11-17
Currently, we have a SITES. mdb file and its associated ldb file residing on a file server.  All of the users (50) connect internally to this mdb file over the network.  Each workstation has Access installed on it.  I am at the point where I need security on this mdb file but have the following questions:

Since the Jet engine is on each individual workstation, how do I setup central security?  If I setup a copy of Access on the file server, does that handle the security for all workstations?  What about other users of that file server that have Access applications that have nothing to do with SITES? Will they then be asked to log on to their applications? What happens if security is setup on the SITES.mdb file and a user creates a new database at their workstation?  Would they then have to log in to their new database or would their be no security yet on the new mdb file?  One of my resources is the Access 95 Developer's Handbook by Litwin and Getz, but it doesn't answer these overview type questions.
0
Comment
Question by:rbrow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Accepted Solution

by:
islitsa earned 400 total points
ID: 1976954
here is how it works for my db:
1.i set up a central security on my server using wrkadm.exe file for the workgroup. by default, this file handles security for ALL access applications for ALL the workstations connected to the server.  yes, it looks really dangeraous because if i do so, the users will have to log on to EVERY access application.  each new db created by a user will require by default the same security because the security is network set.  poor users will not be able to handle any even simple applications .
2.here is the way to go around it: shell scripting
you go to your microsoft office folder, get to access icon[startup icon], right click and click :create a shortcut.
then you go to the new shortcut and click properties. in the properties window you look at the target line and that's what you write there:
"location of your access icon [startup icon] "/NOSTARTUP "location of your database on the network"/wrkgrp "location of your mdw file" ( mdw file is a file where you set your workgroup profile, you can learn about it in access help real easy, just type in security and then under security choose workgroups)

here is the example of my database shell scripting for windows 95
"C\Program Files\Microsoft Office\Office\MSACCESS.EXE"/NOSTARTUP "C:\Irina's Stuff\db2.mdb"/wrkgrp "C\Irina's Stuff\Irina.mdw"
it works the same way for the network security.

hope it helps at all :)
sincerely,
irina
0
 

Author Comment

by:rbrow
ID: 1976955
Thanks for the answer.  Does the mdw file reside on the server or on each workstation?  If a user tries to access the database on the server from anywhere other than the icon that you have scripted, what happens?
0
 

Expert Comment

by:islitsa
ID: 1976956
the mdw file resides on the server, put in the same folder where workadm.exe is and then reference it in the target .
you put the shortcut on the network where you would put the database and you hide the real database, don't let the users know that this is just a shortcut, let them think it is a real database icon.  therefore, the only way to access the database for them will be through the shortcut, meaning they will have to go through the security.  for instance in my company, i put the database on the server  in one folder, and the shortcut i can put in another folder called database.  then i tell the users: " go to the folder "database" and access the icon called "the company database"".  they go and they have to log on the database because the workadm.exe makes  them log on.
read about workadmin, it tells you everything besides the line i wrote you, myself i spent about 5 hours to find this script.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

661 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question