I would really like to have a better understanding of the secrurity that comes with access. I would like my DAP to be able to log in with the previleges given for each user. I would also like these previledges to work when someones opens the database with access, however, whenever I set the secureity stuff, copy the database to the fileserver, I can then open it with another computer without any problems. Why is this? Thanks guys, I'n new here.
This is probably a really easy thing to do but I need to set up users and passwords to access a database that will contain sensitive information so cannot be accessible to everyone.
Can someone please tell me an easy step-by-step way on how to do this, with multiple users allowed to add and edit information (but not the workings of tables, queries etc)?
I am pretty much self taught so nothing too technical if possible!!
Also, the user's name needs to be input into an "Entered By" field in a form automatically depending on who has logged in when a new record is created.
I am getting ready to set up my database with users who will need to log on. I did a test on a sample database, but for some reason, my database became unavailable, and it never gave me a login box. Is there somewhere one could point me for some detailed info on setting up users and levels in MS Acess? All of the books I have on Access just kind of skim over the subject.
Secondly, in a select query, is there a way to assign a field that is part of a table a value. For instance, upon running the select query could I assign the field CurrentUser =user() ? If so, then how would I do this? I am using data access pages for data entry, and I want to be able to track the person who enters the record without them entering their username for every record they process, but, here is the drawback, they are not starting new records, they are merely adding to a record that someone else started.
Even assigning the value =user() on the data acess page field does not rectify this problem. This only works when you start a new record. I am really stuck on this one, and I know virtually nothing about SQL or Visual Basic..... the last time I programmed was in the 80's and I was a whiz at BASIC and PASCAL, lol. I know, I know, I need to get off my rear and start trying to pick up on this stuff. Anyway, I think the answer to my problem somehow lies in assigning the field the value =user() from the query, but I am stuck on how to accomplish this.
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?
I have a database of books that contains all the informations about the books in a library, and ofcourse the forms for accessing the database ie searching adding editing and all this, is it possible in access to make a restriction so that only the administrator can edit or add to the database and the other users can only search for books and print reports I know the logic of creating a password table and a form with a username and a password which checks if the user can access and then open the corresponding form (using isvisible property for the edit and add botton) but even if i did that the user in reality can see the tables and the forms of the database and can change them directly please if anyone has an idea?????? thanks
I have very nearly completed designing and making a database for stock control for my company, and am now a little concerned on how it is going to be implemented. It is going to be done over a network, with only a handful of users. The idea is to have every user log in but with each person having different permissions. i.e onl;y being able to access maybe one or two forms, but also having an administrator that can view every form. Now, i am aware of the security settings in the tools menu, would this be the appropriate way, or would i have to creat an empl;yee table and set permissions thropugh vb? This is the first database i have constructed and need a little help!
The second problem is that the database will be over a network. Would i have to put the backend in one place and then have the front end installed on all the pc s and just access the backend when i its needed? Forgive me if this sounds a bit stupid but as i have said this is new to me..
Is there a way in Access to logout users from a database in order to make updates without having to setup a FE/BE situation? My company is using Novell Client 4.90.0.0 SP1a. I have read some logs where you choose File --> Open (exclusive), but I do not have that option (using Access 2000). Any other thoughts?
Is Access set up to handle multiple people entering data into the same table?
We are processing returned mail and enter all the bad addresses into an Access table. The data is simply entered into the bare table. Can two people be doing this at once without the risk of compromising the data?
I have created a DB which has a front end which is linked to a backend where all my datas kept.
I want to install my database via cd-rom using and install wizard. If i ask the install wizard to c:/user/programs/ would i have any problems with the links between the front end and back end?
If i would how a problem with the links to the front end how would i cover come this?
I wonder if anyone could give me some advice on a problem i have with an access database.
I have designed a database and a data input form to collect data that is input by workers, the problem i have is that only one person can enter a record at a time.
I curently use 2 replicated database's on two seperate computers and run the synchronisation once one person has finished so that all the changes are replicated to the 2 different databases
If there is any other easier way to accomplish this i would be very greatful if anybody can shed some light on the subject.
I am having a problem that I have never encountered before and thought I start here. Using Access 2003 I have a database that resides on a main computer and my users connect via the network to this database. On my forms I have command buttons that run simple macros to copy and paste data from one field into another. The macro contains a GOTOCONTROL, to copy the contents and then moves to the next field. Then I have SEND KEYS command and wait is set to yes, then PASTE. When they press the command button it seems like the SENDKEYS is not waiting then the macro halts becuse it is saying the COPY command is not available. This happens to all users except for one. That other user is also connected to the database via the network. I checked the OPTION for all the computers that are connected and they all match to the one computer that works. The one computer that does work is the one that was used to write the database but the databse is now on another computer that is always on. The funny thing is that if I were to change any option under Forms/Reports, the macro's will work for a while then stop. I did do a compact and repair several times but this has no effect. Sorry for rambling but I am just frustrated because this databse worked fine at another account of mine and I just can't figure out why this is happening. Thanks in advance for your reply.
I now haw 2 laptops that work and 2 desktops and 1 laptop that don't.
I have a small database for doing some tracking and some reporting. I want to be able to allow everyone to view the data and also to print reports. However, I also need to limit who is able to enter data into this application.
I don't want to build a login form for the application...I want to be able to limit users based on their Windows Login name, which I would have in a table. The first thing I would do is compare their Windows login name against the table, and then put in code such as "If table name = suchandsuch then you can't do suchandsuch, but if tablename = blahblah then you can do something."
Is something like this doable? If so, how might I go about getting started with this train of thought?
Thanks to any and all who respond..... I appreciate your time and knowledge!!
I have a database set up that utilizes the user level security offered by Access. So basically everyone logs into the database, entering their user name and password.
Is there a way that I can log the currentuser() to a table when they sign in? And is it possible to assign a time stamp as well?
The database: is for tracking computer issues (this part is complete), also I need to show the on call roster (mostly complete)... This will also have a time sheet that I need to be completed once a fortnight, however I would like it to auto populate the staff members logged information (I will get into that a little later).
Question 1: I do not want the users to log into the database, however I do want the database recognise who they are from their windows logon details.
I created a database and a form on it that i enter myself right now. I am planning on using this database on several PCs with different users. Currently I have this database on the network, but when multiple people try to access it at the same time they cannot access without saving a separate copy or just having read access.
I need to put my Database to work with multiple users.
1- I already have divide the database; 2- I already have made the file accde of the front-end file; 3- I already have put the two files: back-end and front-end on the network server.
My problem now is that if I open a Form to register data the other User can't open the same form to add data. What I must do to work in the same form with multiple user?
I have my database on a server and i want 2 or more users to access that database from different stations at the same time. I am using MS Access 2010, what do i need to do and how do i do it to allow more than one person on my database? The database contains 2 tables - table 1 has 1,450,00 records - table 2 will be populated with some of the records from table 1.Table 2 is empty.3 sub-forms - 1 main form and 1 report (for labels).
Both tables have the same fields, but not all the fields are filled in and each user will be filling in the fields required.Each record is a case, and no more than one user will be assigned to a case.I need at least 2 users working on my database at the same time, i would like to have 4 users working on this database if possible.
I have two databases that have been split, and both back ends are in a shared folder on the server that only a few people have authorization to access. One of the front ends is accessed off another shared folder, and the other is saved to each person's desktop. They have been up and running for months, and I've had no problems with users not being able to access data from the back end.
The other day, I requested access to this protected folder for four people, which was granted. But, since the time it was granted, neither database will open unless the user has authorization to access the protected folder. They get an error that says the database is already opened exclusively or they don't have authorization to view its data.
I've created another test db and split it into the same folder, but my users are getting the same error.
Any help you can provide would be much appreciated.
I have developed a new database using Access 2003, which I need to roll out across various users. Some have XP, some Windows 7, and each of them has different size screens. I guess I will have to adjust the various forms to size to a particular users screen resolutions and sizes.
Is there any way of doing this within the database itself, or do I have have to adjust each form according to the local users PC specification?
I used to have a handy tool called LDB Viewer or something like that with which I could see who is using my database. Now I've upgraded to MS 2010 is there a way to do the same?
I'm an absolute novice at Access. I have a very simple (yet sufficient) database that lists our company's projects, tasks associated with those projects and when to invoice.
Our company consists of myself and my business partner. We both work from our (separate) homes. Our project files are stored in the cloud. This works well. We have investigated a server in the past, but found it to be cost-prohibitive and unnecessary for our business.
Is there a way that my business partner can have the Access database running at the same time as me, and make additions/modifications? I don't know how this would work in terms of updating/saving.
I am about to allow users to access a database I redesigned for others to use.I am trying to save it as an ACCDE so they can't mess it up. The database is very very simple.6 tables each with only 4 fields or less... and none are related to one another
7 forms. 1 report. 0 queries... it's just a SKU generator.
When I attempt to save as ACCDE I get an error that reads."Microsoft Access was unable to create the .accde, .mde, or .ade file.This error is usually associated with compiling a large database into an MDE file.* Because of the method used to compile the database, a considerable number of TableID references are created for each table.* The Access database engine can only create a maximum of 2048 open TableIDs at one time.* Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE.* However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used."
This morning I accidently ran the "User-Level security wizard" on a secure database that we use. I meant to add a member but clicked the wrong thing and followed suite by hitting "Finish" instead of cancel because I wasn't paying attention. Aside from creating a "Security.mdw" file which isn't being used at all, it also somehow managed to lock everyone but the administrator out.
I checked the Users/Groups and Permissions, they are all there and correct, nothing seems to have been changed at all but when anyone tries to log in now they get the following error:"You do not have the necessary permissions to use the '...mdb' object. Have your system administrator or the person who created this object establish the appropriate permissions for you."
I've read some posts with similarish issues that recommended recreating the .mdw file and importing the data over. The file is encrypted so I wasn't able to do that but I did try making a copy and renaming it then changing the path in the Access shortcut to the copy instead. What all files/settings handle this and if the Users/Groups show up correctly in the database, what could be preventing the users from getting in?
I am creating an Action Item Database that will be located on a Sharepoint portal so multiple users can access and I'd like each user to have a login/ password to
1) keep unauthorized users out of the database and 2) limit what users can see.
This login/ security should ideally work so that user "Bob Smith" logs in with his assigned login/ password and he will only view/edit/ run reports for those Action Items that he has generated (field named "GeneratedBy") or have been assigned to complete ("ResponsibleLead") which are both fields in table "tbl_ActionItems". I can not tie the security levels to a users network login; this has to be security within the database. I don't necessarily need specific code at this point so much as I need a logical starting point for setting this up.
