Opened Exclusively message davecoats622 22.02.2006 14:40:30 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?

Re: Opened Exclusively message Tony Toews <ttoews[ at ]telusplanet.net> 22.02.2006 21:42:51 davecoats622 <davecoats622[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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? 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 -- Tony 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

Re: Opened Exclusively message davecoats622 23.02.2006 15:40:33 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. "Tony Toews" wrote: [Quoted Text] > davecoats622 <davecoats622[ at ]discussions.microsoft.com> wrote: > > >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? > > 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 > -- > Tony 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 >