拆分数据库，如何部署“前端”？ [英] Split the DB, how do I deploy the "Front-end"?
问题描述
我一直在处理有关人员被锁定的DB工作问题。
访问与独家相关的警告模式
我所做的研究和收到的回复表明我拆分了DB（前端/后端）。
数据库的工作副本被拆分了，我可以看到数据库（后端）是如何更新的。
这样的Access noob（实际上并没有构建）数据库）
我不知道人们在给桌面上的每个人提供表格副本时的确切含义。实际上，我知道他们的意思我只是不知道该怎么做。
问题，如果每个人在他们的工作站上都有数据库的副本那么后端只有在点击保存时才会更新？
当所有人都退出该数据库时，后端才真正流行吗？
有没有办法让某人得到从后端实时查看前端（在特定工作站）？
感谢您的帮助
Chuck
I have been having an ongoing problem with a DB at work concerning people getting "locked out".
Access warnings relating to "exclusive" mode
The research I have done and the replies received suggest I split the DB (front-end/back-end).
A working copy of the DB was split and I can see how the DB (back-end) is being updated.
Being such an Access noob (who did not actually build the DB)
I don''t know what people mean exactly when they say to give each person a copy of the forms on their desktops. Actually, I know what they mean I just don''t know how to do it.
Question, if each person has a copy of the DB on their workstations does the back-end only get updated when they hit save?
Is the back-end only really current when all people have logged out of that DB?
Is there any way for someone to get real time views of the front-end (at a particular workstation) from the back-end?
Thanks for the help
Chuck
推荐答案
查克
每个人都只获得前端的副本。所有用户都可以访问的服务器上只应有一个后端。数据应该实时更新。在后端转到工具 - 选项 - 高级，并确保默认打开模式设置为共享，默认记录锁定设置为编辑记录。这意味着用户无法同时编辑同一条记录，因为这可能会导致问题。
Mary
Chuck
Everyone gets a copy of the frontend only. There should only be one backend on a server which all users have access to. The data should be updated in realtime. In the backend go to Tools - options - Advanced and make sure that the Default Open Mode is set to Shared and Default Record Locking is set to Edited record. This means that users won''t be able to edit the same record at the same time as this could cause a problem.
Mary
Chuck
每个人都只获得前端的副本。所有用户都可以访问的服务器上只应有一个后端。数据应该实时更新。在后端转到工具 - 选项 - 高级，并确保默认打开模式设置为共享，默认记录锁定设置为编辑记录。这意味着用户无法同时编辑同一条记录，因为这可能会导致问题。
Mary
Chuck
Everyone gets a copy of the frontend only. There should only be one backend on a server which all users have access to. The data should be updated in realtime. In the backend go to Tools - options - Advanced and make sure that the Default Open Mode is set to Shared and Default Record Locking is set to Edited record. This means that users won''t be able to edit the same record at the same time as this could cause a problem.
Mary
感谢Mary的回复，我肯定会改变默认的开放模式
1.如果数据库位于共享驱动器上，我应该给它们什么（前面 - 最后明智的）
2.当你说每个人都得到一份副本时，这意味着我必须将一份本地副本放到他们的实际工作站上吗？
3.如果我将本地副本放到他们的工作站上，数据库如何知道更新到后端。
如果我问的是noob问题，请耐心等待，我不知道我不太了解访问权限，刚刚开始在这里我对文件系统结构的了解甚少。
我知道他们正在运行一个分布式文件系统，包含在数据库是通过服务器上的共享驱动器访问的。
整个问题出现是因为人们正在获取 ;被锁定数据库，如果第一个人打开数据库，那么在早晨，那么在他/她退出之前没有其他人可以。他们也得到各种各样的专属 由computerXX锁定错误。
此外，从它看起来的方式来看，DB实际上是他们输入信息的表单集合，但我真的看不出DB和a之间的区别电子表格，他们不运行查询，没有与任何表格相关的代码，表格甚至没有链接???
无论如何，足够的咆哮。任何有关上述问题的帮助都将不胜感激......
查克
Thanks for the response Mary, I will definitely change the default open mode
1.If the DB lies on shared drive what exactly do I give to them (front-end wise)
2.When you say everyone gets a copy does that mean I have to put a local copy onto their actual workstations?
3.If I put a local copy onto their workstations how does the DB know to update to the back-end.
Bear with me if I am asking noob questions, I don''t know much about access and having just started here I know even less about their file system structure.
I do know that they are running a distributed file system, the forms contained within the DB are accessed through a shared drive on the server.
This whole problem arose because people are getting "locked out" of the DB, in the mornings if the first person opens the DB then noone else can until he/she logs out. Also they are getting all kinds of "exclusive" "locked by computerXX" errors.
Also, by the way it looks the DB is actually a collection of forms which they enter info into, but I can''t really see the difference between the DB and a spreadsheet, they don''t run queries, there is no code associated with any of the forms, and the forms are''nt even linked???
Anyways, enough ranting. Any help on those above questions would be greatly appreciated...
Chuck
对于延迟回复感到抱歉，我整天被捆绑了在管理职责。帽子太多了。 ;）
Sorry for the delay in replying, I was tied up all day in Admin duties. Too many hats. ;)
感谢Mary的回复，我一定会改变默认的开放模式
1。如果数据库位于共享驱动器上，我应该给它们什么（前端明智）
Thanks for the response Mary, I will definitely change the default open mode
1.If the DB lies on shared drive what exactly do I give to them (front-end wise)
这样想。您从一个数据库foo.mdb开始。在做任何事之前备份它。现在将所有表复制到一个新数据库中并将其命名为foo_BE.mdb并将其保存在共享驱动器上的最终安装位置。然后从foo.mdb中删除所有表并转到文件 - 获取外部数据 - 将打开链接文件和文件打开窗口。从共享驱动器上的位置选择foo_BE.mdb文件，将打开一个向导。这将允许您选择所有表并将它们链接到foo.mdb。你现在有一个后端和一个前端。现在备份前端文件foo.mdb（这非常重要，因为我们即将创建的文件无法编辑）。
现在打开foo.mdb并确保所有您的启动选项设置为您想要的方式。请务必取消选中Show database window选项。
转到工具 - 选项，然后单击高级选项卡。将默认打开模式设置为共享，将默认记录锁定设置为已编辑记录。这将解决您描述的错误。
一旦您满意，请转到工具 - 数据库实用程序 - 制作一个mde。这将创建一个无法编辑的foo.mde文件。这就是你向用户发出的问题。
Think of it this way. You start out with one database foo.mdb. Back it up before doing anything. Now copy all the tables into a new database and call it foo_BE.mdb and save it in its final resting place on the shared drive. Then delete all the tables from foo.mdb and go to file - get external data - Link files and a file open window will open. Select the foo_BE.mdb file from it''s position on the shared drive and a wizard will open. This will allow you to select all the tables and link them into foo.mdb. You now have a backend and a frontend. Now backup the frontend file foo.mdb (this is very important as the file we are about to create can''t be edited).
Now open foo.mdb and make sure all your startup options are set to how you want them. Be sure to Uncheck the Show database window option.
Go to Tools - options and click on the advanced tab. Set the Default open mode to shared and the Default Record locking to edited record. This will resolve the errors you are describing.
Once you are happy go to Tools - Database Utilities - make an mde. This will create a foo.mde file which will be uneditable. This is what you issue to users.
2.当你说每个人都得到一个副本时，这意味着我必须将一个本地副本放到他们的实际工作站？
2.When you say everyone gets a copy does that mean I have to put a local copy onto their actual workstations?
你不必在共享驱动器上只有一个副本。
You don''t have to you can just have one copy on the shared drive.
3.如果我将本地副本放到他们的工作站上，数据库如何知道更新到后端。
3.If I put a local copy onto their workstations how does the DB know to update to the back-end.
因为你在特定路径上创建了一个指向后端的链接，所以只要foo_BE.mdb没有移动，前端就能找到它。 br />
Because you created a link to the backend on a specific path so as long as foo_BE.mdb doesn''t move the frontend will be able to find it.
另外，顺便说一下，DB实际上是他们输入信息的表格集合，但我真的看不出差别数据库和电子表格之间，他们不运行查询，没有任何代码与任何表格相关联，表格甚至没有链接？
Also, by the way it looks the DB is actually a collection of forms which they enter info into, but I can''t really see the difference between the DB and a spreadsheet, they don''t run queries, there is no code associated with any of the forms, and the forms are''nt even linked???
LOL - 老实说，如果没有看到它就不能发表评论，但我已经看到了一些有趣的设计。
Mary
LOL - honestly can''t comment without seeing it but I''ve seen some interesting designs in my time.
Mary
这篇关于拆分数据库，如何部署“前端”？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
