[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ckeditor within access app "access is denied" error

Posted on 2011-10-24
18
Medium Priority
?
1,465 Views
Last Modified: 2012-05-12
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
Comment
Question by:Dalexan
  • 10
  • 8
18 Comments
 
LVL 75
ID: 37021286
What version of Access?  If > A2007, is your db in a Trusted Location ?

mx
0
 

Author Comment

by:Dalexan
ID: 37021294
Its access2003

I'm not familiar with a trusted location?
0
 
LVL 75
ID: 37021309
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 75
ID: 37021324
IE ... Trusted Locations do not really apply to A2003.
0
 

Author Comment

by:Dalexan
ID: 37021352
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
 

Author Comment

by:Dalexan
ID: 37021359
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
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 37021366
You might be interested in this also:


http://www.lebans.com/htmleditor.htm
0
 

Author Comment

by:Dalexan
ID: 37021398
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
 
LVL 75
ID: 37021414
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
 

Author Comment

by:Dalexan
ID: 37021431
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
 
LVL 75
ID: 37021457
Well maybe, but since you are using the Microsoft Web Browser control ... seems that is going to be tied to IE ...

mx
0
 
LVL 75
ID: 37021462
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
 
LVL 75
ID: 37021516
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
 

Author Comment

by:Dalexan
ID: 37021532
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
 
LVL 75
ID: 37021556
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
 

Author Comment

by:Dalexan
ID: 37021566
It looks like I will be leaning toward the lebans solutions rather than ckeditor. I will try IE8 as my last ditch effort.
0
 
LVL 75
ID: 37021581
ok
0
 

Author Closing Comment

by:Dalexan
ID: 37028399
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses
Course of the Month19 days, 13 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question