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
|
|||
|
|||
Unable to have multiple useres share database concurrently
The database is locking out other users. Once the database is closed then
another user can access it. This was created in Access 2007 as a 2003 format and is operating on an Access 2003 system. It is on a shared drive on a server and is the only file on this drive and all users have access. Some of the settings are listed below. Settings/Advanced: Default open mode: Shared Default record locking: No locks Open databases by using record-level locking: Checked If it is not a setting could you advise as to where the problem might be. Thank you for any assistance, CDS |
#2
|
|||
|
|||
Unable to have multiple useres share database concurrently
CDS,
Sounds like a folder permissions issue, what are the settings on the folder? As a side note, it sounds like all the users are sharing an unsplit database. This is bound to cause problems, the more serious being that of corruption. You should consider splitting, NOW, before it's too late. Here are some links to assist... http://www.members.shaw.ca/AlbertKallal/Articles/split/ http://allenbrowne.com/ser-01.html To handle the update of multiple front ends see... http://www.autofeupdater.com/ -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "CDS" wrote in message ... The database is locking out other users. Once the database is closed then another user can access it. This was created in Access 2007 as a 2003 format and is operating on an Access 2003 system. It is on a shared drive on a server and is the only file on this drive and all users have access. Some of the settings are listed below. Settings/Advanced: Default open mode: Shared Default record locking: No locks Open databases by using record-level locking: Checked If it is not a setting could you advise as to where the problem might be. Thank you for any assistance, CDS |
#3
|
|||
|
|||
Unable to have multiple useres share database concurrently
Is your database split? If it isn't that should be done before allowing
multiple users to work with it. -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "CDS" wrote: The database is locking out other users. Once the database is closed then another user can access it. This was created in Access 2007 as a 2003 format and is operating on an Access 2003 system. It is on a shared drive on a server and is the only file on this drive and all users have access. Some of the settings are listed below. Settings/Advanced: Default open mode: Shared Default record locking: No locks Open databases by using record-level locking: Checked If it is not a setting could you advise as to where the problem might be. Thank you for any assistance, CDS |
#4
|
|||
|
|||
Unable to have multiple useres share database concurrently
Thank you,
Christina "CDS" wrote: The database is locking out other users. Once the database is closed then another user can access it. This was created in Access 2007 as a 2003 format and is operating on an Access 2003 system. It is on a shared drive on a server and is the only file on this drive and all users have access. Some of the settings are listed below. Settings/Advanced: Default open mode: Shared Default record locking: No locks Open databases by using record-level locking: Checked If it is not a setting could you advise as to where the problem might be. Thank you for any assistance, CDS |
#5
|
|||
|
|||
Unable to have multiple useres share database concurrently
Thank you,
Christina "Gina Whipp" wrote: CDS, Sounds like a folder permissions issue, what are the settings on the folder? As a side note, it sounds like all the users are sharing an unsplit database. This is bound to cause problems, the more serious being that of corruption. You should consider splitting, NOW, before it's too late. Here are some links to assist... http://www.members.shaw.ca/AlbertKallal/Articles/split/ http://allenbrowne.com/ser-01.html To handle the update of multiple front ends see... http://www.autofeupdater.com/ -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "CDS" wrote in message ... The database is locking out other users. Once the database is closed then another user can access it. This was created in Access 2007 as a 2003 format and is operating on an Access 2003 system. It is on a shared drive on a server and is the only file on this drive and all users have access. Some of the settings are listed below. Settings/Advanced: Default open mode: Shared Default record locking: No locks Open databases by using record-level locking: Checked If it is not a setting could you advise as to where the problem might be. Thank you for any assistance, CDS . |
Thread Tools | |
Display Modes | |
|
|