• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1513
  • Last Modified:

ckeditor within access app "access is denied" error

I want to use the wysiwyg editor, ckeditor in my access app to allow users to modify stored html within fields. I found this excellent example online but I'm having trouble figuring out why I get an "Access is denied" error on this line "v = wbEditor.Document.parentWindow.execScript(FunctionName & "()")" within the SetJavascriptData function within frmEditor

This example application works properly on another PC, within my development PC it does not work. accesshtmleditor.zip
0
Dalexan
Asked:
Dalexan
  • 10
  • 8
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
What version of Access?  If > A2007, is your db in a Trusted Location ?

mx
0
 
DalexanAuthor Commented:
Its access2003

I'm not familiar with a trusted location?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Not an issue per se in A2003.  I just tried the mdb ... and it 'seems' to work.  Tell me exactly how to reproduce the issue ... step by step.

mx
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
IE ... Trusted Locations do not really apply to A2003.
0
 
DalexanAuthor Commented:
I can open the app just fine on one PC, it opens properly and displays the html within the ckeditor display. Within my dev pc I get this error when I open the frmHTMLviewer and click edit i get a run time error "access is denied" and it breaks in code on v = wbEditor.Document.parentWindow.execScript(FunctionName & "()")
0
 
DalexanAuthor Commented:
I also get the message "CKEditor requires JavaScript to run. In a browser with no JavaScript support, like yours, you should still see the contents (HTML data) and you should be able to edit it normally, without a rich editor interface"
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You might be interested in this also:


http://www.lebans.com/htmleditor.htm
0
 
DalexanAuthor Commented:
Yes, I like that one as well, the users are more familiar with ckeditor as they already use it within a drupal framework. I would like to stick with ckeditor. I did try to open ckeditor directly from the ckeditor folder and I got the active X prompt restriction bar in IE. How can i change IE to allow this activeX?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I seem to be able to open whatever with no errors.

"How can i change IE to allow this activeX?"

Well ... somewhere in IE options ... see image.

mx
Capture1.gif
0
 
DalexanAuthor Commented:
I changed IE but I still get the same error when opening from the form. Is there a way to change this so that it opens using chrome instead of IE?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Well maybe, but since you are using the Microsoft Web Browser control ... seems that is going to be tied to IE ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
The are more ActiveX settings in Options ... further down in the list ... see if any of those make a difference.  Again, it's working on my system ... so, it must ... be one of those settings.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You might check this out:

http://chriscavanagh.wordpress.com/2009/08/25/wpf-chromium-webbrowser-source-code/

Referring to a Chrome Web Browser Control ...

mx
0
 
DalexanAuthor Commented:
I have upgraded to IE7 and changed almost all the security settings to allow everything but still no luck. I do get a different error message now with IE7, run time error 70 permission denied
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Well sorry.  I've tried this on two different systems ... and in each case it works.  Both with XP SP3 and IE8 ... so you might want to try IE8.
0
 
DalexanAuthor Commented:
It looks like I will be leaning toward the lebans solutions rather than ckeditor. I will try IE8 as my last ditch effort.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok
0
 
DalexanAuthor Commented:
I didnt try IE8 because I have other development projects that will not currently work with IE8. The lebans solution works fine for this project. If I can get this working in the future I will post a comment how.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 10
  • 8
Tackle projects and never again get stuck behind a technical roadblock.
Join Now