How To Create Users And Permission In MS Access 2010

Apr 29, 2013

how to add security features into My Access database. i.e create users with permissions/login.

View Replies


Forms :: Access Permission On Tabs For Some Users

Jul 23, 2013

I have a form with several tabs and I don't want to give permission for some users on some tabs. How can I do it?

View 2 Replies View Related

Access 2010 Database - Multi Users - Same Record Prevention

Jan 12, 2013

I am the administrator for a 2010 Access Client Database that consists of many clients with their information and we have three users whom go in and edit-add information to this Database and it hasn't been a problem until two users have tried to edit the same client record at the same time and then we have had some issues...

So, not sure this is even possible, but can one prevent more than one user being on the same client record? Is there a way to have a message come and say this record is in use?

View 1 Replies View Related

Modules & VBA :: Create Emails And Manage Replies In Access 2010

Jan 25, 2015

I found the below link that looks great and works.

[URL] ....

Te only thing is that I don't have much control over it and would like to build something similar as we also need to work with access 2003 (still )Any way to find how the code works (if there is some of it hidden in access)?

View 6 Replies View Related

Access 2010 Hanging During Create Table Query Or Export?

Jun 7, 2013

I am trying to work with Access 2010 to do some pretty simple stuff. I have two tables, one with around 500k rows, the other with around 150k rows. There aren't too many columns, less or around 20 for each table.

I am just trying to do a simple inner join and then create a table but every single time I do it gets about 20% done on the status bar in the bottom right and just hangs. The query itself takes no time to run but it can't create it as a table. Same thing happens if I try to export the query.

View 2 Replies View Related

General :: Create Multi-select List Box For All Records In Access 2010 Form?

Jun 3, 2013

I would like to create a multi-select list box for all the records in an access 2010 form.

View 2 Replies View Related

Access Permission

Jan 17, 2007

Hi there

Can i set permission on a single button in a access database form for specific number of users. And rest of the database is available for everybody ?


View 2 Replies View Related

General :: How To Use Automation To Run Word 2010 Mail Merge From Access 2010

Nov 26, 2013

I have a MS Access 2010 application when the User opens form CONTACTS Form

◦User finds single record to be used CONTACTID is identifier to be used for selection
◦User clicks button to open form frm_MAIL_MERGE
◦Frm_MAIL_MERGE has a drop down combo box that reads the folder location where the application resides and displays all .DOTM files (that is all template files) and one more combo box which contains the CONTACTID.
◦User selects single .dotm file for merge
◦Frm_MAIL_MERGE has either drop down to select CONTACTID or UNBOUND data field for user to type in CONTACTID number
◦User enters CONTACTID to be used for the mail merge
◦User selects SUBMIT
◦Application merges selected .dotm file with the information in table CONTACTS for the selected CONTACTID
◦Merged document is saved on the user Desktop as xxx.docx

View 10 Replies View Related

General :: Possible To Have Value In Excel 2010 Cell Used To Update Access 2010 Database

Apr 4, 2013

Is it possible to have a value in an excel 2010 cell be used to update an access 2010 db?

For example, if in a spreadsheet "test" cell A2=3 then in a db "test" a column "value" is 3. However, if the value in the spreadsheet changes so does the db.

View 1 Replies View Related

General :: Calendar Synchronization - Access 2010 To Outlook 2010

Mar 23, 2015

I wish to work in Access 2010 with a subset of my Outlook 2010 contacts (all desktop- no network barriers), so I am exploring the Desktop Contacts DB found in Microsoft's templates. It passes contact data back and forth using the standard macros, but I wish to add more fields from Outlook. It seems I need to find the code associated with the macro. I believe I can solve the problem using a Linked table, but am wondering if there is another solution?

Calendar synchronization is another issue. Linking gets me to the Archive Calendars, but not the Current one in Outlook which is what I want.

View 2 Replies View Related

Access 200 Permission Lockup

Feb 20, 2008

