Hidding Tables, Queries, Forms, From Users

Dec 7, 2004

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.

View Replies


ADVERTISEMENT

Stop Users Using Tables In New Queries

Apr 27, 2007

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?

View 3 Replies View Related

Users Unable To Access New Forms/tables

Aug 1, 2005

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?

View 2 Replies View Related

Hidding All Db Elements!?

Nov 19, 2006

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.

Thanks!!

View 1 Replies View Related

Hidding The Switchboard

Feb 20, 2005

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.

DoCmd.OpenForm "Switchboard", acNormal, , , , acHidden

View 2 Replies View Related

Hidding Things & Passwords

Sep 21, 2005

Hello.

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 ???

Thanx in advance for your time

View 2 Replies View Related

Preventing Users From Adding Tables

Jan 30, 2008

Hi everyone,

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?

:confused:
Your help is appreciated

View 1 Replies View Related

Security - Not Letting Users Modify Tables

Jul 26, 2005

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

View 1 Replies View Related

Tables :: Create Log For Table To Capture Changes By Users

Mar 2, 2015

Is there a way of creating a log to capture changes in a table by users?

In a current database that I'm taking over, there was a lot of records deleted from the main table and now I need to figure out what happened.

So, if I would be able to have a log that records all the actions taken by users, I could at least see who did what.

View 13 Replies View Related

Users Want Ad Hoc Queries/reports

Jun 14, 2005

Hi,

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?

Thanks,

scratch

View 11 Replies View Related

Queries, Tables And Forms?

Mar 2, 2005

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?

View 14 Replies View Related

Prevent Users Accessing Queries

Oct 4, 2005

Hi,

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?

Thanks

View 2 Replies View Related

Interface To Allow Users To Create Ad-hoc Queries

Oct 20, 2005

Hi All

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.

Dave

View 3 Replies View Related

Users Can Access Database But No Queries Or Buttons

Mar 20, 2006

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:

"Connection Failed. Invalid connection string attribute."

View 4 Replies View Related

Queries :: Matching Users And Status In Query

Jun 19, 2015

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 have attached the database (2003 format) ....

View 2 Replies View Related

Problem Linking Forms To Tables / Queries

Jul 22, 2005

Hiii All.......

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??????

Thankz in Advance
daffodils

View 1 Replies View Related

Multiple Users Trying To Access Reports With Append Queries ::Please Help::

May 12, 2005

--------------------------------------------------------------------------------

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::

Thanks.

View 2 Replies View Related

Tables, Queries, Forms, Reports And Modules Have Disappeared

May 24, 2006

Good morning All.

I have a database which updates via a Function in a module every morning (i.e imports and exports data).

Yesterday the DB crashed and incurred a problem. The DB was closed down and re-opened.

When it was re-opened all the Tables, Queries, Forms, Reports and Modules were no longer showing in the DB window.

When I selected the Tables tab the following message appeared:

Operation Invalid Without Current Index

this was then followed by another message:

"Isn't an index in this table. Look in the indexes collection of the TableDef object to determine the valid index names

This also appears if I try selecting the other tabs i.e. Queries, Modules etc.

The strange thing is the DB still updates at its stipulated time, and still imports and exports data. I am running Access 97.

Does anybody have any idea of how I can sort this out?

Regards

Chathag :confused:

View 1 Replies View Related

Getting All Forms/queries/tables To Show Up Full Screen

Jul 5, 2007

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!

View 12 Replies View Related

Queries :: List Box Data Based On Logged In Users Department

Jan 4, 2014

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.

View 3 Replies View Related

Modules & VBA :: Automate Access 2007 Queries With Form For Users?

Oct 18, 2013

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.....

View 2 Replies View Related

General :: Naming Of Tables / Queries / Forms And Reports For Identification

Sep 22, 2013

Is there any systematic way of naming Tables, Queries, Forms, and Reports in order to identify easily which of them are connected to each other?

View 1 Replies View Related

Users Cannot Open Certain Forms

May 21, 2007

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.

View 2 Replies View Related

Multiple Users And Forms

Mar 17, 2008

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

View 8 Replies View Related

Question About: A Table Of Users Who Have Relationships To Other Users??

Feb 21, 2006

Hi,

I have a table of users somthing like this:

User_ID
Name
Hobby
Favorite_Food
Blah
Blah
Blah

Users can be friends with one another and I need some way of logging this.

My 2 options (that i can see) are:

1) Putting a friends entry in the main user table then comma delimiting the User_ID's in the friend entry like so:

User_ID: 001
Name: John
Hobby: Frizbee
Favorite_Food: Cake
Friends: 002,004,010

2) Making a seperate table with multiple entries for each user like so:

User: 001
Friend 002
---
User: 001
Friend: 004
---
User: 001
Friend: 010
---
User: 002
Friend: 001
---
User: 004
Friend: 001
---
User: 010
Friend: 001
---

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.

Thanks.

View 1 Replies View Related

Queries :: Form Setup - Allow Users To Select Parameters Using Combo Boxes

Apr 3, 2014

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...

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved