If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multi User Lockout
Albert,
Enlighten me if I am confused. His user is using a different FE, hopefully on his own computer. Since he is opening the FE, wouldn't his .ldb files and others be there? "Albert D.Kallal" wrote: Upon closing my .mdb, his FE can open normally. I can then reopen my FE and it seems to be working correctly. So, I am not sure why it doesn't seem to be letting multiple users in. You need to check and ensure that your users to the shared folder have FULL rights. When I say full rights, we are talking about file create rights, file delete rights etc. When ms-access starts, it needs to create some locking files to allow it so run in multi user mode. What happens when some users don't have full rights to the folder, then ms-access can't create these temp files to manage collisions, and there for opens the file in SINGLE USER mode. In addition to the above, it is possible that the settings (in your mde, or mdb) file were set to open the file exclusive, and again this means that the users settings will be for single user mode. Check out the settings in tools-options-advanced tab. Take a look at the above settings, and make sure the default open is set to shared. And, also check out the permissions you gave to users to the shared folder where the mdb is, since temp files need to be created, and deleted in this folder. (in fact, the persistent connection trick fixes performance problems due to those temp files not having to be created, and deleted). -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#2
|
|||
|
|||
Klatuu wrote:
Albert, Enlighten me if I am confused. His user is using a different FE, hopefully on his own computer. Since he is opening the FE, wouldn't his .ldb files and others be there? In a split app two LDB files are created. One for the front end and one for the back end. Each is created in the same folder as the corresponding app file. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
The FE is installed on each user's computer. Does the BE generate a separate
lockfile for each user, or does it keep track of multiple users within a single file? Matt Martin "Rick Brandt" wrote: Klatuu wrote: Albert, Enlighten me if I am confused. His user is using a different FE, hopefully on his own computer. Since he is opening the FE, wouldn't his .ldb files and others be there? In a split app two LDB files are created. One for the front end and one for the back end. Each is created in the same folder as the corresponding app file. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#4
|
|||
|
|||
"Klatuu" wrote in message
... Albert, Enlighten me if I am confused. His user is using a different FE, hopefully on his own computer. Since he is opening the FE, wouldn't his .ldb files and others be there? Temp locking files are created on the shared folder. Ask your self how does ms-access handle collisions between multiple users when no software runs on the server side? (answer: Each front end creates entries in a locking file that is in the shared folder, and thus each front end can look at this shared file and manage the collisions). Sure, a locking file is also created in the front end folder, but that would be used only for local tables in the FE. So, if locking files can't be deleted, and created in the back end folder, then ms-access can't run in multi-user mode. It needs these files so each front end can figure out who what got what record locked. Ms-access has to manage and figure out how to deal with multi-users, and that information can't possibly be in the front end folder...so, naturally, that locking information is SHARED amount all of the front ends...just like the data file is...... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#5
|
|||
|
|||
"MartinMCU" wrote in message
... The FE is installed on each user's computer. Does the BE generate a separate lockfile for each user, or does it keep track of multiple users within a single file? There is ONE lock file created on the server that ALL of the fronts use. So, only ONE lock file is made, and the first user in creates this lock file. The above explains often why people ask how come when certain users go in first, that NO other users can work. Where as if other users go in first, then all others can work. (answer: that first user going in has create/delete rights to the folder...where the other user did not. As mentioned, if ms-access can't create the locking file in the BE to be shared by ALL users, then multi-user operation cannot happen). This shared folder is where information about collisions and record locking occurs. Very simply if ms-access can't make that file, then it can't manage multiple users. -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to change the company name and user name in the About |
[email protected] | General Discussions | 0 | May 11th, 2005 03:13 PM |
Adding another user's e-mail to the folder list. | darylakagod MCP MCSE CCNA | General Discussion | 1 | April 26th, 2005 06:49 PM |
More..Multi User with 1 e-mail account on same PC | Dkso | General Discussion | 0 | February 2nd, 2005 09:12 PM |
Procedure run (Access open / Close) | Niklas Östergren | General Discussion | 9 | December 29th, 2004 02:02 PM |
New User needs to Import old Outlook Express emails and addresses | DougFromSydney | Contacts | 1 | June 17th, 2004 05:32 PM |