使用 Access 2010 打开和编辑 Access 2003 时出现问题
我们公司最近升级了我们的系统，包括Access 2010。我们所有的数据库都是Access 2003。我时不时地打开我们的标准数据库，就会出现我们的常规表格。有些表格可用于编辑和更新，而有些表格则被锁定且不可用。如何解锁数据库中的所有表单？
Our company recently upgraded our systems to include Access 2010. All of our database is Access 2003. From time to time, I open our standard database and our regular forms appear. Some forms are available for editing and updating while some are locked and not available. How can I unlock all of the forms within the database?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
从您的问题中尚不清楚相同的表单是否始终被锁定，或者任何给定的表单是否有时被锁定而有时可用。然而，使用拆分数据库可以避免这个问题：每个人都会获得一个单独的 UI 副本 - 一个“前端”数据库 - 但它们都指向相同的数据表 - 一个“后端”数据库。
有关拆分的详细信息：http:// office.microsoft.com/en-us/access-help/split-an-access-database-HA010342026.aspx
目前还不清楚您是否有理由想要保留您的.mdb 格式的数据库。除非您使用的功能不再受支持 - 或者某些用户没有 Access 2010 - 请考虑将数据库文件升级到 .accdb 格式 - 您将获得一些很酷的新功能，例如控件布局、附件字段、内置日期选择器等。
2007/2010 年新功能概述：http://office.microsoft .com/en-us/access-help/what-s-new-in-microsoft-access-HA010342117.aspx
Allen Browne 对 2003 年和 2007 年之间差异的概述： http://allenbrowne.com/Access2007.html
2010 年弃用的功能：http://office.microsoft.com/en-us/access-help/discontinued-features-and-modified-functionity-in-access-2010-HA101806473.aspx
It's not clear from your question whether the same forms are always locked, or whether any given form is sometimes locked and sometimes available. However, using split databases would prevent this problem: each person gets a separate copy of the UI - a "front-end" database - but they all point to the same data tables - a "back-end" database.
More info about splitting: http://office.microsoft.com/en-us/access-help/split-an-access-database-HA010342026.aspx
It also isn't clear whether there's a reason you want to keep your databases in .mdb format. Unless you are using a feature that is no longer supported - or some users don't have Access 2010 - consider upgrading your database files to the .accdb format - you'll get some cool new features, such as control layouts, attachment fields, built-in date pickers, etc.
Overview of new features in 2007/2010: http://office.microsoft.com/en-us/access-help/what-s-new-in-microsoft-access-HA010342117.aspx
Allen Browne's overview of differences between 2003 and 2007: http://allenbrowne.com/Access2007.html
Features deprecated in 2010: http://office.microsoft.com/en-us/access-help/discontinued-features-and-modified-functionality-in-access-2010-HA101806473.aspx