Hi All

I am using Microsoft Access 2003 and I have migrated my existing database from 2002. When working within the previous system I was able to succesfully use Microsoft Rich Textbox Control 6.0 (SP4), It now comes up with a message;

'Microsoft Access Dosen't Support this Active X control.':(

Some help in sorting this little problem would be nice

Simon

Probably a dll version issue. There's a good chance you can find the error and explanation by searching the Microsoft knowledgebase but I haven't taken the time to do this. The solution may be as simple as reregistering the control's library with RegSvr32.

To avoid the dll hell, I never use the packaged controls. Ever. Mainly because I developed in an environment where Access was the only tool and security prevented install of any application or outside files and there was no possibility of getting authority to move any kind of dll or executable on to or off the systems. Would you believe locks in the floppy drives and on the cases so no one could add a drive? No authority to set the time or create a shortcut? I could go on.

I learned early on that you can harness the power of the built in Windows controls and I've never had a problem with a reference or library not working. I would suggest you take a look at the 'Older NON ActiveX solutions:' at:

http://www.lebans.com/richtext.htm

He has his own ActiveX newer versions as well but I tend to avoid them out of the habits developed in my earlier environments. One of his free Rich Edit textboxes may be worth a try if you can't find an answer by searching Microsoft's online resources.

Ciao
Jürgen Welz
Edmonton AB Canada
[email protected]

I can't tell you exactly what causes this error, but I suspect someone is playing with the Registry, maybe a commercial RichText control vendor. Did you install a commercial RichTxt TRIAL control?
Anyway, the way I solved the problem was to UN-Register the ..\System32\RICHTX32.ocx version 6.0.88.4 (Latest? on my XP w/ Office 2003) control. Note that you may(?) have to stop several processes to UN-Register this control successfully.
Then when i RE-Registered it, ACCESS 2003 could use it without any messages or problems.
Good Luck, fred

Microsoft made a change in Office 2003 that prevents the use of the RichTextBox control. See KB Article 838010. Looks like there will be loads of broken code over this one!

Kevin Wornell

A quick followup.

The RichTextBox 6 control will also cause issues if you apply SP3 to Office XP, again see the Microsoft propaganda at 838010 in the Knowledgebase.

Kevin Wornell

Try this to fix your ActiveX
http://www.access-programmers.co.uk/...ad.php?t=65363

and

Try this sample for your Rich Text Box Controls
http://www.dbforums.com/t997217.html

Don't utilize the "solution" found at the http://www.dbforums.com/t997217.html link, unless you like having an email sent to the access db creator without your permission/knowing. Totally inappropriate and deceitful.

Here's the solution for you Access 2003 and some Access 2002/XP SP3 Users for using the RichTX32.OCX ActiveX control in your Access databases :)

This method will allow Internet Explorer to also use Richtx32.ocx which does open a security flaw to be opened up, but it's the choice you take. See the KB article at MS for more info on this.

To allow Access 2002 w/SP3 or 2003 to use this control, you need to edit the registry via regedit, find the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{3B7C8860-D78F-101B-B9B5-04021C009402}

This should be there, I am dead sure that RichTx32.ocx always takes the class ID of 3B7C8860-D78F-101B-B9B5-04021C009402

Within this key there should be a DWORD value called "Compatibility Flags".

If this is set to 0x400 (hexadecimal 400, decimal 1024) then change it to simply 0 (decimal or hex). You should now be able to insert the richtext control on your forms and use the control again as per usual in Access 2002 w/SP3 or Access 2003.

I tested this with IE 6 to check if it blocks it and Access 2003 and changing this registry key does indeed remove the block.

:)

Hope this helps.

Vicky (blueBase Design)
([email protected] - http://www.lilserenity.com)

Thanks to Vicky.

I changed the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{3B7C8860-D78F-101B-B9B5-04021C009402}
 and it works !!

How do I change this registry automaticaly? I like to have some code doing it for me?

/Romanov

The last message posted here was over a year ago..but in case anyone is still having to deal with this issue (which crops up periodically for me as Microsoft comes out with new security updates) I thought I'd post the following:

Creating the following .reg file will allow you to automatically clear the kill flag (as noted in Vicky's post) AND clear the entry that marks RichTx32.ocx as 'safe for scripting'. The latter change currently 'seems' to minimize the number of times I must 'un-kill' RichTx32.ocx by (perhaps) eliminating one of the security hole issues Microsoft has with this .ocx:

Fix_Richtx32.reg file
================================================== =======
Windows Registry Editor Version 5.00

[-HKEY_CLASSES_ROOT\CLSID\{3B7C8860-D78F-101B-B9B5-04021C009402}\Implemented Categories\{7DD95802-9882-11CF-9FA9-00AA006C42C4}] #this should be 'one' file line

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{3B7C8860-D78F-101B-B9B5-04021C009402}] #this should be 'one' line
"Compatibility Flags"=dword:00000000 #this should be on the next line

================================================== ===============================

If you create a .bat file you can edit the registry 'silently' (e.g. without having to answer the 'are you sure...' questions

Fix_Richtx32.bat file
================================================== ============================
regedit.exe /S "Fix_RichTx32.reg"
================================================== ============================

Put both files in the same folder then simply double-click the .bat file to make the changes in the registry.