 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / February 2006Opened Exclusively message
I have a FE and BE using a Workgroup file for multiuser login. I have a procedure that gets called during the initial login which checks to see if there is a backup of the database. If not, it makes a backup. This procedure works great until it gets to the last step which uses the "DBEngine CompactDatabase" procedure. I have it set up to save the compacted database to a separate folder. I get a message saying, "You attempted to open a database that is already opened exclusively by user 'CRTPPac' (or whatever user I log in as) on machine 'WDNFSH0030N' Try again when the database is available". What should the permissions be set to in order for the user to CompactDatabase? I've already played with the "Shared" vs. "Exclusive" opening defaults and I get the message both ways. Any suggestions? >I have a FE and BE using a Workgroup file for multiuser login. I have a >procedure that gets called during the initial login which checks to see if [quoted text clipped - 7 lines] >CompactDatabase? I've already played with the "Shared" vs. "Exclusive" >opening defaults and I get the message both ways. Any suggestions? Do you have a bound form open to a table in the backend? Which we strongly suggest for performance reasons. Or a switchboard form bound to a table in the backend. Tony  SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Yes, that was it. There was a table that was a linked table which was being used prior in the code. That caused the Backend to be opened exclusively by that user. Then when the CompactDatabase routine was called, it could not access the file to create the compact. The solution was that I needed to bring that table to the Front End instead of the backend. Thanks for the help. > >I have a FE and BE using a Workgroup file for multiuser login. I have a > >procedure that gets called during the initial login which checks to see if [quoted text clipped - 13 lines] > > Tony |
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.