安装Access 2007时使用Access 2010运行时查看ACCDB [英] Viewing ACCDB with Access 2010 runtime when Access 2007 is installed

问题描述

我希望有人可以告诉我我做错了什么，纠正我对这是如何工作的错误理解，并解释为什么这是不可能的.

I'm hoping someone can either tell me what I'm doing wrong correct my flawed understanding of how this works and explain why it's not possible.

我一直在为Access中的客户端开发一个相当基本的数据库/程序.他们有Office 2007，我有Office2010.在2010年创建数据库(以"2007"格式)并在Office 2007中打开表单和数据的初步测试没有问题.

I've been developing a fairly basic database/program for a client in Access. They have Office 2007, I have Office 2010. Initial test of creating a database in 2010 (in "2007" format) and opening the forms and data in Office 2007 showed no problems.

快进3周.我已将最近的副本发送给他们以供批准，他们无法打开它.无法识别的数据库格式.环顾四周，看来Access 2007格式在向后兼容性方面并没有任何意义(感谢M $).我可以遵循看似标准的答案，并删除空白字段，计算所得的列等，但实际上认为没有必要.

Fast forward 3 weeks. I've sent them a recent copy for approval and they can't open it. Unrecognised database format. Upon looking around, it seems Access 2007 format doesn't really mean anything in terms of backward compatibility (thanks M$). I COULD follow the seemingly standard answer and remove empty fields, calculated columns etc but really don't think it should be necessary.

我已将Access 2010运行时安装在目标系统之一上，并了解这将允许我打开Access 2010开发的ACCBD.没运气. Office 2007仍将启动，并且显示无法识别的数据库格式".

I've installed the Access 2010 runtime on one of the target systems with the understanding that it would allow me to open the Access 2010-developed ACCBD. No luck. Office 2007 still launches, and "unrecognised database format".

目标系统上是否安装了Access 2007?还是我可能误解了Access运行时分发的用途是什么?基本上，有一种方法仍然可以部署Access 2010中开发的程序/数据库，而无需a)安装(并购买Office 60的大约60个许可)，或b)剥离现有的ACCDB.

Is the problem that Access 2007 is installed on the target system? Or am I perhaps misunderstanding what the Access runtime distribution is for? Basically, is there a way to still deploy a program/database developed in Access 2010 without a) installing (and purchasing about 60 licenses of) Office 2007, or b) stripping back the existing ACCDB.

推荐答案

对于A2007和A2010，我还没有进行足够的工作来解决A2007无法打开正在使用A2010的ACCDB的问题.您对Access运行时的用途的理解基本上是正确的.

I haven't worked enough with A2007 and A2010 to help with the problem of A2007 not being able to open the ACCDB in which you were working in with A2010. Your understanding of how the Access runtime is for is basically correct.

但是，当客户端针对您的ACCDB执行A2010运行时时，他们是否创建了引用A2010运行时msaccess.exe的路径以及ACCDB的路径和文件名的快捷方式?类似于

However when the client was executing the A2010 runtime against your ACCDB did they create a shortcut referencing the path to the A2010 runtime msaccess.exe and the path and file name of the ACCDB? Similar to

"C:\ Program Files \ Microsoft Office \ OFFICE14 \ ART \ MSACCESS.EXE""Q:\ 1 access \ NewsgroupAnswers.mdb"

"C:\Program Files\Microsoft Office\OFFICE14\ART\MSACCESS.EXE" "Q:\1 access\NewsgroupAnswers.mdb"

这篇关于安装Access 2007时使用Access 2010运行时查看ACCDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！