General :: Permissions Not Saving

Jul 10, 2014

I have created 10 User Group Accounts, and have set Permissions for the first 7 successfully. However, no Permission settings are being saved for any subsequent Groups. (Access 2010 managing a 2003 mdb file, Front and Back client)

After having experimented a little, I found that while Access allows you to create a Group name with 20 characters, any Group with 20 characters in the name does not save Permissions.19 Characters seems to be the maximum characters a Group can actually be named with.

View Replies


ADVERTISEMENT

General :: Admin Has No Permissions At All

Jul 16, 2013

Now there is only one set of permissions Admin, and Admin has no permissions at all. When I try to check admin rights or even read rights back to the Admin it says I need to be logged in as admin, which I am.

Is there anyway at all I can either copy some information from 2 tables and put it in my back up?? I'm really stuck here and need to fix this or I'll have lost considerable amounts of work.

View 5 Replies View Related

General :: Do Not Have Necessary Permissions - Just Appeared On A Working DB

Jan 6, 2014

I'm running Access 2010 but using an .mdb to maintain user level security.I've rolled out a new version of the DB for 2014 (don't ask, but it is necessary) linked to the same security file as the 2013 version, which works fine. With the exception of some new fields and a bit of re-wiring the two are very similar. User permissions have stayed the same, all users are connected to the same security file and have access to almost all the functions they should.

The odd thing is that there are only 3 report buttons (so far) that flag the permissions error for all 'Update Data Users'. Everything else seems to be working fine. I should add that the buttons trigger macros but I don't think that's a problem since they work fine on the 2013 version.

I've tried re-linking the security file but that makes no difference - the path was correct. I don't understand why this is specific tho these buttons since other Macro'd button are working fine.

View 3 Replies View Related

General :: Creating Separate User Permissions Without VBA?

Aug 19, 2014

The problem is I need it to be only editable by 1 user, but allowing multiple other users to access it and view the records- just not able to add/edit/delete them.

The other question I had about the Split database would be- Does having a split database mean the data needs to be updated in 2 tables or am I taking Splitting databases too literally?

View 14 Replies View Related

General :: Database Security / User Permissions?

Nov 6, 2014

I have some Databases that were created back in Access 97 and have managed to upgrade these databases to work in Access 2013, fixing any modules and forms which broke when upgrading the databases.User access and permissions within the database were controlled by User Level Security (the Workgroup.mdw file) which is not secure anyway I guess, as someone could easily copy the entire database.

The database as it stands now works perfectly in Access 2013, however anyone can do anything with the database which is my main issue. Im wanting to limit access for certain forms / tables / reports to certain users, then out right deny other users from accessing the database.

Ive seen the SQL Server 2014 Migration Assistant for Access, which looks to store the tables on SQL server then map these to the Access database, so i guess i could deny certain users from accessing tables that way, or only allow them to read the tables. However I'm not sure how that would lock them out of certain forms / reports and queries in the databases?

View 2 Replies View Related

General :: Permissions Broken Moving From 2003 To 2010?

Sep 27, 2013

I have been asked to look into fixing a permissions problem with a database. The company has been in the process of updating the OS on our computers.

The database in question is stored on a shared network drive. It opens fine on a windows XP machine running Access 2003 but when the same user tries to open the database from windows 7 using access 2010, the message: "You do not have the necessary permissions to use the '<file path>' object. Have your system administrator or the person who created this object establish the appropriate permissions for you."

View 3 Replies View Related

General :: Custom Security Permissions For Employee Database

Nov 28, 2012

I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?

View 1 Replies View Related

General :: Possible To Create Custom Security Permissions In Access

Nov 27, 2012

I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?

View 1 Replies View Related

Database Permissions (NTFS Permissions, Really)

Aug 13, 2007

Can anyone tell me what the ideal NTFS persmissions should be for users who are only inputting data to an Access database?

Would Read, Write, & Execute on the networked folder where the BE resides be enough for the users to update the database?

Thanks!
Michael

View 2 Replies View Related

General :: Users And Permissions Missing Reading MDB File In A2010

Nov 22, 2013

I have been using a A2003 file through A2007 to be able to use user security.We are now in A2010 and the users and permissions component is not showing in the Administrator area as it did in A2007, although the security is still functioning. How do I get access to Users and Permissions in A2010?

View 1 Replies View Related

General :: Security And User Read / Write Permissions - Access 2010

Jul 19, 2013

I'm a SQL Server DBA and have a few Access 2010 Db's to look after and occasionally have to make amendments to (as is the case today). I've been asked to apply permissions to certain users of the Access database whereby users in a group we're calling 'Viewer' only have read permission and users in another group called 'Writer' (original I know!) have both read and write permission.

The database is form driven (i.e. no-one directly accesses and amends the tables in the database), the file is saved with a .mdb extension.

I've played around with the 'Manage Users & Permissions' in the File Menu however these don't seem to do what I need them to and only result in having to input a user and password to access the database on start-up.

View 1 Replies View Related

General :: Checkboxes Not Saving To Table

Oct 20, 2013

I am writing a program in Access 2010. My check boxes are not saving to the table. I have stepped through the code with no errors and it only saves the last check box to the table. Here is my code:

Private Sub cmdSave_Click()
On Error GoTo cmdSave_Click_Error

Dim rs As Object
Dim db As Object

Set db = CurrentDb
Set rs = db.OpenRecordset("tblUserPermissions")

[Code] .....

I attached the full code.

View 14 Replies View Related

General :: Saving Records In Alternative DB?

Jul 6, 2012

I have a stock db with records that go back to 2006. I want to clear some of the old records but save them incase required. I still need to leave from 2010 until present on the db. I have a front and back end on the db.

View 1 Replies View Related

General :: Saving Information From Form To A Different Table?

Nov 26, 2012

I have created a form and a subform within it, I have managed to populate all the dropdown boxes from the tables I need. but I need to save all the information in putted to a table called bookingstbl and I do not know where to begin?

View 6 Replies View Related

General :: Modifying Record And Saving In New Location?

Dec 4, 2013

I'm working on a database that will be used by two different groups. Group A provides a list of items to be investigated by Group B.

I'm wondering if it is possible to:

i) have Group A create an excel file of items to be investigated (let's call the file tblNEW)

ii) open a record in the file through a form (let's call the form frmINPUT) to allow Group B to input investigation findings

iii) save the modified record into a separate table of all the work that has been done (let's call this table tblWORK)

iv) delete the investigated record in tblNEW once it gets saved into tblWORK

