Cannot open in exclusive mode......

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

....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 )

.

Relevant Pages

  • Re: Cannot open in exclusive mode......
    ... you'd have to reassign permissions). ... The Design changes bit is the interesting point here for me. ... login, hidden startup form opens, splash screen ... opens, splash screen closes, opens hidden form for persisant link to ...
    (microsoft.public.access.security)
  • I was the owner of the access database. and now the owner is unkow
    ... that I don't have the necessary permission. ... Every once and while the login ... Microsoft Access MVP ... cut Access opens and I immediately get the message that I dont have ...
    (microsoft.public.access.security)
  • Re: DBEngine.CompactDatabase and Permissions
    ... True, the risk is small but if it brings no benefit, then what's the ... permission to compact from Access but not to run the CompactDatabase method. ... you should get an exclusive lock to do the compact. ... as David Epson says that Jet no longer opens the file. ...
    (microsoft.public.access.security)
  • Re: Word 2007 Wont directly open documents from Sharepoint
    ... Client Integration Feature is turned on. ... something wrong concerning the "Use Client Integration Features" permission. ... It is also possible that logging in on their workstation with a different ... Instead Word opens and just sits there. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Object Permission Message
    ... Then the permission problem will go away. ... Microsoft Access MVP ... Dim qdfRS as QueryDef ... each of which opens an input data form. ...
    (microsoft.public.access.security)