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 Replies
ADVERTISEMENT
Nov 3, 2005
Hello,
I am wondering if there is a way of preventing people from linking tables with a database i have that has a security logon?
In essence they would be able to run their own database with the information in my secure mdb without first logging in !!
Is there a way of preventing this? Any pointers or guidance would be most helpful
Cheers
View 2 Replies
View Related
Jul 25, 2007
I'm not sure if this is a Table question or a Form question...
After a user enters data into all the fields on my form (ticket #, date, time, etc) and submits that form, I want to prevent them from going back to that record (or any record, for that matter) and make a change to it. Currently, they can do a "Find" on a specific ticket # while in the form and make any kind of change they wanted. ie: change the time they reported to a work site...
Is there an easy way to prevent this from happening?
Thanks!
View 3 Replies
View Related
Dec 19, 2012
If I need to take the backend of my database offline for changes, what's the best/easiest way to inform the users? Is there some code I can drop into the front end? I'm thinking a "on database open, if [available] in tblClose equals no, then open frmDatabaseOffLine". But I don't know a) if that's possible or b) how to program it.
View 5 Replies
View Related
Feb 25, 2014
I have an access database which was created in 2003. I opened a blank database and imported the definition and data in access 2010 and made the file an accde file. Now this file has a lock symbol next to the access symbol. I am also unable to edit the main form.
View 7 Replies
View Related
Feb 13, 2008
In C# this combo box is calling "DropDownList".
How to make in in Access?
View 3 Replies
View Related
Apr 24, 2007
Hello,
I was wondering if there is any way of stopping people from seeing the tables that I have created and the relationships between said tables?
I want to restrict access so that users can only see the forms and access the reports that I've created but am not sure how to go about stopping people from seeing, never mind altering, the table names and structures. Can anyone help??
View 5 Replies
View Related
Jun 11, 2014
I have an Access 10 DB that includes 299 names and other associated data relevant to these names. I have a need to drop 249 of these names that are no longer needed in the DB, and just keep the 50 names that would remain in the table.
If I am in the table is there any way to somehow "designate" or select the 50 names I want to keep and then just mass delete the other 249 in one fell swoop? If I can somehow sort the 50 names so they would appear as the first 50 names in the table, then I could simply delete all the names below.
But not sure how to make this happen. It would seem to be the simplest solution. Unless I can physically drag and drop each of the 50 names I want to keep to the top of the table, but I don't think this is possible.
View 1 Replies
View Related
Oct 12, 2012
I am trying to modify an inventory management database. I want to prevent duplicate entries to specific fields in centralized table. The table is called Work Stations. Its function will be to track various computer equipment by a specific work station name. Each of the items will have a unique asset tag.
The primary Key for Work Stations is WS-ID. The fields I am trying to prevent duplicate entries in are WS-Computer, WS-Docking Station, WS-Monitor_1, WS-Monitor_2, and WS-Switch. Each of those fields are primary keys in 4 different tables that conation more detailed information about item. The exception is WS-monitor_1 and WS-Monitor_2 have a one-to-many relationship with Mon-Asset Tag in the monitors table.
The goal I am trying to accomplish is when a work station ID is created or modified duplicate entries are prevented to those fields listed above. The computer, monitors, docking station, and switch fields in the work station table may contain data or may be null.
I have tried to set the Indexed Option to Indexed (No duplicates) for each of the fields and I have also tried setting Yes to Ignore Nulls in the index option on the table design tab for the individual fields. Both options have returned the same error stating the changes would create duplicate values, in the index, primary key, or relationship.I have not created form for this table yet as I was trying to get no duplicates option to work first. I have verified the data and the only duplicating fields are the Null fields
View 6 Replies
View Related
May 15, 2005
I run a school library database (Access 2003) and want to set up a password logon system so that different users can get at different parts of the program - e.g. Administrator (everything), Librarian (can add and delete records but not change the database design), Student (can only access certain areas, read only).
I've tried using the security wizard to set this up, which seems OK until you then open the database again. I would expect to then get some sort of log-on screen next time I open the database, but instead it opens normally, but then won't let me do anything because I "don't have permission". I had to restore a back-up copy.
I must be missing something obvious here. Is there a place to look for instructions? Couldn't find anything useful in the help screens.
Richard
View 2 Replies
View Related
Mar 1, 2006
Is it possible to have 2 or more users adding records into the same table at the same time? They would not be editing, only data entry.
I am wondering if this would cause a problem for the auto numbering for the ID field.
View 2 Replies
View Related
Jan 19, 2005
so i'm using MS Access security features, .mdw file and all that jazz. i'd like to market my program, but i don't want to have to add/delete users and change/add/delete permissions for every new/existing user. is there any way around this via an unbound form in vba, ie, something like "New User Name: _______" "New User Password: _______" "New User Permissions Group: (dropdown)"? is this possible, or MUST you go through the security page?
thanks
View 11 Replies
View Related
Feb 27, 2008
Hello everyone.
I am looking for a little help getting a database created in access 2000 to open in access 2003. The creater of the database put security on it and I have the security doc. However, I do not know how to give permission to open the database in 2003.
Any help is appreciated!
View 3 Replies
View Related
Sep 11, 2013
I have created a database for 2/3 users (will progress to more once the system has been smoothed over) who will have the db.file open from 9-5 and will be consistently adding and changing data within 2/3 forms. Most of the time but not always a message comes up saying,
"You do not have exclusive access to this database at this time. Any changes you make may not be allowed to be saved later"
I can understand that it can create data corruption if multiple users are allowed to edit and modify the same data at the same time but surely a database can't be that limited. I thought that splitting the database into a front end on a local server and then a back end on my computer would solve the problem but everyone who is using the front-end still experiences the same problem.
How to be able to overcome issues with multiple users access the same forms and tables? Even when another user is editing one form and another is editing a different form the message will still appear.
View 9 Replies
View Related
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
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
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 1 Replies
View Related
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
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
Mar 13, 2014
I am new with Access and I am setting up a data base that will have 16 tables and each table with have over 3,000 customers. The reason for 16 tables is that we will be inputting information on a monthly basis for each of these customers (12 of the tables) and I also have 4 tables that will be perfomring different "tasks" for each customer (one is just to keep the notes we make for each customer, one will be to show any billing done, one is going to be a summary of the entire year along with some additioanl information not entered elsewhere and the final one is our customer information table).
The customer account number is the primary key for all of my tables.I want to know how I can add a new customer (either using query or form) at one time that will populate all the tables. Right now I have everything set up as tables but I can set up queries if need be.
View 14 Replies
View Related
Aug 19, 2015
I am using Access 2007 on my front-end and SQL Server 2014 on the back-end. I have a table of Car Dealers and a table of contacts at the dealerships. These tables are SQL tables. The user can select a dealer and then see everyone that works at that dealership. When they look at this there is a field called Email. This is a hyperlink that they can click on to open Outlook and send an email. The table called DealerEmails is an Access table. My table layout is:
Dbo_Dealers
------------------
ID (PK)
DealerName
DealerAddress
DealerCity
DealerState
DealerZip
DealerPhone
ModifiedBy
ModifiedDate
Dbo_DealerContact
---------------------------
ID (PK)
LastName
FirstName
Postion
DealerID (FK)
ModifiedBy
ModifiedDate
DealerEmails
-----------------
ID (PK)
DealerContactID (FK)
Email
ModifiedBy
ModifiedDate
Now I'm trying to write the code to add a new contact. My code works but I need to obtain the AutoNumber from When I add a new record to the table dbo_DealerContact. My code is:
Code:
Option Compare Database
Option Explicit
Dim adoDealerContacts As New ADODB.Recordset
Dim daoDealerEmails As DAO.Recordset
Private Sub cmdSave_Click()
[Code] ....
I tried to add Me.Dirty=False, but this still returned a value of 0 into my variable intDealerContactID.
I also tried moving intDealerContactID = .Fields("ID").Value outside of the With block.
I'm aware that there is a command in SQL @@Identity. But I'm unsure how to use it in this context.
Is there a way to get the primary key from dbo_DealerContacts so I can insert that into my Emails table?
View 2 Replies
View Related
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
Dec 20, 2005
I have a database that tracks staff training in a health trust. It's pretty simple, tb_staff, tb_courses_done which is 1:n and a tb_courses 1:n on the staff_id of tb_courses_done.
I want to know how to go about adding a table(s) that will allow me to book staff onto courses and track if they attended or not. At present it's 1 staff member has many courses so any courses entered are "done." I have a main form with staff details and it has a subform where I add completed courses.
Hope that's clear?
Thanks.
View 1 Replies
View Related
Mar 30, 2006
Hello Guys
This might sound like an easy qestion but i just cant do it, and need someones help!
I got two Access tables that are set out exactly the same, and im trying too add the figures in both tables together, too produce the results in another table.
Can anyone help me on how too do this
Thanks
Mark
View 2 Replies
View Related
Apr 25, 2005
Hello all,
Is it possible to add logos and headers to mdb tables. This is required because the tables are to be printed out and presented. The database itself is manipulated through java swing, so I would like the table to be ready to print out when opened. Any assistance is greatly appreciated.
Zengineer
View 1 Replies
View Related
Mar 9, 2005
Hi..I have three tables A ,B and C, which have fields A,B and C respectively.
I want to do that following default calulation
A.a=B.b+C.c
meaning adding two columns of different tables and storing it in a third column.
It works for me in the forms but I want to do that in the table.
Is there any way to go about it
Regards
Rahul
View 1 Replies
View Related
