关于拆分访问数据库的说明 [英] Clarification on splitting an Access Database

问题描述

我已经阅读了多篇文章并观看了视频，但这是结构上的很大变化，因此我想确认一下我的想法.

I've read multiple articles and watched videos but this is a big change to the structure so I want to confirm the idea that I have.

拆分会将表和表单/查询拆分为单独的文件.我知道了但是有两个问题.

Splitting will separate the tables and forms/queries into separate files. I get that much. But two questions.

1)我应该事先备份数据库吗?

1) Should I backup my database beforehand?

2)当数据输入团队正在使用这些表单时，我可以在设计/布局视图中对其进行编辑吗?

2) Can I edit the forms in design/layout view while they're being used by, say, a data entry team?

我现在遇到的问题是，我创建了一个简化的前端供其他团队使用，但是现在我需要在他们使用时对其进行增强.我听说这是最有效的方法.

The issue I'm running into now is that I created a simplistic front end for another team to use but I now need to buff it up while they use it. I heard this was the most efficient way to do so.

推荐答案

1)是的，当然.

2)每个用户都应该拥有自己的前端本地副本.

2) Every user should have their own local copy of the frontend.

您在本地计算机上开发了新的前端版本，然后将其放置在网络驱动器上，每个人都可以从那里获得他们的新本地前端.

You develop the new frontend version on your local computer, then when it's ready you put it on a network drive, and everyone gets their new local frontend from there.

这里有一些如何实现此目的的想法: https://stackoverflow.com/a/33782644/3820271

Here are some ideas how to automate this: https://stackoverflow.com/a/33782644/3820271

永远不要在其他用户当前正在使用的数据库上进行设计更改. (颤抖)

You should never make design changes on a database that other users are currently using. (shudder)

修改.评论:

所有表格都在前端，所以可以.您在与开发后端(生产后端的副本)连接的开发前端上工作.

All forms are in the frontend, so yes. You work on your development frontend, connected to a development backend (a copy of the production backend).

其他用户同时可以在生产后端上使用其本地前端.

The other users can meanwhile work with their local frontends on the production backend.

准备发布时，请在生产后端中进行必要的更改(如果表结构发生更改).复制您的开发前端，并从prod后端链接表.这是新的产品前端，已分发给所有用户.

When you are ready for release, make the necessary changes in the production backend (if there are changes in table structures). Make a copy of your dev frontend and link the tables from prod backend. This is the new prod frontend, which is distributed to all users.

这篇关于关于拆分访问数据库的说明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！