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 have a custom login screen created for my database and a table with access levels for different users. I am trying to assign user permissions so that certain buttons on the switchboard are visible/not visible dependent on the user security level. As the login screen and the switchboard are on seperate forms, is there any way I can do this??
I've been pulling my hair out since last night so any help at all would be appreaciated
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.
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.
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!
This 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)
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)
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.
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).
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.
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 am having multiple user problems with access 2000 quite frequently, and I thought that replication would solve this, as it stands however its proving difficult to get my hands on the developer edition, just wondering, is it worth the hassle to get it, or is there an effective alternative to replication?
The field is called CS: Like [Enter Specialist Last Name Only] & "*"
It works ok, but of course if you don't type anything it will bring all the records up for view, and I don't want that to happen. Can I do something that won't make that happen?
I want to be able to use something like DDESend for putting data into word bookmarks. I already have several instances where this is done with code but I need some others with a simple thing like DDESend.
The problem I have with DDESend is when the form opens a box pops up asking if the Word file is to be opened. I tried with code to first open the Word.doc file and then have the code open the form with the DDESend text boxes but that ends opening two instances of the same Word.doc and the screen all quivers:D
If I just open the form in question and then click OK to open the Word.doc, then close and reopen the form (but without closing the Word.doc, just shrinking it) then all is well. But it is not practical to do that for what is wanted.
Any ideas or an alternative to DDESend. An alternative would need to be simple like a DDESend in text box as it requires someone to be able to easily change field references.
I am designing a database in which I have used a lot of listboxes sourced to tables. I need to run queries on the listbox results but this doesn't always work due to the listbox/query issue, (found on this forum).
Is there an acceptable alternative to listboxes as the only thing that I can think of is to use checkboxes which would make the data entry for the end user interesting? (The only way around this would be to have individual databases for each person, this defeats the objective of having a database...)
I have a query worked out with the exact result I'm looking for, but it's kind of slow. Can someone find another way to write up this query?SELECT EID, ShortName, ClassID FROM ( SELECT Employee.EID, Class.CID, Class.ShortName FROM Employee, Class ) AS Temp1 LEFT JOIN [Class Attendance] ON (Temp1.CID=[Class Attendance].ClassID) AND (Temp1.EID=[Class Attendance].EmployeeID);The inner (green) query pairs every employee with every class they could possibly take (cross product). Then that query is joined with the attendance table to show who has taken which class. If a class hasn't been taken the ClassID will be null like so:EID ClassID ShortName ========================= 111-11-1111 1 ISM 111-11-1111 2 ABC 111-11-1111 BGP 222-22-2222 ISM 222-22-2222 2 ABC 222-22-2222 3 BGPSo is there an easier way to get this result?
In a table with 5000 records there is a field named "products" with 800 differents products (product1, product2, … product800). I want to create a new field in a query and mark 100 of these products as "Not available" and the rest 700 as "Available". For a small number of products I can do this in QBA, using IIf function. E.g. Products not available:IIf([products] ="product5";"Not available"; IIf([products] ="product10";"Not available"; IIf([products] ="product22";"Not available";"Available"))). How can I do this for 100 products Thank you.
I wish to send a report to the PDF printer driver but DO NOT wish to switch the default printer settings. Having found some helpful code on this forum that changes the default printer to the PDF driver, prints the job and then reverts the default printer back to the original printer device.
I am still using Access '97 and although in the code, the default printer does revert back to what it was originally, the Default Printer status 'tick' no longer appears under Start/Settings/Printers.... Consequently, subsequent print jobs outside of Access go to another device and not my DEFAULT printer.......???
Any ideas would be gratefully appreciated.
Oh - in case I wasnt clear - I want to do this in code NOT using the Print dialog box.... !
Can I use MS Flexgrid in MS access ? When I try to use it, it shows I need licence. Is there any alternate method to use flexgrid or is there any alternative ? Basically, I need to facilitate edit and save option for users. Urgent help required ?
I have a helpfile that I want to open on a Event. But when i use Application.FollowHyperlink I get an annoying warning (the file can contain viruses or in other ways damage your computer) so I wonder if there is another alternative to Application.FollowHyperlink?
Hi I've got some code from http://www.lebans.com/alternatecolordetailsection.htm
It allows for alternate bands of color to be displayed for alternative records in Forms in Continuous View. I've looked in this forum for other alternatives to this but the only ones that are available change the background of a control rather that display a whole row that is filled with colour. So therefore the background of the row is say in red, the background of the text controls are in red.
I've managed to put the code into my form and download the class. The only problem is that I can't seem to set the colour in the actual class file - it's all a little bit confusing! Can you help? Pleaseeeeeeeeeeeeeeeeeeeeeee........... :D
You can download the sample database from http://www.lebans.com/alternatecolordetailsection.htm
I have tried to create an MDE file for my database but can't figure out why it will not let me. I can't don't think I am over the limit in open TableIDs. I have 76 Forms and 91 Tables.
I am setup with two databases - the database with the data is on the server. Is there any other alternative that I can do other than putting the mdb file directly on the client. And if not is there a way to stop the mdb file from constantly growing in size.
What I am doing, is I have various products with 5 basic fields. I then wanted to add an array of text fields to 2 of those original 5 basic fields. I attempted to do this with a subdatasheet, however, a subdatasheet is not record specific, is not directed to a specific field, and really does not do anything that I want.
Say that the basic field is ProductDescription. I want one column of fields to correlate to it, like below. ProductDescription Is blue Is large Is heavy Is strong
Each product will have a different amount of varying descriptor fields. Once understand how to incorporate this with my project, I then will need to understand how to add the subdatasheet to a report easily. Thanks for any help, -SethTherrien
If any one can make a suggestion it would be great. I have a list of names with phone numbers, addresses and emails. I thought I could use a combo box to select the name and and have the other date associated with it come up in the appropriate boxes set. I can't get it to work. Does any one have any suggestions on how to make it work or another method that can be used. The out come I want is to allow someone to pic name from a list which will then set the phone number, address and email correct. Ideas would be great.
I am trying to avoid to use a Combo Box & a List Box because of the way the records are stored in the table, I only need to verify that the user does not enter a 3 letter code that is not contained in a specific table (I have a table of countries with the 3 letter code example if the user types ESC instead of ESP an error appears) Is it possible to use the after update to verify the contents against a table?
