K
karlroes
....continuing from this thread that is more than a month old.
http://groups.google.com.au/group/m.../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;en-us;913119
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 )
http://groups.google.com.au/group/m.../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;en-us;913119
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 )