Multi-user Accessability Issues, Workgroup Needed?
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 Replies
ADVERTISEMENT
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 1 Replies
View Related
Mar 13, 2007
Is there any function or code that would display the workgroup in which the current user belongs simular to the function "currentuser()" which displays the user logged onto the db?
View 9 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 27, 2005
I run a multi-user system of over 200 users. The only facility I have for advising an office-wide logout is required is the email system. However, staff either don't read their email or forget so I have to run around like a headless chicken trying to get everyone to get out/stay out of the system while I perform maintenance etc. Is there a way to enforce a logout and keep users logged out until a requested time without spending a fortune on new software?
Any advice would save me a lot of hair pulling (not mine :)).
View 2 Replies
View Related
Jun 22, 2005
I am currently attempting to setup a database that will be used by many people. I have the database setup and it is split into a backend (tables and data) and a front end ( forms, queries, etc) which the users will download and use off their own machines. I'm attempting to house the backend on our webserver.
The backend is on our webserver and I'm attempting to link the tables from the front end to this location. I typed in the webaddress into the open menu after selecting the Get External Data --> Link Tables menu item. I am sure that this web address is correct because I copied from my browser (from which I was able to download the database from). After I put in the web address into the open box, I get an error about not a valid file name. Is there something I'm not thinking about? What could be my problem? Is it permissions maybe? Does there need to be something special setup with the backend or my webserver? Any ideas as to do with the problem would be greatly appreciated.
View 3 Replies
View Related
Aug 23, 2005
Hi, I have made an application, which records daily work done and generates some reports based on daily records updated.
I have about 40 team members, i want this application to be multi user, how can i do this.
Can i store this application on a sharedrive and give a replica to each user? if yes how shall i do it.
Please suggest. any help will be highly appreicated.
View 1 Replies
View Related
May 4, 2006
My database is on a shared server and many people are able to access the database at any time. What would be the best method to create a way for me to make design changes, etc. without having to make sure everyone is out of the file to allow me to open exclusively?
View 6 Replies
View Related
Jan 10, 2007
I use a timestamp field in my tables to help me with productivity metrics for about 6 individuals who use one of my databases.
The issue I have is that their system times are constantly "out of whack." We fix them, and it just happens again. It apparently another program on the computer that causes the issue, but I can't do anything about that.
Is there another timesource available for the timestamp when using now()? Is there a way to use the time of the server (shared) that the backend is on?
I have no idea how to fix this issue.:confused:
View 1 Replies
View Related
