且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

从表格读取数据时如何防止打开MS Access数据库

更新时间:2023-02-14 19:17:26

听起来像未拆分的应用程序(单个MDB文件中的表和表格/等),并且被多个用户共享.这是灾难性的情况.请参阅将Microsoft Access MDB分为前端和后端所有细节.

Sounds like an unsplit application (tables and forms/etc. in a single MDB file), and that it's being shared by multiple users. This is a disastrous scenario. See Splitting your Microsoft Access MDB into a front end and back end for all the details.

一旦拆分,您将处理单个副本,然后将更新分发给用户.关键是,从2000版开始,Access MDB的设计(与 data 相对)在任何用户打开时都无法编辑.

Once it's split, you'd work on an individual copy and then distribute updates to users. The point is that since version 2000 the design of an Access MDB (as opposed to the data) cannot be edited while it's open by any users.