Can someone post a copy of a sample mdw file so that I may observe the design of the database? I am very new to the concept of db security and would like to take a look at how the design is constructed. Thanks!
View RepliesMight be a stupid question but here goes.
I have successfully created my own private workgroup and have set up security levels for 4 users on one access programme that l have written.
I have a second access programme that l use with the same users, however l want to set different user parameters, can l set a second workgroup up as l did the first.
Is two workgroups possible on the same machine ?
Regards
Andy B
I'm trying to set-up and secure a networked multi-user database. I used the Workgroup Administrator to create a new workgroup and save it to the network drive. However, when I open my database, it seems it may still be pointing to the the default SYSTEM.MDW workgroup on my hard drive. Do I need to do something to my database to tell it to point to the new workgroup I have set-up? When I start having other people log in from different locations, will they need to join the workgroup or also point the database to the networked workgroup when they open the database? The manuals aren't very clear on this, please help.
View 1 Replies View RelatedThis is more of a point of interest then a question, at work, Access defaults to a central workgroup file, so all Access files opened on a work machine will prompt for a user name and password, and only let you in if you get it right... but if you move the work group file, even after it has been open using that workgroup file, it will just let you straight in and GIVE YOU ADMIN RIGHTS!
No one really seems to know about this... does it happen if you manually set the workgroup file? Or is this just a security hole if you rely on the default? I'm not sure yet, haven't tested, but i fell people should be made aware (happens for sure on Access2002, haven't tested it on any others)
-mwalts
I was looking for free access add-ins through a search engine when I came across this site. I'm not sure whether or not some of the more seasoned programmers have seen this, but so far it looks like a less confusing alternative to the security features that access comes with. I'm not in any way advertising this, and I haven't tried it myself yet, so I can't speak about how good or bad it is, but it may be something worth looking into. Here are the links:
http://www.accesswizards.com/Downloads.html This lists the add-ins that are available from this particular site.
http://www.accesswizards.com/SecDetails.html This is the "read me" information about the security add-in.
I've designed an access ade file (based on sql server) and distributed it at the network.
Somebody else has made another database (mdb) and placed the users in a access workgroup file by placing their windows logons into the workgroup file. These users happen to be the same users accessing my application. The following thing is happening : "when the users open my database they are prompted their user names and password of the workgroup file'.
I placed an empty database and the same thing is happening, the workgroup security is active alongside every database deployed to this specific user group.
How can I easily 'tell my database' it shouldn't make use of the workgroup security?
(It's odd that an ade which isn't able to use workgroup security prompts users by using workgroup security)
Hello,
I cant seem to get a certain setting right. I am trying to setup a user for the database that I have been working on. It keeps saying the following:
"It says I do not have necessary permissions to open. Have the system admin. Or person who created the object establish appropriate permissions for you."
I have that person assigned to the following:
Full Permissions
Full Data Users
Updated Data Users
And they still are unable to open the database.
Now from what I have read on this forum, I shouldn't give any personal permissions. So I have assigned users to groups and given the groups permissions.
In regards to the security question, what are bare minimums for a user to open the database, use the switchboard, choose a form, enter/change data via the form, and view reports.
I dont know the difference between:
Open/Run
Read Design
Modify Design
Administer
And I am afraid to give more than what I need, and I feel like I am just guessing and hoping to set it right. Thanks for any direction in this area.
Hi,
I've created a duplicate of our database in order to be able to work on the design of it from several locations. At present the database which is being used has been split into FE (on local machines) & BE (on server), with a .mdw file for the workgroup settings.
For the duplicate I have created a new database with all the Tables, Queries, Reports, Forms, Macros and code copied from the FE & BE files into a single file. My question is, to be able to work on this from remote machines / pass it on to others to work on the design, do I need to have a copy of the MDW present with the duplicate, or is it possible to remove the workgroup and security permission settings?
Hello people of access world forums. I've decided to design a simple access db with 2003 version but with 2000 compatibility and everything appear to work ok.
After designing and testing the db, I have set the Jet user-level security options as described in some documentation and set the startup options too for a "clean type" start. Everything is ok: I have created the workgroup in a new .mdw file, joined the workgroup, set the users, set the groups, protect the forms I wanted to. If I try to open the db, it asks for user and password and the db works as espected about security.
But if I delete, move or change the .mdw filename, the db turns accesible without the implemented security. Only the startup option works but no user is prompted and the protected items turns unprotected.
I would like to know how can I associate the .mdw to the .mdb so I can't access the .mdb if the .mdw file is not present (i.e. copying the .mdb to another computer or something).
Thanks in advanced.
Kish
Ok.. I have done this before at another job, but this network (or stupid me) is giving me trouble. I'm trying to setup a database security (login/password) for a database on a network. I setup the security levels..setup a seperate workgroup... From my computer it logins fine with the correct workgroup.
I setup a link:
"G:Maximizer DatabaseMaximizer.mdb" /wrkgrp "G:Maximizer Databasemaxsecurity.mdw"
Under my network login it pops up with the correct login/password prompt.
On others, it goes into the database under "READ ONLY" but gives them access to the database in read only. It should using that workgroup.
Any suggestions?
The purpose of this project is to aim the security mechanism an allow and restrict of individuals or group of individuals of the database. Define the security accounts and groups of users allowed to access.
Users: Can view / add / edit of data into the database.
Superintendent: Has view access to database but is limited only to their section.
Manager: Has full access to database but is limited to their section.
Administrator: Acts as the overall administrator for the database. Has full control over all data and objects contained in the database.
Most likely the closest example of this database is annual leave application. If individuals is/are adding data and only his immediate Superintendent can view with limited to his group and the same with the Manager as we have four (4) sections (Finance; Procurement; Services; & Management) in one unified department.
I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.
Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.
I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)
Hi there,
I'm trying to put in place a workgroup and I'm struggling with it at the moment. I created a seperate workgroup and have a command line short cut to it. When I try to add a user to the admin group permissions it works fine except that I can't open any of the forms in design mode. It says I do not have exclusive rights . I dont know what to do. I though that the admin password would be set to blank but It won't open the database either.
Any ideas, im pulling me hair out.
I have the security set via the Access workgroups for both groups and users. I want to be able to use the username entered on the logon screen to filter my query results.
How can I get the logon id that was entered when my switchboard form opens?
Thanks in advance.
Dennis Cronin
I currently have several Access 2003 databases on my computer. I have been working on a new one that must be secured.I have created a new .mdw file to handle this. The path to this file is included in the shortcut. Everthing works great.
HOWEVER:
Whenever I close this database and then open another, it is still promting me for a password (the other DBs aren't supposed to be secure). I have changed the shortcuts to go through the old system.mdw but it still does it. When I change the workgroup manually, the secure database no longer prompts me for a password. It would appear there is more to selecting the workgroup than just editing the shortcut.
We have an old Access 97 database with a workgroup file. The problem was that the machine was upgraded and the software was changed to XP. They support guys moved all files to the new PC except the the workgroup file. We can't fine a backup of the w/g file.
I am unable to upgrade the database to access 2002 because of the permissions.
What is the easiest way to get past this stumble block.
Thx
We are running two versions of Access (97 and 2003) on some of our machines. We recently set up a new workgroup file, but it seems that on the machines that have the two versions of Access the workgroup file reverts back to the old setting everytime the user logs in again.
What do we need to do to prevent the workgroup file from switching back?
Thanks
Present
Go to user computer, and then manually to join the workgroup.
Is this possible?
Send email to new user.
Join workgroup using a zip file. When file is un-zip the user automatically joins the workgroup and places a short cut on there desktop.
Not asking for to much, you think.
Hi,
I setup user-level security on the database. the workgroup file was deleted by somebody.
How can I open the database?
Because I create the same name for workgroup group file and input the same WID. It did not restore the original one I lost.
Right now, the database cannot be opened.
Please let me know how to solve.
Thanks.
help,
i have forgoten my workgroup password, can anyone recomend some free software that will allow me to recover the password.
thanks
Hey all,
I was wondering if any of you guys know how to specify a custom workgroup file in a shortcut to my database.
This is what I've got in my shortcut:
C:TESTTEST.mdb /w "C:TESTSECURITYFILE.MDW"
Basically I want access's system.mdw to remain the default mdw for access but want my mdb to use a different mdw.
Many thanks!
I would like to link to a table that is not in the same workgroup as the database I am working in.
Both databases are from different departments - I only want read rights to the linked table to run queries against some data in my database. I have access to the database I am trying to link to - but have not been able to figure out a way to do this?
Is there any function or code that would display the workgroup in which the current user belongs simular to the function "currentuser()" which displays the user logged onto the db?
View 9 Replies View Relatedhi,
do you know where can I get a file sample of ms access database with the following features:
- entry of persons,
- entry of projects,
- calender of projects,
- payement for their work,
- print-out of vouchers,
- on-line access for persons to DB (with password).
i've looked around the internet and couldn't find anything. I would love to have this just as an example, to build my own on-this-sample-driven database.
i've done something in PHP but since VB and PHP are not similar, i really would love to have an example.
thank you for your help
Hi all,
I am on my way to building my first relational DB. Is anyone able to look at the attached sample and tell me if I am on the right track?
The DB is being desined to record Repair information carried out on a machine. (TblRepair)
The DB will also eventually record refurbished machines (TblRefurb) and also many other situations like stock control, etc.(yet to be designed). Before I go on I just want to check:
> Is this roughly correct so far?
> If I create a new record in the existing form, why can I not enter both UnitID and EmployeeID? Relationship conflict?
> Should I be building forms on a query? (I think the answer is Yes, just need confirmation).
> Is it because of a problem with the query I cannot enter details correctly? (as per the above question).
Any pointers would be very welcome. PS Sorry its v.old A97!
Hi,
Does anyone know where I can get a sample database that shows me a order form that rmoves items from stock as they are being brought?
Kind Regards
David