View 1 Replies View Related

General :: Saving Records And Empty Comboboxes

Sep 16, 2014

I have a database that I've created for a number of clerks under me to use to track their daily tasks.

When clerks are entering their tasks, they do so through a number of combo boxes on a form (Assigned by:, Division of Law:, Subcategory:, Casename etc). When all of the combo boxes have been filled, the employee can click a button in order to save the record to the back end of the database and open a new blank record.

Currently, if an employee tries to enter the wrong data in a combo box and save the record, they will be prompted to enter data and not allowed to save the record; the problem is that if they leave all fields blank they can still save the record - thus creating useless data for reporting purposes. For example, an employee could enter their name and the date of record but leave every other combo box blank and still save the record. I want to lock the form such that they cannot save the record unless all of the combo boxes on the form are populated to reduce user error.

How can I do this simply?

View 13 Replies View Related

General :: Saving User Defined Variables

Sep 16, 2012

I have a database that creates many forms based on queries which are based on user-defined variables. These are permanent variables added directly in the query, such as "if an employee is late 4 times in a month, we yell at them." I would like to be able to change this to "5 times in a month" if the users want to.

Rather than waiting for that to happen and having to change all my queries, i want to set up a form for them to access and edit the variable, save it, and then my queries to reference that variable.

My question is what is the best way to store and reference them? I could create a table, but i am not too sure how easy it would be to make my queries work with that.

I could also add them onto my main form which is always open, but I'm not sure how to make them save when access is closed. (a quick trial from my variable form won't let me update either a text box or label value on the main form).

View 5 Replies View Related

General :: Saving PDF - Testing To See If Directory Exists

May 31, 2013

I'm starting to automatically save PDF copies of certain reports in predetermined locations. I need to copy a file to a particular directory (based upon various criteria), but if the directory does not exist, I want to create the directory on the fly first. Otherwise I will just proceed with the copy.

