Accessability/Security In A Multi-user Env.
Aug 20, 2005
I need to implement some type of security on my database to limit the forms/reports users can access. When implemented it will be a split database on a network. I'd like to set it up so only certain users can edit/add data on certain forms. Also I want to have more than one user be able to edit/add data at the same time. I'm confused as what I need to do to set up this type of security. I found another post on this forum by Oldsoftboss (Dave) that gave a good, working example of a database with user login screens and different user security levels. My questions are:
1. Can I use his system in place of the built-in Access security?
2 . Do I need to implement both? If I don't use or change the access rights in
Access security, won't everybody be logging in with "Admin" rights?
3. What do I need to do to let multiple users work in the database at the same
time? I've already changed the database to "shared".
4. I don't want the users being able to change the forms, queries or reports
so I'm distributing an MDE file. Is there anything else I need to do so
users can't access the "design" button?
Needless to say, this whole security thing confuses me. Any help would be appreciated.
Rod
View Replies
ADVERTISEMENT
Jul 17, 2006
Hate to throw this issue back in the mix, but I seem to be really struggling to find a solution, even after extensive searching through posts. I can't seem to pin down any existing posts that directly addresses my problem, so here it is:
I have a DB that needs to be accessed by no fewer than 9 users for data entry and retrieval, no designing or programming. I seem to be running into a multiple user problem revolving around exclusive opening of some sort.
As it stands, about 4 users can open the DB simultaneously without issues. But as soon as a 5th person tries to open, they get an error saying they do not have exclusive rights, and the other 4 members run into problems closing their opened forms or tables with a "cannot save due to another user already has it open" and an error loop. Then, no one can close because of the auto save function in access.
I believe this may have something to do with workgroups, and have searched the forum with this keyword, but I'm not sure if this is where I need to go. I also don't know how to set it up from start to finish. Do I need to do something on each user's individual computer to make it work? And once I have one set up, will this absolve my current multi-user issues by specifying a shared access at all times?
Please help, as I'm getting a bit tangled up in the steps of this process. Is there a different solution? Thanks for any advice you can offer.
View 14 Replies
View Related
May 23, 2007
Okay, wonderful gurus! I'm getting ready to split a db and I'm seeking advice or counsel from you. I know how to do this, but want to make sure no one out there has some mystical secret to reveal. What do you think I need to know before I do it? Assume that I've done this before and am looking for little "good to knows".
One MAJOR question I have is concerning the security involvement. I am going to assign a workgroup (security settings) to the db, and I'm wondering how to make sure that both ends are usable with security after the split. I know this is confusing, but I know how smart you all are and I'm hoping you know what I mean.
THANK YOU, THANK YOU, THANK YOU!!!!!
KellyJo
View 6 Replies
View Related
Aug 4, 2007
Hi guys,
I've seen different log in forms and tips on multi-user use but can't seem to find info on the following...
We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer...
Best ideas anyone?
dazza61
View 6 Replies
View Related
Apr 24, 2013
I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .
All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.
View 1 Replies
View Related
Oct 15, 2005
I want to distribute an app that provides password access for a 6 month period after which time a new password has to be issued by me to the end user for them to continue. This means that I don't lose control of the programme.
Is this possible or are then other ideas to protect the app - I have looked at upsizing to MySQL but it is way beyond me, also I have looked at splitting the app and putting the back end on FTP - but apparently this doesn't work (albeit a good idea as I don't need any other programming skills). Any solution needs to be fairly simple please.
View 5 Replies
View Related
Mar 2, 2007
I have read a lot about if multiple users want to share an MDB, they have to create BE and FE and split the database.
I understand having to do that if all those users want to write to the MDB simultaneously.
I have a situation where one person will do data entry (write access), and two other users will just want to view and perhaps just search the database (read).
If only one person is writing at any time, do I have to do all that splitting and FE/BE configuration?
View 2 Replies
View Related
Apr 17, 2007
I've create a form with subform that work like a charm, now they want in a multi user environment. What is the best way to achive this?
View 6 Replies
View Related
Sep 1, 2005
I plan to create a multi-user application on access 2000. There would be more than 20 users simultaneously logging in the database. The database would be kept in Server with high config. The users would work on the database (server) from their workstations. Forms/Queries/Reports ... are in the workstation (client). The database may growup to 70 MB every 3 months. The application will run on the database for 3 months which will be replaced with a new one after that period. Is it a good plan to do so on Access 2000. Am worried about the network traffic. Will the users face it as a very slow application ???
(SysConfig workstation: Win2K Pro/ 128 MB RAM/ 40GB HDD/Pentium-4)
Any suggestion is appreciated. Thanx in advance.
Prodigy.
View 2 Replies
View Related
Sep 5, 2005
Hi
If I want several users to access a database from their network pc's, should I place the access database .mdb file on the server and set the Sharing properties, then install the access application on each of their stations.
They need to each be able to use the database when they need to and read or add data, reports etc.
I am using access 2003.
Thanks
Dave
View 14 Replies
View Related
Mar 10, 2006
I maintain a database that is used by several people in my office. Only about 4 different people actually use the database but I would like the database to have multi-user support. As of right now the tables, forms, modules, etc. are all in a single mdb file. Can someone recommend a method for making this database accessible to several users at once? My main concerns are accuracy (changes commiting in the proper order) and low chance of corruption.
View 1 Replies
View Related
Feb 7, 2007
Hey everyone,
I am in desperate need of your help. I have a split database that I am trying to enable multi users access to the database. I created a folder on the share drive with the front end and a folder on share (BEN) with the backend. I have changed the settings via options, advanced options, and checked that shared box however it will still not allow everyone into the database at the same time. Is there something that I am missing? Should I then right click and copy and paste the front end to local PC since the tables are split and still on the share drive???? I plan on using security in the future will this cause a problem???Thanks
View 3 Replies
View Related
May 22, 2007
Hi,
I need to allow my MDB to have 15 users accessing at the same time. They will be updating different parts of the same table using different forms. The system will also do an automatic update from another system in 15 mins interval.
Is it possible? If so, how do I configure my access database?
Please help.
Thanks!!!
View 13 Replies
View Related
Jan 29, 2008
I would like your opinion on this; I have a ms access database that will be used in a multi-user environment, across different Teams. Data will be loaded from text files several times a day in a MS Access table, users will retrieve the data from the tables and displayed in a form. Their job will be to add comments and select drop down boxes for actions they have taken. Since the data is downloaded in the tables and retrieved from the user instead of the user keying in the data from scratch I would like to know how to best design this. I’m thinking of having a query run to display the data in the user form but is there a way that I can have the data refreshed every so often so that users can be presented with the new records that are being downloaded. What best practice should I use to avoid conflicts like example splitting the database or using record locking options
Any help is appreciated! Thanks
View 2 Replies
View Related
Mar 11, 2008
:Hi,
At the moment I'm writing a production database for work, which include parts in/out, production planning, kitting lists and other forms. What I'm after is a way that when the database opens it asks for a password and depending what it is, is what you can do. Administrator can do all, Stores can only enter parts and scheduler can only enter planning and so on.
How easy is this? :o
View 3 Replies
View Related
Mar 14, 2008
1) I develop my application(Ms-Access 2k) and put into company network directory.
2) The problem here is only 1 user allow to access per time.
3) Is there any setting I miss out?
View 4 Replies
View Related
Mar 17, 2008
Hello Everyone! I have a project that is driving me crazy!! :mad:
I have a form on a database that retrieves data from a query; this database is in a multi-user environment. What I am trying to accomplish is to allow the form to bring up the next available record that has not/or is NOT being worked on yet. The form I built does a re-query every time the user goes to the next record and looks for anything that has not been worked on yet. It does this by looking at the timestamp the user has placed once completed the record on the form. I also placed my record locking option to Edited Record. However when the users sign on simultaneously they still get the same item on their screen. Is there a way to create some sort of locking mechanism that would allow the form to display to the user the next available record that has not been or is not being worked on by a user at this time? Theoretically I am looking at something like this: Once a user opens the form and the record is displayed on the screen, lock the record and avoid any user from viewing or editing this record. All other users should be directed to the next available record, every time the user hits the next button move to the next available unlocked record and immediately lock it from viewing or editing from everyone else.
I appreciate any help you can provide me on this!!
View 1 Replies
View Related
Nov 1, 2004
Hi everyone,
can anybody help me on this. I have two PCs connected and i am trying to execute an Access file from the client PC. This appears to be possible but the problem is that i cant save any new record and Active X or OLE seems to be the problem according to the message box appeared when i execute a form. The file works normally when executed from the server.
Any ideas?
It appears that the problem comes when Vba Code is executed for example i can save records from the tables but not from the forms where VBA code is attached
View 2 Replies
View Related
Dec 9, 2004
Hi all, question about using a table for temporary storage. When a user clicks a button after selecting critiera, a form is displayed with fields bound to a TempTable. On this form is a subform which pulls 3 peices of data from a table called QuestionsTable. As a user clicks through the subform, two fields are populated by the user and get stored in the QuestionsTable.
Once done, the user clicks a button and a SQL statement grabs the data from the main form (TempTable) and subform (QuestionsTable) and shoves it into the Archive table. A SQL statement then runs to delete the contents of the TempTable, and Delete the *modified* data in the QuestionsTable (by simply setting the 3 fields which will change to " " or Null).
Now my problem. If two users are in the same form and one clicks save, the SQL statements eraase everything... so the 2nd user will be mid process and their data will poof.
I want to assign a Session ID each time the main form is loaded. This is set via AutoNum in the TempTable. My question is, how can I copy 3 fields (Question, Comment, Result) from the QuestionsTable and insert them into the TempTable, then have the subform load the 3 fields from the temptable (so in essence, everything is loaded from TempTable).
Did that make sense? Sorry if it didn't, I'm reaching my deadline on this and have a bad cold
View 3 Replies
View Related
Jan 13, 2005
I have a form "log_file" that I am going to be placing a nework. All I have done is create a new DB, create a table, and create a form. Now I want to make it so users open up the DB file and only see the form and cannot access/edit the table. Basically, It is okay if they go back and forth through the records and change those, but I don't want them to be able to edit the form either.
I'm just not sure where to go from here. If there is more info I should provide please let me know.
Thanks in advance.
View 3 Replies
View Related
Mar 22, 2005
i am looking for an outlook style planner in Ms Access for a booking sytem i am trying to put together, can anyone point me in the right direction of how best to tackle this please.
I have scoured the net for samples, and have come back to the most helpful place on the net for more assistance on where to go with this...
What i am looking to do is to set up something like this..
Click here to see example picture
how hard would this be to do?
Cheers
Andy
View 3 Replies
View Related
May 12, 2005
Hi Guys
I am begining to create a IT support database for my company. I have never really needed to use secuirty for the other projects that i have completed but this one is a bit different. i have used the security wizard to create the users and groups but would like to get the basis of the security correct before i go any further.
My question is how do i configure it so that users can only update or change or delete thier own entries apart from me who could alter anything. Do i begin now when i am setting up the tables or is it a bit more complex and would require checks during accessing forms etc.
Any help and advice would be great
Many Thanks
Martin
View 4 Replies
View Related
Dec 7, 2005
Hi,
I setup a Security. And different user,
then it creates 2 files: Account.bak, and Secured.mdw
I can open it, but it cannot be opened on another computer, why??
I already setup.
Thanks.
View 2 Replies
View Related
Oct 19, 2006
Well,
I am currently looking into some of the security aspects of Access, as I am still not yet sure how i'll be designing a new database program, (whether to use Delphi to link to the database or run the database through Access itself) however, I was wanting to look into the security aspect of Access itself as part of my education and decision making process. Now I have deduced (correctly?) that some of the user/group access rights are based on the NT/2k/XP User/Group permissions etc, yet I was wondering if there was a little more to it than that.
In some ways I would like the application (through access or otherwise) to initialize with a logon prompt, that would ask for username and password. The database would internally?? retain the password information for security rights. I'm not sure if i'm thinking this through correctly, so i decided to come here for a few pointers in the right direction.
I'd like to set up internal to the database a set of groups and users with different levels of security. I don't want them based on the XP user account passwords and such, but just an internal database login. This would allow, to some degree, a specific master group to add / remove users from the database, as well as control user access rights to the database internally.
More or less, I want the database itself to be self-contained with all security and access rights, instead of basing them off of some external NT based security information.
So to my actual questions:
Is this possible?
Where would I start looking to set this up?
thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
View 7 Replies
View Related
Nov 27, 2006
Hey
When i implement user security on my access database at home with user ID's and passwords, i need to take this database and copy it into another computer at work. However, when i open my access database on other computers at work, there is no prompt for a login password or user ID.
Why is this so?
Thanks
View 1 Replies
View Related
Nov 28, 2006
Hey, when i set up user security at home on a database and save this database to my USB memory stick, i then take this memory stick to be open on another different computer at the internet cafe. However, when i open the database on another different computer there is no prompt for log in user names and passwords. This is not what i want.
Why is this so?
Thanks for the help
View 6 Replies
View Related