Access 2010&旧应用程序损坏 [英] Access 2010 & legacy apps corruption

问题描述

大家好！ ： - ）  -   Access 2010 - Windows Vista SP2

Hi all! :-)  -  Access 2010 - Windows Vista SP2

我似乎遇到了一些2003-2007-2010应用程序损坏的问题。有些应用程序最初是在2003年创建的，并且已转换为2007年。它们在2007年运行良好，但是，现在我在Access 2010中使用它们，我看到了一些损坏。而且，这也是在2007年创建的一些应用程序中发生的，但是，对于旧版本的应用程序来说似乎更是如此。我所看到的是以下内容：

I seem to be having a problem with some 2003-2007-2010 apps corrupting. Some of the apps were originally created in 2003 and converted to 2007. They have worked fine in 2007, but, now that I am using them in the Access 2010 I am seeing some corruption. And this is also happening with some apps that were created in 2007 as well, but, seems to be more so with older version apps. What I am seeing is the following:

1。有些宏在2010年停止工作。他们已经在2010年工作了几个月，我打开应用程序突然他们不再工作了，我不得不重做宏。

1. Some macros just stop working in 2010. They have been working in 2010 for several months and I open the app and suddenly they no longer work and I have to redo the Macros.

2。某些形式的代码的某些部分突然消失了。不只是出现故障，它们就不见了。模块完全是空的。 我要做的是转到应用程序的备份（我确保保留备份），复制丢失的代码并将它们粘贴到正确的模块中以便表单生效。

2. Some parts of code(s) in some forms suddenly are gone. Not just malfunctioning, they are gone. The modules are totally empty.  What I have to do is go to a backup of the app (I do make sure I keep backups), copy the missing code(s) and paste them into the proper modules in order for the forms to work.

3。有些功能根本不再起作用，因为似乎缺少参考库以使应用程序正常运行，或者缺少.dll文件我必须在网站或旧版本的Access上找到才能安装，它
甚至可以工作。

3. Some functions simply no longer work, as it seems there is a missing Reference Library needed to make the app function properly, or there are missing .dll files that I have to find either on a website or an older version of Access to install, it that will even work.

问题1和2令人困惑，因为当宏或代码不再存在或不起作用时，不会出现错误消息。我遇到的唯一线索是当我点击标签或按钮时没有任何反应。当我打开
来查看按钮后面的代码时什么都没有，一切都消失了。当我打开宏时，在点击窗口中不再有任何内容。

Problems 1 and 2 are confusing, as there are no error messages that appear when the macros or codes no longer are there or not functioning. The only clue that I have there is a problem is when I click on a label or button and nothing happens. When I open to see the code behind the button there is nothing, everything is gone. When I open the macro, there is no longer anything in the On click window.

问题3.有一个错误，表示缺少引用，但当然，它不说是哪一个。

With problem 3. there is an error that says there is a missing reference, but, of course, it does not say which one.

以下是我已经厌倦了解决问题的一些事情1& 2，使用原始数据库中的每个测试副本：

Here are some of the things I have tired to correct problems 1 & 2, using a copy from the original database for each test:

我尝试创建一个新数据库并将损坏的应用程序中的所有内容导入到新的数据库中以查看是否有帮助但是，问题仍然存在。

I have tried creating a new database and importing all the stuff from the corrupted app into the new one to see if that would help, but, the problems persist.

尝试编译数据库没有运气

尝试反编译数据库没有运气。

Tried compiled the database with no luck
Tried decompiling the database with no luck.

尝试进行所有必要的更正，导入并复制/粘贴所有丢失的代码并重新输入宏，然后将所有更改导入新数据库。有些问题似乎有一段时间了，但是，问题突然又出现了。

Tried making all necessary corrections and importing and copy/paste all missing codes and re-entering macros and then importing all into a new database. Some of the problems seem to work for a while, but, then problems are suddenly there again.

关于缺失参考文献的问题，我几乎没有运气。

I have had little to no luck with the problems regarding the missing References.

我的问题是，在使用2007或更早版本的应用时，其他人是否在Access 2010中看到过这种行为？因为这非常令人沮丧，我根本没有时间在2010年从头开始完全重新创建所有数据库。来自'97，2000和2003的
应用程序在2007年都运行良好。这些问题只发生在Access 2010中。

My question is whether others have seen this kind of behavior with Access 2010 when using apps from 2007 or older versions? Because this is very frustrating and I simply do not have time to completely recreate all the databases from scratch in 2010. The apps from '97, 2000 and 2003 all work fine in 2007. These problems only happen in Access 2010.

我希望有人可以在2010年打开遗留应用程序时尝试或应该做些什么，以防止这种腐败，如果可能的话。任何建议或信息都将真正受到赞赏。

  Jan :)

I am in hopes someone here might have a some input as to what I might try or should do when opening legacy apps in 2010 to prevent this kind of corruption, if possible. Any suggestions or information would truly be appreciated.
 Jan :)

推荐答案

我想知道问题是否与ACTIVEX对象有关 从2007年开始，microsoft一直试图消除ActiveX对象并用等效的表单替换tem。对象。

I'm wondering if the problem is with the ACTIVEX objects.  Starting with 2007 microsoft has been trying to eliminate the ActiveX objects and replacing tem with the equivalent forms .object.

许多Office库只是调用Win32 API Dll的包装器。 由于2010年打算在64位环境的Windows 7上运行，因此某些Win32功能的工作方式不同，可能会导致问题。

Many of the Office libraries are just wrappers that call the Win32 API Dll.  Since 2010 is intended to run on Windows 7 which is a 64 bit environment some of the Win32 functions aren't working the same and may be causing the problems.

你有没有试过修复任何一个使用Microsoft Office工具访问文件 - Microsoft Office Application Recovery？

Have you tried repairing any of the Access files using the Microsoft Office Tools - Microsoft Office Application Recovery?

这篇关于Access 2010&旧应用程序损坏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！