 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / September 2007If exclusive, dont run
My form "UpdateForm" has a command button "Update" that runs make table queries that will only run if the database is exclusive to the user updating. I would like a run a small code before the update starts instead of using the On Error GoTo event of the "Update" control to have a message box pop to let them know they cant update at this time. I'm not sure how it would look, but this is what im thinking. If "ChartTracking.mdb" = exclusive Then run "update" Else MsgBox "My messege to the user to let them know they cant run update at this time" End If "Ryan Tisserand" wrote in > My form "UpdateForm" has a command button > "Update" that runs make table queries that will only [quoted text clipped - 11 lines] > they cant run update at this time" > End If In your update process, is there additional user interaction before executing the command that would trigger the "On Error GoTo" -- effort that would be lost? If not, then it will be transparent to the user whether you execute code to issue a MsgBox and don't try to run the update, or whether you run the update, it triggers the error, and you execute code to issue a MsgBox. Larry Linson Microsoft Access MVP There is additional interaction. I have a progress bar that lets them know that the update is running. Another reason to check if the database is exclusive or not is because there is a total of 9 queries that run when the command button is pushed. It may make it through 4 of these queries before it reaches one that is locked due to someone being in that recordset. This is why I need to check the status of the database Before the update is ran. > "Ryan Tisserand" wrote in > [quoted text clipped - 23 lines] > Larry Linson > Microsoft Access MVP For this very reason, I have gotten away from Make table queries in a multi-user setup. I prefer to use a delete query followed by an append query. Still not perfect but this has been working fine for our applications. John > There is additional interaction. I have a progress bar that lets them > know [quoted text clipped - 39 lines] >> Larry Linson >> Microsoft Access MVP If in Access 2000 or later, try opening an Object in the Database in Design View, if it succeeds, you have opened for Exclusive Use. If you end up in the Processing specified in your OnError statement, you can shut down. I do not remember if that is the case for Access 95 and 97, and am not set up to try. In Access 2.0, for sure, you did not have to have Exclusive Use to modify objects. Larry Linson Microsoft Access MVP > There is additional interaction. I have a progress bar that lets them > know [quoted text clipped - 39 lines] >> Larry Linson >> Microsoft Access MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.