Either when copying from one db to another on my machine or running a db produced on that machine on a network, I get the message "the database has been placed in a state by user (my machine is called "Rat") that prevents it from being opened or locked". =Error 3734.
The security data says I am "Admin" and permission is set for Admin and Users. It has been doing this intermittently for a while and now does it all the time.
Follow up data
All databases are created, revised and run on home machine (Rat) and run on the office network.

The offending DB will permit internal design, editing , copying and will accept pasting IN of tables etc. from other DBs. But it will not allow copying OUT of files such as a table to other DBs even on the machine that created them. However it will allow copying and pasting of objects such as forms in visual form or individual query cells to other DBs.

Ive carefully compared the Tools/Security/User & Group Permissions with a good running version of the DB and can see no difference.
Permission settings on good and bad DBs are:-
Permissions: Admin Object: Current DB
Checked: Open/Run, Open Exclusive, Administer.
Ive also checked each individual files Permissions. The .ldb file, viewed with Word with the offending DB running on my office machine (Weasil), reads:-
WEASIL_ Admin_

The creating machine Rat uses the Account Richard: but I have had few similar problems before. While revising the DB, I made 30 copies of at each stage along the way but saved carefully each design change and certainly did not deboot the computer without doing so.

Ive tried the above procedure on my computer (Weasil) at the office, but got the same result. So its not the computers or MS Access 2000 program. Somewhere along the line, perhaps, the DB got corrupted. It Repaired and Compacted OK but still has the problem.

View 4 Replies View Related

Why Those Permission Differences Btw Access Files ??

Sep 1, 2005

Hi accessors,

I have 1 permissions related Q.

If I create msaccess db by calling the app through its icon, i get a db with following permission items :


but if I create it through rightclick> new> ms_office_access_application, I get a db with:

VS Developers(compNameVS Developers)

Why /the hell/ those differences btw the same kind of files ? :mad:


View 3 Replies View Related

Column Permission In Access Table

Jan 4, 2005


I have a table in Access database. I would like to set read only permissions to some of the fields/columns in the table. I do not want user to alter or edit some fields/columns in a table. Could someone give a solution for this?

thanks in adavance


View 2 Replies View Related

Access 2003 Security Permission Problem

Oct 19, 2006

I have a database, which contains linked tables to another database. The information held in the tables are mostly open for every permitted user but some of the table informations are restricted to a few user only. To manage all of this different permissions I created a workgroup, changed all the necessary things to become an administrator and run the security wizard to secure my database. Finally I want to give every single group the access it belongs to. And there is my problem.
I have a form which has a VBA code underlying which selects data from a table and two queries and where the user can set individual criterias. For me as an admin user this form works perfect. When I log on as a user I can't find out how to set the permissions not to receive the error message: "You do not have the necessary permission to use the 'MSys Table' object...." The user should not be an admin user and I already set the modify, update, delete, read, read design permission to the group. Nothing helps.
Please if anybody has an idea what I can try I really would appreaciate this help!
Thanks very much :)

View 1 Replies View Related

How To Create Users In Form

Apr 21, 2005

hey guys,

i just needed a guide on how to create a form with different users in it.

also, is there a way in which i can create a button that will open the wizard to create a report ??