I'm sure there is a DOS command to do this, but I can't find it.

View 5 Replies View Related

General :: How To Disable Textbox After Saving Data

May 6, 2014

I have some field in my details section,It works like a grid view,if I search data by query then It shows all of the related data from database,then I edit or save data one by one,but the problem is I want to disable text box after edit/save data.But if I write code like--

If Me.Text103 > "" Then
Me.Text103.Enabled= False
Else
Me.Text103.Enabled= True
End If

It disable the all of the rows,but I want to disable only the specific field where I enter the data.

View 4 Replies View Related

General :: Subtotal On Subform Saving To Table

Jul 17, 2013

find the attached MS access DB for INVOICE printing . I am facing two issues there .

1. {form INVOICE } sub-total must be Calculated from line total on {INVOICE DATA Subform} , I know this can be accomplished by adding a new field at sub-form and calling that value to main form's sub-total field .

2. And the real issue is i want to save this value from subtotal on form INVOICE to table field name subtotal .

3.I wish to make a reporting format for each INVOICE NUMBER , whenever report is being generated , the report shows more than 1 invoice details .

View 2 Replies View Related

General :: Saving Multiple Checkboxes To Table

Oct 16, 2013

I created a Microsoft Access database and access to the system must be controlled by User Access Level Control. The level of the user determines whether the user can add, edit, delete or view a certain form.

I created three tables which are linked via foreign keys: tblUsers, tblUserRoles and tblPermissions. (See the Tables attachment)

I designed the Permissions form to be user friendly by adding checkboxes on the form so that the Administrator can select whether a new user has Add, Edit, Delete or View rights. (See the User Level attachment)

To test my code I added a user as an Administrator. The problem is that when I select the Add, Edit, Delete and View checkboxes, it only saves the last checkbox to the Permissions table. The Administrator must have Add, Edit, Delete or View privileges on the Employees form, but now he only has View privileges. My code does not generate an error. (See the Incorrect attachment)

The Permissions table is suppose to save four entries(See the Correct attachment)

Here is my code.

Private Sub cmdSave_Click()
Dim rstPermissions As Object
Dim dbFSManagement As Object
Set dbFSManagement = CurrentDb
Set rstPermissions = New ADODB.recordSet

[Code] .....

View 14 Replies View Related

General :: Lock Individual Records After Saving

May 4, 2014

I have 4 users all with the same rights. What I want to do is lock each individual record created by each user from the other 3 users after they have been saved ( I am not referring to record locking/table locking while updating/creating ). i.e., They can all read each others created records BUT only update/modify their own created records. They all have individual passwords to log in.

View 4 Replies View Related

General :: Saving Database As Backup With Different Date

Nov 7, 2012

I'd like to have a button on my dashboard that gives the user the ability to back up the database and save it with a different date. For example, existing database called "Fishing.accdb" and I'd like to have code behind a button that allows the database to be saved as "Fishing0711.accdb"

I'm trying to avoid the user having to go into the File Save as menu system....I've tried the docmd.copyObject method but can't get it to work

View 10 Replies View Related

General :: Lock Down Application By Saving As ACCDE File

Sep 29, 2012

Trying to lock down an application by saving as ACCDE file. Saves OK but when you load application none of the controls work. I.e. button clicks do not launch "Open Form" or " Print Report" commands.But in ACCDB format application works flawlessly.

When I tried on a different machine I get an error message that says too many Table IDs. Odd since I only have 3 forms, 3 tables and 3 reports. Lots of DoCmd's and switching between the 3 forms but not sure why this would create "too many Table IDs"?

View 2 Replies View Related

General :: Split Form And Subform Columns Not Saving

Oct 25, 2013

For some reason when I change the order around of the columns in a split form or subform 90% of the time it wont save (right click save, file save, etc..) and have to constantly redo it until it finally works. Am I missing something obvious as to why this is happening?

View 3 Replies View Related

General :: Saving Links - Combobox Not Lose Data?

Jul 31, 2012

I'm saving links to a combobox in a form, but each time I close out of the form and reopen it the Combobox doesn't keep the list of data I entered before and only keeps the last selected one in its drop down menu.

Is there a way to make the Combobox store/keep the data?

View 14 Replies View Related







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