Cannot open in exclusive mode...... karlroes[ at ]hotmail.com 08.06.2006 04:10:14 ....continuing from this thread that is more than a month old. http://groups.google.com.au/group/microsoft.public.access.security/browse_thread/thread/571375a4541ea917/a048d2b9e437af77?q=31+times#a048d2b9e437af77 I am going through these same issues right now! The message is an Office system message from memory" Cannot open in exclusive mode - any design changes may not be saved...etc" The Design changes bit is the interesting point here for me. In another thread in this newsgroup, I discussed security settings for linked tables using the RefreshLinks Method with Joan Wild ( I think ). Modify Design permissions are, as per the FAQ, required as a minimum for relinking tables in code but setting them to administer in the front end did the the trick (as it doesn't effect permissions on the back end tables - only the links themselves). Now this worked - for a week. And then the error, which is Error ID 10016 by the way, has returned. Keeping in mind here that I am a much better Access developer than network administrator, could the relinking method ( changing link design ) have something to do with the following Windows 2003 error event?? http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B913119 Event Type: Error Event Source: DCOM Event Category: None Event ID: 10016 Date: Date Time: Time User: NT AUTHORITY\SYSTEM Computer: SMSSERVER Description: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {05D1D5D8-18D1-4B83-85ED-A0F99D53C885} to the user NT AUTHORITY\SYSTEM SID (S-1-5-18). This security permission can be modified using the Component Services administrative tool. Now, where I see the error in the client app is as follows: Order of code events : login, hidden startup form opens, splash screen opens, splash screen closes, opens hidden form for persisant link to back end, open hidden form for user logging, open menu form then Error ( times 31 ). I'll post back with results ( if any )

Re: Cannot open in exclusive mode...... "Joan Wild" <jwild[ at ]nospamtyenet.com> 08.06.2006 14:03:10 Have you tried all the things from that thread? Remove any custom toolbar/menu in startup Remove the custom menu entirely Import into a new mdb (avoid this unless something else doesn't work as you'd have to reassign permissions). Post back if you're going this. Someone else reported that Adobe PDF Maker was causing the problem http://groups.google.com/group/microsoft.public.access.security/msg/3c4e269365ece808?hl=en& -- Joan Wild Microsoft Access MVP karlroes[ at ]hotmail.com wrote: [Quoted Text] > ...continuing from this thread that is more than a month old. > > http://groups.google.com.au/group/microsoft.public.access.security/browse_thread/thread/571375a4541ea917/a048d2b9e437af77?q=31+times#a048d2b9e437af77 > > I am going through these same issues right now! > > The message is an Office system message from memory" Cannot open in > exclusive mode - any design changes may not be saved...etc" > > The Design changes bit is the interesting point here for me. In > another thread in this newsgroup, I discussed security settings for > linked tables using the RefreshLinks Method with Joan Wild ( I think > ). Modify Design permissions are, as per the FAQ, required as a > minimum for relinking tables in code but setting them to administer > in the front end did the the trick (as it doesn't effect permissions > on the back end tables - only the links themselves). Now this worked > - for a week. And then the error, which is Error ID 10016 by the way, > has returned. > > Keeping in mind here that I am a much better Access developer than > network administrator, could the relinking method ( changing link > design ) have something to do with the following Windows 2003 error > event?? > http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B913119 > > Event Type: Error > Event Source: DCOM > Event Category: None > Event ID: 10016 > Date: Date > Time: Time > User: NT AUTHORITY\SYSTEM > Computer: SMSSERVER > Description: > The application-specific permission settings do not grant Local > Activation permission for the COM Server application with CLSID > {05D1D5D8-18D1-4B83-85ED-A0F99D53C885} to the user NT AUTHORITY\SYSTEM > SID (S-1-5-18). This security permission can be modified using the > Component Services administrative tool. > > Now, where I see the error in the client app is as follows: > > Order of code events : login, hidden startup form opens, splash screen > opens, splash screen closes, opens hidden form for persisant link to > back end, open hidden form for user logging, open menu form then Error > ( times 31 ). > > I'll post back with results ( if any )