[guess wat, no deadline.... but that doesn't mean dont answer ;) ]

hope a reply soon..

thanks in advance.

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


View 3 Replies View Related

Forms :: How To Create Custom Menu Options In 2010

Sep 15, 2014

How to create custom menus in Forms in MS ACcess 2010. For example, I have a form fmrMainMenu. At the top of the form I want to create a menu labelled "Reports" that when clicked or hovered it displays a list of sub-menu options of all the Reports available in the database. Once the user makes a selection the report is generated. The functionality that I am looking for is similar to the old menu options like File, Edit, etc., in MS Office.

View 3 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

Forms :: Capture Users That Create And Edit The Records

Aug 27, 2013

What is the best way to capture the users that modify the records in the database?

Let us start from User Log-in Form After log-in, Main Form will open The main form has various menu (example Add Customer) Once I open the "Add Customer Form", I want to record the username in the Createdby/Editedby Field automatically.

View 5 Replies View Related

Forms :: Create A Form Which Allow Specific Users To Book A Seat At Football Match

Apr 4, 2014

I'm currently trying to create a form which allows the specific users to book a seat at a football match.

I've created all the relevant tables, but I'm struggling on how to interpret the data into them to make the form work. I am new to this sort of design, this design is currently for my university dissertation and I am struggling to get it completed in time.

I have attached my document below to show how far i have come.

View 1 Replies View Related

Forms :: Multi Select Listbox Access 2003 Code Gives Syntax Error In MS Access 2010

Oct 24, 2013

I've been using the following code successfully in Access 2003 & now I need to migrate to Access 2010. The purpose of the code is to use the items that the user selects in the list box to build the criteria of a query. Access 2010 keeps giving me a syntax error when I try to run the query & I don't know why:

My code is:

On Error GoTo Err_Command151_Click

' Declare variables
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As Variant
Dim strCriteria As String
Dim strSQL As String

[Code] .....

The syntax error I get in Access 2010 is:

Syntax Error in query expression 'SELECT * FROM
qryContractListSummarybyDateContract3TYPEBREAK WHERE
qryContractListSummarybyDateContract3TYPEBREAK.Rep ortableName IN('Adbri
Masonry NSW');'

View 12 Replies View Related

General :: Access 2010 And Access 2003 On Same Desktop?

Mar 5, 2013

is there a way to have both Access 2010 and 2003 exist peacefully on the same desktop. My company uses Office 2010, but my department has an Access 2003 application. As a result, I have to have A2003 on my desktop and use it quite frequently for this one application.

I have some small databases that I really want to move onto A2010 so we can take advantage of SharePoint functions, etc. Is there anytning I can do to be sure that the .mdb and .mde open in A2003 and the new .accdb opens in A2010, without getting errors and the Windows installer going through the Office installation process for the respective version? I've gone to the file locations and set the "Open with" setting to the respective version.

View 4 Replies View Related

Access 2010 - Restricting User Access

Oct 15, 2015

I have Access 2010 database.

I have a Reporting Dashboard form that inturn has many buttons to open up different reports and forms.

Now I have been asked to extend the access to a few other users with restricted access. The new users cannot see all the form and report buttons in the Reporting dashboard form.

How can i restrict this? They also need to be given separate logins and passwords. How I can accomplish this?

View 2 Replies View Related

Use Or Operator In Access 2010?

Sep 6, 2012

Can I use the or operator in Access 2010

IIf(Mid([WBCode],4,1)="D" or "N"....

I am finding that I can use AND and LIKE, but not seeing the OR

View 1 Replies View Related

Allow End Users To Access QBE?

Aug 30, 2006

I searched and doesn't seem to find anything about that question.

I am aware that there are forms that help with building dynamic queries for end users who need to juggle their data, but wondered if allowing them to access QBE would make everything easier (why reinvent the wheel?), and whether it is possible to restrict QBE from doing action queries or using dynaset to restrict end users from updating via queries which may circumvent the rules written in forms for the given data.

Have anyone had designed database with users having access to QBE? If not, how do you provide as much functionality without practically having to re-invent the wheel?


View 3 Replies View Related

Forms :: Access 2010 - No RTF For Textbox

Jun 12, 2014

I am using Access 2010 and have a form based upon a query (qry_student). In tihs query I have a field called Details that contains the student's address; a composite of the relevant fields from the table tbl_student. I have used chr(13) & chr(10) to create linebreaks wihtin the query field.

I have a textbox where the Control Source is set to this field of the query.

The textbox does not display the data correct and I believe this is because it is in Plain Text mode.

When I try to change it to Rich Text I get an error message.

If I remove the control source then I can change it to Rich Text but then this negates the very purpose of the textbox.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved