名站网址导航为大家提供关于数据库教程相关的教程网站知识。
Access2010使用Treeview出现问题的解决办法(适合32位及64位)
Access 2010-使用TreeView (MSComctlLib.TreeCtrl.2) 在windows 安全补丁更新之后, 使用就出现错误了,复制 MSCOMCTL.OCX 到 syswow64下再注册也不行,建议 使用版本:6.1.98.34,相关资料:http://www.microsoft.com/zh-cn/security/pc-security/bulletins/201208.aspx,1.先使用这个具体相关方法,regsvr32 /u mscomctl.ocx,regsvr32 mscomctl.ocx,针对 Windows 7 or 2008 - 运行 cmd.exe "使用管理员身份",for 32bit Windows systems: regsvr32 c:\windows\system32\mscomctl.ocx,for 64bit Windows systems: regsvr32 c:\windows\syswow64\mscomctl.ocx,2. 国外的解决办法如下: (大部分情况下可行),reg delete hkcr\typelib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0 /f,if exist %systemroot%\SysWOW64\cscript.exe goto 64,%systemroot%\system32\regsvr32 /u mscomctl.ocx,%systemroot%\system32\regsvr32 mscomctl.ocx,exit,:64,%systemroot%\sysWOW64\regsvr32 /u mscomctl.ocx,%systemroot%\sysWOW64,\regsvr32 mscomctl.ocxexit,3. 微软官方的解决办法,http://support.microsoft.com/kb/2597986解决微软安全补丁更新后的问题,http://go.microsoft.com/fwlink/?LinkId=263512下载这个网站网站文件来修复,或 下载 : http://www.microsoft.com/zh-cn/download/details.aspx?id=36841,. 它会下载 mscomctlocx2010-kb2687503-fullfile-x86-glb.exe,运行这个程序将会自动修复这个问题,并且不需要重启,假如如果您的Mscomctl.ocx控件的版本是 6.1.98.33 或6.1.98.34 才需要运行它,相关链接:http://support.microsoft.com/kb/2748410,附加信息:,Microsoft 发布了一个针对 Microsoft Office 2010 32 位版本 的更新。此更新提供 Microsoft Office 2010 32 位版本 的最新修复。此外，此更新包含,4. 微软针对这个Treeview(Mscomctl.ocx)的官方解决办法(http://support.microsoft.com/kb/2687441),基于 Windows Common Control 的嵌入式 ActiveX 控件可能无法在预先存在的 Office 文档中、第三方加载项中，以及当您在开发人员模式下插入新控件时加载。,推荐的解决方案,现在可下载安装控件并修复控件注册的修复程序。 咱们建议您安装此修复程序来解决问题。您可以在此下载修复程序。,注意,在安装此修复程序来解决问题之前，您不必安装安全更新 2687441。,注意,假如如果您不安装该修复程序并选择了其他分辨率，则当您为 Office 安装在 MS12-060 之后发布的更新时可能还会遇到相同的问题。,其他解决方案,假如如果愿意，您可以使用“Fix it”解决方案来让咱们为您解决此问题。 为此，请转到“Fix it for me”部分。,解决具体相关方法,Regsvr32,要解决此问题，您可以使用注册表编辑器删除相关注册表项。 然后使用开始执行命令注册 Mscomctl.ocx 网站网站文件。 您也可以创建批处理网站网站文件使其自动化。,手动删除相关注册表项,重要说明,此部分、具体相关方法或任务包含有关如何修改注册表的步骤。但是，注册表修改不当可能会出现严重问题。因此，请一定严格按照下列步骤操作办法。为了获得进一步保护，请在修改注册表之前对其进行备份。这样就可以在出现问题时还原,322756如何在 Windows 中备份和还原注册表,要删除此注册表项，请执行下列步骤：,依次单击“开始”、“运行”，在“打开”框中键入regedit，然后单击“确定”。,找到并单击注册表中的以下子项：,hKEY_CLASSES_ROOT\TypeLib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0,在“编辑”菜单上，单击“删除”，然后单击“是”。,退出注册表编辑器，然后重新启动计算机。,手动注册 Mscomctl.ocx 网站网站文件,注意,您必须使用管理员权限从提升的开始执行命令提示符处运行开始执行命令。为此，请执行下列步骤：,cmd,单击“开始”，键入。,右键单击“cmd”图标，然后单击“以管理员身份运行”。,根据您使用的操作办法系统，键入下面的一个开始执行命令，然后按 Enter：,对于 64 位操作办法系统，请键入以下开始执行命令：,Regsvr32 "C:\Windows\SysWOW64\MSCOMCTL.OCX",对于 32 位操作办法系统，请键入以下开始执行命令：,Regsvr32 "C:\Windows\System32\MSCOMCTL.OCX",创建批处理网站网站文件以删除相关注册表项，并注册 Mscomctl.ocx 网站网站文件,您可以创建批处理网站网站文件以删除注册表项，并注册 Mscomctl.ocx 网站网站文件。要创建批处理网站网站文件，请将以下文本复制到文本网站网站文件中，然后使用网站网站文件扩展名“.bat”保存该文本网站网站文件。(下例检测操作办法系统是 32 位,reg delete hkcr\typelib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0 /f,if exist %systemroot%\SysWOW64\cscript.exe goto 64,%systemroot%\system32\regsvr32 /u mscomctl.ocx,%systemroot%\system32\regsvr32 mscomctl.ocx,exit,:64,%systemroot%\sysWOW64\regsvr32 /u mscomctl.ocx,%systemroot%\sysWOW64\regsvr32 mscomctl.ocx,exit,regsvr32,要自动运行开始执行命令，请将开始执行命令行开关添加到前一个示例中的每个开始执行命令。例如：,%systemroot%\system32\regsvr32 /u mscomctl.ocx /s,注意,您必须以管理员身份运行批处理网站网站文件：,要在 Windows Vista、Windows Server 2008、Windows 7 或 Windows Server 2008 R2 中执行此操作办法，请右键单击批处理网站网站文件，然后单击“以管理员身,以管理员身份运行,要在 Windows XP 或 Windows Server 2003 中执行此操作办法，请按住 Shift 键，右键单击批处理网站网站文件，然后单击,有关如何以管理员身份启动程序的更多信息，请转到以下 Microsoft 网页：,http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/windows_security_runa,有关如何注册 ActiveX 控件的详细信息，请单击下面的文章编号，以查看 Microsoft 知识库中相应的文章：,2746232(页面可能为英文) 如何手动注册 ActiveX 控件 (.ocx),7.FMS提供的解决办法 原文: http://www.fmsinc.com/MicrosoftAccess/Controls/mscomctl/?goback=.gde_937037_membe,修复 Microsoft Windows Common Control Library (MSCOMCTL.OCX) 安装更新导致的问题,Microsoft Office 的新的安全更新,在2012年8月14日,微软发布了一个安装更新补丁,里面包含了Windows Common Control MSCOMCTL.OCX的更新:,注意这个控件的日期是6月份,但它是包含在这个8月份的安全补丁包中.,微软针对这个补丁的相关知识库(KB),KB2597986- for Office 2010,KB2687441- for Office 2007,KB2687323- for Office 2003,微软版本,以下版本:,Windows XP, Vista, Windows 7 (32/64 bit),Windows Server 2003, 2008, 2008 R2,使用这个更新可能导致的问题,After installing the update, the Windows Common Control Library does not work. The issue seems to st,The symptoms are rather odd. It's not as if the control is completely missing or not registered. The,In other cases, users are reporting that Microsoft Access locks up and crashes. People are also repo,Impact on Total Access Analyzer,This impacts our Total Access Analyzer product which displays the results of your Microsoft Access d,Error 459 - Object or class does not support the set of events, Procedure clsFrmExplorer_TAA.InitFor,If your PC received the security update and you're using the Microsoft Access 2010, 2007, 2003, 2002,Known Issues as Reported by Microsoft,Microsoft has acknowledged problems with their security update that is causing these problems. The i,In that article, they mention the known issues with the security update:,Windows Common Control-based embedded ActiveX controls may fail to load within pre-existing office d,For 64-bit operating systems, type the following: Regsvr32 "C:\Windows\SysWOW64\MSCOMCTL.OCX",For 32-bit operating systems, type the following: Regsvr32 "C:\Windows\System32\MSCOMCTL.OCX",The article goes into details about unregistering the control and re-registering it using a batch fi,Microsoft's Suggested Solution Fails,In our internal testing, we've discovered that the recommended steps don't work in most cases. Just ,Our Steps for Fixing the Registration of the Windows Common Control,While there seems to be nothing physically wrong with the new OCX, we need to register another versi,Unregister the new MSCOMCTL.OCX and make a backup of it,Install and register an old (legacy) version of the MSCOMCTL.OCX file,Replace the legacy control with the new one,Re-register the new control,#FormatImgID_0#Windows Command Prompt and Security Permissions,You need Administrator rights to make registry changes. Depending on your operating system and Windo,From your Windows Start button under, All Programs, Accessories, launch the Command Prompt by right ,You can then copy the Regsvr32.exe command lines described below into the dialog.,32 Bit Windows,Unregister the new OCX file. Open an instance of the Windows Command Prompt, paste the following com,Make a backup of the OCX file C:\Windows\System32\MSCOMCTL.OCX to C:\Windows\System32\MSCOMCTL.bak,Copy a legacy version of the MSCOMCTL.OCX file to your C:\Windows\System32 folder. For your convenie,Register this legacy OCX file with the following command: Regsvr32.exe C:\Windows\System32\MSCOMCTL.,Unregister this legacy version of the OCX file: Regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX,Delete the legacy OCX file: C:\Windows\System32\MSCOMCTL.OCX,Rename the new OCX file we renamed in step 2, back to its original name: C:\Windows\System32\MSCOMCT,Re-register the new version of the OCX file. Paste the following command and press : Regsvr32.exe C:,Reboot the computer.,Open Microsoft Access and then retest the control. It should be working at this point.,64 bit Windows,The 64-bit steps are identical to the 32 bit version except the folder is SYSWOW64 rather than SYSTE,Unregister the new OCX file. Open an instance of the Windows Command Prompt, paste the following com,Make a backup of the OCX file C:\Windows\SYSWOW64\MSCOMCTL.OCX to C:\Windows\SYSWOW64\MSCOMCTL.bak,Copy a legacy version of the MSCOMCTL.OCX file to your C:\Windows\SYSWOW64 folder. For your convenie,Register this legacy OCX file with the following command: Regsvr32.exe C:\Windows\SYSWOW64\MSCOMCTL.,Unregister this legacy version of the OCX file: Regsvr32.exe /u C:\Windows\SYSWOW64\MSCOMCTL.OCX,Delete the legacy OCX file: C:\Windows\SYSWOW64\MSCOMCTL.OCX,Rename the new OCX file we renamed in step 2, back to its original name: C:\Windows\SYSWOW64\MSCOMCT,Re-register the new version of the OCX file. Paste the following command and press : Regsvr32.exe C:,Reboot the computer.,Open Microsoft Access and then retest the control. It should be working at this point.,Why This Solution Works,The reason why Microsoft's recommendation to un-register and re-register the new MSCOMCTL.OCX Common,The problem is that the update leaves some old 2.0 Version entries in the Registry. The previous MSC,The new file version is 6.1.98.34 but Version 2.1 in the registry. here we are talking about registr,The patch installs the new version but leaves a part of the old registry settings.,By installing and uninstalling the legacy control, it cleans up the 2.0 registry so the new version ,hKEY_CLASSES_ROOT\TypeLib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0,We have the same problem. In our Add-In, we were able to trace the problem to a declaration of a var,The machines that have this problem were all updated early this morning (15 Aug 2012) with the follo,Security Update for Microsoft Office 2007 suites (KB2596615),Security Update for Microsoft Office 2007 suites (KB2596754),Security Update for Microsoft Office 2007 suites (KB2596856),Security Update for Microsoft Office 2007 suites (KB2687441),Update for Microsoft Office Outlook 2007 Junk Email Filter (KB2687400),Windows Malicious Software Removal Tool x64 - August 2012 (KB890830),At present, we have not found any information on the MSDN site that could clear this up. We're still,Same issue here today after performing the update for Office 2007 Excel. Oddly, one system had no is,Also, you might want to check if these application extensions are present in windows\sysWOW64 or win,This article applies toWord, Access, Excel and PowerPoint. MS12-060 is a security update that was re,"Unspecified Automation Error" when running or compiling your Microsoft Office VBA code after instal,or,"Errors were detected while saving 'filename.xlsm'. Microsoft Office Excel may be able to save the f,clicking continue you will see "Document failed to save" or similar error.,Update - 9/26/2012. Seethis blog postfor the latest update.,Fixit Available,There is a fixit available for this problem:,Office 2010 w SP1 -http://support.microsoft.com/kb/2597986,Office 2007 w SP2 or SP3 -http://support.microsoft.com/kb/2687441,Office 2003 w SP3 or Office 2003 Web Components w SP3 -http://support.microsoft.com/kb/2687323,Steps to fix the problem manually,Alternatively, the manual fix for this problem is to re-register MSCOMCTL.OCX. To do this, follow th,1. Open anadministrative-level command prompt. The command prompt MUST be on the administrative leve,2. If on a 64-bit machine, type the following:,regsvr32.exe /u C:\Windows\SysWOW64\MSCOMCTL.OCX hit ENTER,then type,regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCX,If on a 32-bit machine, type the following:,regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX,hit ENTER,then type,regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX,Your Office program should work again after doing this.,(Updated) 3. NOTE: The following step is done at your own risk. Microsoft doesn't know about any sid,hKEY_CLASSES_ROOT\TypeLib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0,to,hKEY_CLASSES_ROOT\TypeLib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0OLD,We've heard reports that renaming the key doesn't work. The key has to be deleted.,Afterward, follow steps 1 and 2 to unregister and re-register MSCOMCTL.OCX,Automating a Solution for Multiple Machines,You can also include the unregistration and re-registration in a batch file that is pushed out to mu,reg delete hkcr\typelib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0 /f,if exist %systemroot%\SysWOW64\cscript.exe goto 64,%systemroot%\system32\regsvr32 /u mscomctl.ocx %systemroot%\system32\regsvr32 mscomctl.ocx exit,:64 %systemroot%\sysWOW64\regsvr32 /u mscomctl.ocx %systemroot%\sysWOW64\regsvr32 mscomctl.ocx exit,If you require a batch file that runssilently, use the following:,reg delete hkcr\typelib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0 /f,if exist %systemroot%\SysWOW64\cscript.exe goto 64 %systemroot%\system32\regsvr32 /u mscomctl.ocx /s,:64 %systemroot%\sysWOW64\regsvr32 /u mscomctl.ocx /s %systemroot%\sysWOW64\regsvr32 mscomctl.ocx /s,Alternate Solution,See,http://blogs.technet.com/b/office_sustained_engineering/archive/2012/08/24/ms12-060-not-initiating-w
在access中更改控件的默认属性
Lisa Friedrichsen, 欧弗兰帕克,堪萨斯州
假如如果您在设计一个Microsoftaccess窗体时，想自定义所使用的文本框标签，本技巧将向您示范如何做到这一点：
在设计视图中打开一个窗体。
相关工具箱
单击上的相关工具。
窗体设计
单击相关工具栏上的，以打开的属性表。
自动标签
在框中，单击。
编者
您可以用相同的技术更改任意控件的默认属性。 转换您的access网站数据库以获得更好的性能 Daniel Jang, Vancouver, 不列颠哥伦比亚,加拿大 Access 2002自动以Access 2000格式存储所有的网站数据库网站网站文件，这一点对于较小的网站数据库来说非常重要并且使您能够和access2000用户共享您的网站数据库网站网站文件。 但是，假如如果您不打算与Access 2000用户共享您的网站数据库，或者您正在创建一个大网站数据库，您可以通过把网站数据库转换成新Access 2002格式来获取更好的性能。access2002将用新格式为您创建一个单独的网站数据库网站网站文件，而对您的原始网站数据库依然保持原样。 把您的网站数据库转换成access2002网站网站文件格式，具体相关方法如下： 相关工具 在菜单上，指向。 转换网站数据库 指向。 转为access2002网站网站文件格式 单击。 在access2002中打印报表的关系图 Regina Fortuniewicz, Ossining,纽约 报表的正确设计以及它们之间的关系对于构造一个良好的网站数据库非常关键。access2002能够通过为网站数据库中的报表关系生成图形化的表示来帮助您评估您的设计良好与否。 相关工具 在菜单中，单击。 网站网站文件 在菜单中，单击。随即生成一份报告，显示它们在关系窗口中所表现出的关系。 假如如果需要的话，可以保存或打印这份报告，然后关闭报告窗口。 关闭“关系”窗口。
