Access Locking Up With Multiple Users
Hi,
I have a database that i created for our tech support team. I have split the database and have given the 3 users each a shortcut. I als e only installed Access Runtime on their machines.
The first user in pilot testing had no issues and we have just added the other 2 users. At first all was well. However, the 2 new users are now having periodic lock ups where they go to enter a new record and the dbase freezes on them. It seems to release itself in a few minutes, but this does not help my productivity.
My original user is still not having any trouble. Does anyone have any ideas of something that perhaps I missed? Everything I have read, suggests that 3 users should not have any trouble using a split dbase.
Is it runtime that may be causing this? I have considered going to full versions if need be, but then I would need to figure out how to lock it down better.
Thanks
Dave
View Complete Forum Thread with Replies
Related Forum Messages:
Locking Users From Records
About six months ago I created a database for tracking customer calls and comments. I replicated this database because I wanted to be able to make design changes without effecting the users ability to add records. I have no security set up for the database except for startup options. I am having an issue with users being locked from adding records once in awhile. The dialog box says "Could not update; currently locked by user 'Admin' on machine '***'". The more I read this the more I am thinking that they are getting assigned the same record ID when they go to make an entry. Although, if the users are patient and wait a few minutes they are able to finish adding the record without deleting it and starting over. There are now 22 people utilizing the database and about 17 of them are using it consistently. Any insight on this would be appreciated.
View Replies !
Troubleshooting Access Multiple Users
-------------------------------------------------------------------------------- I maintain the Access databases at the hospital that I work at. Last weekend, our server went down. Computer Services got a new server and reworked the networking permissions. However, Access will no longer allow more than one user to open the database at a time. This is a problem because we always have multiple users that need simultaneous access. The default is still "Open Shared" and I checked to ensure that the databases are not being opened exclusively. However, the message that I do get when a second user tries to open the database is: The table 'MSysAccessObjects' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically. (Error 3008) - I understand that this message usually comes up when I try to open a table that is already being edited elsewhere. I have the record locks set to "edited record". However, this is a system file, so I am hesitant to make changes in it unless I know exactly what I am doing. This is a problem that we have never had before but for some reason was created after our server went down. I don't know why something changed or if this table is absolutely necessary. I am unsure where to start to solve the problem.
View Replies !
Limitations Of Using Access With Multiple Users On Intranet
Hi, I would like to use an Access database over an Intranet. What are the limitations of doing this? I want multiple individuals to be able to open forms and enter data. I would also want others to be able to run queries and reports on the database. Would I need to upsize to an Oracle database to run with multiple users? Any words of wisdom would be appreciated.
View Replies !
Multiple Users Can't Open Same Access Database
Greetings. When I create an Access database on my company's "secure" server (through a PIX box), I get this message in a dialog box when I try to open the database again: "Open File - Security Warning. Do you want to open this file?" It then gives the file Name, Publisher (unknown publisher), Type (Microsoft Office Access Application), and From (the file path and name). The bottom of the dialog box has this message: "While files from the Internet can be useful, this file type can potentially harm your computer. If you do not trust the source, do not open this software." When I click on the "Open" command button, the file opens just fine. There are a couple of things going on here: 1) When I open this same database or any other Access database on another of my company's servers that is not protected by a PIX box, I do not get this dialog box. 2) When two users try to access an MS Access database on the "secure" server, the first user will get in, but the second user will not. The second user will not get ANY warning messages -- nothing happens. This occurs if the second user tries to open the database by either double-clicking on a shortcut on the desktop or by double-clicking on the file name in Windows Explorer. Note that the second user CAN access the same file if s/he starts up MS Access from scratch, and then chooses FILE>OPEN from the main menu. My goal is to be able to let multiple users access the MS Access databases on the secure server by either double-clicking on the shortcut icon or by double-clicking on the file name in Windows Explorer. I thought perhaps that the "unknown publisher" issue might be part of the problem on the secure server. So I created a certificate using the utility "SELFCERT", went into the database, went into Visual Basic (Ctrl-G), went into TOOLS>DIGITAL SIGNATURE and assigned the digital signature, and re-saved the file. I then exited the file, went back in, and the dialog box still pops up saying the file's publisher is "unknown publisher"! If I go back into Visual Basic, the database is clearly marked as digitially signed by me. I don't know why the initial dialog box is still showing that the file is not digitally signed. If anyone has any thoughts about these issues (multiple users not being able to access the same Access database, and why my file is saying it is still not digitally signed), I would appreciate your input. FYI, I am on a Windows XP workstation and our company users Windows Servers. Thanks, David
View Replies !
Ways To Make An Access Db Available To Multiple Remote Users?
Having researched further I am now under the impression that I can actually make my db available THROUGH my website i.e through the users browser (does this eliminate the need for Access to be installed on the users machine?). From what I can gather (and I am not at all clear with these things) there are several options : Use SQL/mySQL etc etc as the b/e and then do something!? Use PHP or ASP.NET to put the db onto the site and then do something? Use DAP and then do something? Now I am quite prepared to go away and learn more about these various methods (which is clearly needed) but i wanted advice first as time is of the essence and I don't want to do more than i have to YET! Which is the EASIEST (a relative term I know!) method considering : 1) There will only be around 5-10 users to begin with (not all working simultaneously). This may increase to around 20-30 users within a year or two. 2) I know very little about SQL or scripting in ASP, PHP etc 3) My db holds around 7k records (will be upto 20k within a year), approx 15 tables, 25 Queries, 15 forms, 20 reports, 8 modules and 15 macros (must macros be converted to code before I can make mde files? I know I should convert them all to VB but they were so easy to use when i first started!) 4) Buying legal copies of MS Access (even the runtime version) is not cheap! 5) I could do with having it complete within a week! 6) All home users have broadband (1-2Mb) connections
View Replies !
Multiple Users Trying To Access Reports With Append Queries ::Please Help::
-------------------------------------------------------------------------------- I have a dilema on my hands as I can't seem to figure out the best way to accomplish this. I created a database to handle all of our letters for my department in the company. The problem I am having is that we have 26 people who could possible access the database at the same time. The letters are created using a form. (not a problem with multi-users) When someone wants to print the letter the do a search either by "Letter Date", "Provider Name", "Provider Number", or "Group Name". I set it up so either one of these search queries append data into one table called "Letter Report Information" all 38 letters get there data from this 1 table. The problem I am having is that if John and Mary try to pull different/same letters at the same time or while one is viewing their letters the data is getting pushed onto the others Letter. Example: Mary goes to print her Welcome letter John also goes to print his Denial letter at the same time When John's letters show up.. the Denial letter shows up with his data, but also with Mary's Welcome letter data. What can I do or what kind of query can i use to avoid this problem as it is becoming a very prominent issue? ::Please Help:: Thanks.
View Replies !
Hosting The Access File On A Server And Having Multiple Remote Users
I am making a database to coordinate the activities of my band (how rock and roll!)... Is there a way I can somehow host the file remotely, and have users (4 total) access that file through their own computer using access, so they can write, edit, delete records? We have a db at my work that we use like this, accessing from multiple computers, though this is on a network drive.
View Replies !
Multiple User / Database Locking
Another baffling problem - there are far more traps for new players than I ever imagined. Any suggestions gratefully received. I have a fe/be split database with multiple users on a network. All users have the same front end on their PCs and are either running Access 2000 or 2003. Problem 1: Some users cannot open the database at all, getting the error message "Could not open xxxxx.mdb - File already in use." Problem 2: Some users can open the database but get a message in the status bar saying "Recordset not updateable." Other users, running either Access 2000 or 2003 have been able to use the database without difficulty. The number of users is in single figures and it is unlikely that more than 4 people have attempted to log on simultaneously. The database default open mode is set to "shared", the default record locking is set to "No locks" and the "Open database using record-level locking box is checked". I have been having difficulties setting the security for the database (see other postings on this site) and so it is currently unsecured with no password set for the admin user. Users are joined to their default system Workgroup Information Files. My guess is that there is a setting on the Access installation of the user's PC that needs to be changed but this is only a guess - anybody any idea what I should try next? Regards, Keith.
View Replies !
Multiple Users
All, I have database with user level security that works fine, but I have asked to place this database onto our secured network which means multiple users could have it open at any given time. How can I setup this database to allow multiple users? I am very, very green at Access. Please don't say split the database...please! :eek: debo
View Replies !
Multiple Users
Please refresh my memory on how i can set up a database having about 10 users possibly making entrie at the same time. I am trying to make a small database for containing employee surveys.
View Replies !
MDE And Multiple Users
I want to create and mde file in order for the users not to change any thing on my design, I will be uploading the file into my server and give them the path to access: 1.3 people (max) will be accessing the database, is that a problem or not? 2. I cant create an mde file I have to convert my db but I have read as well if I covert it to 2000 people who have lower or higher version wont be able to access it, how can I fix that? Thanks.
View Replies !
Multiple Users?
Hi, I am trying to create a database that MULTIPLE users can log on and view the data. Eg. I have a client list and have employed 5 ppl to call each one of my clients and confirm their details. I have imported all the details into a table and just want users to simulataneously log on and click a "next record" button that will bring up the next "new" record with the details displayed on a form. of course the database will flag this record as "old" and which user called them. Main thing is 5+ computers can connect to this database simultaneously and no record gets displayed more than once. Can MS Access do this? if it cant, would a vb front end located on each computer help? Thanks for any suggestions! Jon Cheah
View Replies !
Multiple Users
i have a database which is shared on the network. i have one problem right one. when one is using the database, another person cannot access it. what can i do to enable multer user access it at the same time. Any help will be highly appreciated.
View Replies !
Multiple Users
Hi all, o.k prior to a previous message i have been back to my manager and informed him that there is no way of updating effectivly via email. o.k first i will tell you what we will have: Three networked pc's running xp prof, and access 2003. Now what i want is to be able to have my database running as a server on one machine and have the two other machines running the same database simultaniously all of them updating. Now what i need, i dont want to have the work done for me, just if someone could point me in the right direction, maybe one or two tutorials, any pitfalls i may find etc. thanks in advance.. Rob
View Replies !
Multiple Users
I am building a database which will be used by around 30 people at the same time. When telephone calls come in they will log the details. I dont need anything to explicit. I have one table, around six queries and 3 reports. I will be using one form with a save button and next record button and a switchboard. The users will log on at the same time and will log all telephone calls thoughout the day. Will the database work with so many people using it at the same time or do I have to change the properties.
View Replies !
Multiple Users Over VPN
I'm a relatively new Access user who is remotely connecting over VPN to an Access DB on a "fileserver" on a peer-to-peer network. The VPN connection is "always on", and I have a drive mapped to the fileserver. When I originally load the Access file, it takes about 2-3 minutes to be able to start working. If no one else is updating records, my speed is fine. If someone else updates a record, my Access session "freezes" for 2-3 minutes... coincidentally the same amount of time needed to load the DB in the first place. I assume this is because the entire DB is resynchronizing everytime a record is updated. Is there anyway to speed this process up? My updating records does not have a similar effect on the local users. Thanks for any help or suggestions, RJRon My computer: Dell laptop, P3-500, 128Mb RAM Operating system: Windows XP Pro at both ends Access version: Access 2003 at both ends My internet connection: Cable, download consistently over 1000kbps, not sure about upload Their internet connection: DSL, download consistently over 1500kbps, upload 500kbps
View Replies !
Multiple Users
How would I go about making my database so that more than one user could open it on the server and both be able to populate the tables. Is there any problems I should watch out for? Also, what is a good way to create a "log in" type form, where the user would log in to the DB, so I can keep track of who entered in the information, at what time and so on. And then would that person have to log out some how? or just close the database Jared
View Replies !
Multiple Users
I've created a database and I'd like to allow multiple users to go in and edit the same table. I looked in the Tools - Options - Advanced tab and it's currently set to open in Shared mode. However, when I have the database open (as the creator) no one else can open it. Is there a way to fix this? Thank you.
View Replies !
Multiple Users
I have a peer to peer network using XP. I have 5 people that need to share one MS Accss Data base. I have checked the security section and it is shared. The difficulty is that only two or three folks can be on at on any one time. I was hoping that all of us could be working at the same t ime. Any thoughts on how to accomplish this? Thanks in advance for your time
View Replies !
Multiple Users
Hello, I am going to have a database on a shared folder. Only about a max of 5 people will be accessing the db at one time. Will it be enought to just create the Frontend and Backend portions of the database and not run in to any problems. For example, if 2 or more people happen to be in the same record at the same time trying to update a field. I have studied the VBAUnbound.zip, but it is a little confusing to me. So if i can get away with just using bound forms that would be great. Thanks in advance.
View Replies !
Multiple Users Slowdown
Hi everyone, This is my first post, hopefully you guys can help me out. I have set up an access database for my dept. stockroom. The stockroom previously was just 1 excel spreadsheet that had the shared setting enabled so multiple people could edit it and such. This became extremely tedious and saves started to take up to 15 minutes when about 5 people had them each open and did edits. I managed to set up an access front end and backend for this situation. Basically the table was saved in an access database and the forms were in another that linked to the tables. So the table database is on the network shared folder, and the forms are on each individual computer. It seems like this would work fine and such, but when just 3 to 4 of them open up the forms and start working, as soon as one person trys to make a change, the whole program slows down almost to a halt. what am i doing wrong? any suggestions would be appreciated. Thanks! Jerry
View Replies !
|
TRACKER
