Hi. I manage to create Users and permissions with no big problem.
But before do that, i thought that when i created those permissions some of the users which they will
work for, they will not have even a view of TABLES QUERIES FORMS e.t.c
How i can hide that from them?
I did that by Properties and set the option button to Hidden, but imagine if you have 50 to do that.
Then if i go back to do some modifications then is necessary to unhide in order to check.
Is another easiest way of prohibiting users to view.
Thank you.
Hello all, I am setting up an access 2003 database in a Client/Server configuration. All dat entry is done through queries, forms are not used. I am wondering if it's possible to prevent users in the client database (Or a copy of it) from creating new queries that hang of the linked tables. I want them to hang new queries only from existing queries. This way I can be sure that what they see is always appropriatley filtered. Any ideas?
I enabled security on an .mdb which included several users that are in the Full Data Users group. After I did this I needed to add a new form to the application, so I logged into the application and added it. However, though the admin group and the Full Permissions group can access it fine, the Full Data Users group cannot. I have double checked all of the settings and have even rebuilt the .mdw file to no avail. Any thoughts?
Hello can anyone help me with a code or application example of how to hide all db elements. I have a database and i want only a main form to appear for users and tables, code, etc to be hidden.
Im using this piece of code to hide the switchboard while a login form appears on startup. The Switchboard still appears maximized in the background. I dont know that is happening when I have asked for the form to be hidden.
'// function to shape form to bitmap fInitFormShape Me, "AirLock.bmp", RGB(255, 0, 255)
'// show system user name Me.txtLogInName = fSystemUserName '// show system pc name/id Me.txtPCName = fComputerName
Me![txtPassword].SetFocus On Error GoTo ErrorHandler 'The switchboard form is opened but hidden in the open event of the login form.
I want to prevent people accessing the control boxes on a 'satalite' mdb. I have hidden the control at the top through the start up options, but havent prevented the special keys as I occassionally need to get in this database for error fixing and such like. I want to know if I can put a password on this function, so that if they know it and try it it asks for a password before opening the control windows/table pages etc.
does anyone know if this is poss and if so how too ???
This is in regards to user security. I'm a relatively new user to Access (and this forum). My company uses Access 2000 and I'm taking over a database thats used by several departments at my company. This database contains sensitive information so I put user security on it using the wizard. Due to the nature of the database, a particular user group needs to have the ability to create new tables. The problem is this: No matter what I do with the user group security settings, I cannot prevent other user groups from creating new tables. Is there a way to prevent certain users from adding a table?
I have to make it so user group cannot modify/update/delete data in tables, but con do the same in forms. Yet if I uncheck those in 'permissions' it's not possible to change anything forms either
For some reasons management doesn't want tables to be in diff database
How can I separate my application so the users can still use queries and reports on a db? I don't want them touching the tables or application directly so it looks like I need a way to create a separate application or something along those lines that is linked to the tables that the users want to query. Any suggestions?
I currently have a query and a table which I'd like to create a form for. The query has people's information in it and the table has RSVP information in it (if they need parking, etc.). I'd like to create a form so that I can type in the person's name and then it brings up their address (just to confirm it's the right person) and then i can enter in the RSVP information. Any suggestions?
I have an Access 2000 database and I have hidden the database window in the startup options. I have also saved the database as a .mde file.
However, if a user opens the database while pressing the shift key they can still get access to the queries and tables in the database and can change them.
Is there anyway to prevent users getting access to the tables and queries?
I'd like to implement something in an app to allow users to create their own ad-hoc queries from a specific number of fields from specific tables, without allowing them full access to the query designer.
I can see how to do it (a form with code that creates the SQL), but I wondered if anyone had done something like this before and had any tips or even any existing code. Have searched and can't find anything, but I suspect I'm searching on the wrong keywords.
I have an access database that is used as a front-end application to a sql server 2000 database. Users have adequate permissions to access database and functionalities but a few are receiving the following error message:
I have a database where there are 3 tables. table "d_cases", table "d_user" and table "d_status"
The table "d_cases" has the users and statuses only with a number. Peter has ID 2, John ID 1. There is status ID 1 that is New, ID 2 Started and so on.
How can I run a query that will show me the names and status instead of the numbers?
I am new to MSACESS........and i am just trying a small project and having a problem .... when ever i use any table / query in the expression builder of a FORM element...i am getting this error mesg " Automation object table / query not found "..........Should we link the objects of same database in some way ?? R they not connected??...Why is it that form elements r not recognizing tables of same database???...i am trying on this in several ways......but not able to solve this.... :( ....plzzzzzzzz can anyone help me out with this??????
I have a dilema on my hands as I can't seem to figure out the best way to accomplish this. I created a database to handle all of our letters for my department in the company. The problem I am having is that we have 26 people who could possible access the database at the same time. The letters are created using a form. (not a problem with multi-users) When someone wants to print the letter the do a search either by "Letter Date", "Provider Name", "Provider Number", or "Group Name". I set it up so either one of these search queries append data into one table called "Letter Report Information" all 38 letters get there data from this 1 table. The problem I am having is that if John and Mary try to pull different/same letters at the same time or while one is viewing their letters the data is getting pushed onto the others Letter.
Example:
Mary goes to print her Welcome letter John also goes to print his Denial letter at the same time
When John's letters show up.. the Denial letter shows up with his data, but also with Mary's Welcome letter data.
What can I do or what kind of query can i use to avoid this problem as it is becoming a very prominent issue? ::Please Help::
Is there a place I can insert a snippet of code to have all the forms come up full screen. Some users think it is annoying that they dont always come up maximized. Any help would be greatly appreciated!
I have a list box with a row source query as follows...
SELECT qryPendingCompletions2.ID, qryPendingCompletions2.Department, qryPendingCompletions2.[Employee Name], qryPendingCompletions2.CompletionDate AS [Completion Date], qryPendingCompletions2.[Entered By], qryPendingCompletions2.Goal, qryPendingCompletions2.Comments, qryPendingCompletions2.[Verified By] FROM qryPendingCompletions2 WHERE (((qryPendingCompletions2.Department)=[cbocurrentemployee].[column](3)) AND ((qryPendingCompletions2.[Verified By]) Is Null)) ORDER BY qryPendingCompletions2.Department;
I also have a combo box at the top of the form showing what user is logged in where the row source query is the following...
SELECT Employees.UserID, [First Name] & " " & [Last Name] AS EFullname, Employees.AccessLevelID, Employees.Department FROM Employees WHERE (((Employees.AccessLevelID)=1 Or (Employees.AccessLevelID)=2 Or (Employees.AccessLevelID)=3 Or (Employees.AccessLevelID)=4));
How to only list the data in the list box when the department is the same as the logged in user.
So I'd like to add the criteria to the first query something like criteria = [cbocurrentemployee].[column](3) but this doesn't seem to work as criteria in queries.
I've been using Access 2007 to run queries on a database where we eventually export results as separate Excel spreadsheets for individual clients. The process is quite involved, using queries to change fields from code letters to words and splitting the database up into different client tables, saving the tables under date order and with different client codes.
I now need to pass this role on to colleagues, so need to make everything as straightforward as possible.
I had thought to use a Form as the user interface, with a minimum number of buttons, however I need either the system or the user to amend the date for the initial table, then to use this new table and run a series of standard queries on it, then produce the separate tables.
I don't think I can just use macros behind the buttons, because the database name is changing each time.
I assume some parts will be too tricky to automate - it will be necessary for colleagues to follow instructions instead.....
I've created a database which works fine and i've tested it extensively on my machine. It is saved on a network drive which other users have access to. I've added a simple security log-in procedure (which I picked up from a sample posted on here) which only determines what buttons the different users can see on the switchboard which takes them to the different areas of the database. The problem I now have is some of the forms aren't opening.
Other Users who try and go into the forms that they have access to - even some of the generic ones cant open the actual forms as it crashes and comes up with the generic error message - "Microsoft Access has encountered a problem and needs to close".
I cant understand why this is happening. The security measures are only linked to the main switchboard and it works fine as it opens up all the other relevant switchboards as required. It's just certain forms on the other switchboards that refuse to open. I hope I have described my problem adequately and someone has encountered it somewhere or knows what I'm talking about and can help. Please let me know if you need further clarification.
Hi, very new to access and chucked in at the deep end. we require a database which will be used by multiple users to place orders. the users are at different locations although they all log on via terminal services so connection issues are minimal. i understand that we require a fe/be database because of the users. the users will only work with forms and reports. they should not be allowed to see the other users orders and the form needs to automatically put the users id into the order. the only way i can see to achieve this is to make a custom form up for each location. would i be right in assuming this? if so, how would i prevent one location from opening up another locations form? infact, i wouldn't want one location to know that there are other forms for other locations. any help would be appreciated. thanks
The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's. But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.
My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.
I'm wondering is it possible to create a multiple parameter query which will return results even if you leave some of the parameters blank ?. I'm trying to set up a Form which will allow users to select parameters using combo boxes but at the moment you need to fill them all in or you'll get no results...