将Access 2010 accdb转换为2007 accdb [英] Convert Access 2010 accdb to 2007 accdb

问题描述

我试图将accdb文件从Access 2010中的使用转换为Access2007.我首先尝试使用Access 2007打开该文件，但出现错误Unrecognized database format.我可以通过删除MSysResources表(使用新的附件数据类型)在2007年打开后端，但是该技术不适用于我的前端.

I'm trying to convert an accdb file from use in Access 2010 to Access 2007. I first tried opening the file with Access 2007 and I get the error Unrecognized database format. I was able to get my backend to open in 2007 by removing the MSysResources table (which uses the new attachment datatype) but the same technique has not worked with my front end.

我的前端确实使用了Web浏览器控件(Microsoft声称该控件不起作用，但也不会停止打开文件表单).我认为我最好一次导入一个表格，看看错误在哪里.在新的空白2007文件中，我尝试使用> Access导入一种形式(一种非常简单的形式，一个按钮，两个文本框).与打开整个文件相同的错误.我尝试将2010与2007同时打开，然后复制/粘贴表单.同样的错误. Unrecognized database format.

My front end does use a webbrowser control (which Microsoft claims won't work but also won't stop the file form being opened). I thought I'd better import one form at a time to see where the error is. While in a new, blank 2007 file I tried to use External Data>Access to import one form (a very simple form, a button, two text boxes). Same error as opening the whole file. I tried having 2010 open at the same time as 2007 and copy/pasting the form over. Same error. Unrecognized database format.

然后我尝试在2010年使用Application.SaveAsText导出表单，并在2007年使用Application.LoadFromText导入表单.虽然存在导入错误，但是至少此方法会生成错误日志. error.txt文件的标题行PublishOption =1出现问题.删除后，我会不断收到有关主题设置的错误.我删除所有与之相关的主题(HoverForeThemeColorIndex，AlternateBackThemeColorIndex ...)都存在问题的每一行.我从来没有摆脱过足够多的东西来成功导入表格.

I then try to export the form using Application.SaveAsText in 2010 and import using Application.LoadFromText in 2007. There were errors importing but at least this method generates an error log. The error.txt file has issue with the header line PublishOption =1. After I remove that I continually get errors regarding theme settings. I remove every line it has a problem with which are from there on all theme related (HoverForeThemeColorIndex, AlternateBackThemeColorIndex...). I never did get rid of enough of these to successfully import the form though.

我要去哪里错了?如果像我怀疑的那样，我无法使用2007年在2010年生成的主题，该如何从所有表单中删除所有这些引用?这真的是问题吗?如何更顺利地移回2007文件?

Where am I going wrong? If, like I suspect, I cannot use a theme generated in 2010 in 2007, how can I remove all these references from all my forms? Is this actually the problem? How can I more smoothly move back to a 2007 file?

编辑:事实证明客户端在Office 2007 SP2上.我将更新我的开发机器，然后再试一次.我原来不是在使用否服务包.

It turns out the client is on Office 2007 SP2. I'm going to update my development machine and try all this again. I was not using nay service packs originally.

推荐答案

根据Microsoft支持文章

According to the Microsoft support article

Access 2010和Access 2007之间的向后兼容性

可以通过以下方式将Access 2010数据库恢复为"Access 2007格式":

an Access 2010 database can be reverted back to "Access 2007 format" by

1. 从数据库中删除所有特定于Access_2010的功能(本文中的详细信息)，
2. 创建一个新的空白数据库"(不是空白Web数据库")，并且
3. 使用Access 2010中的External Data > Import将先前数据库中的所有对象(表，表单等)导入到新的(空)数据库中.

1. removing all Access_2010-specific features from the database (details in the article),
2. creating a new "Blank Database" (not "Blank Web Database"), and
3. using External Data > Import in Access 2010 to import all objects (tables, forms, etc.) from the previous database into the new (empty) one.

必须删除的功能列表包括一些对于偶然检查原始Access 2010数据库而言可能不是立即显而易见的功能，例如

The list of features that must be removed include a couple that may not be immediately obvious to a casual inspection of the original Access 2010 database, such as

• 使用新的或更新的数据库排序顺序，并且
• 使用"Access 2010加密合规性".

这篇关于将Access 2010 accdb转换为2007 accdb的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！