通过网络共享Access数据库 [英] Sharing a Access Database over a network
问题描述
我创建了一个数据库，它由两个人使用。他们很少需要同时访问数据库。
我已将数据库创建为共享数据库。但他们无法同时打开它 - 虽然我可以打开数据库，如果其中一个在其中。
这与网络权限有关吗？我听说过将数据库拆分为前端和后端，但之前从未实际做过（我是自学新手......我一边学习!!!）。
是有一个简单的解决方案吗？如果我需要分割数据库，有人可以提供一步一步的说明，即使我能理解它们也是如此简单！ LOL
我在Office 2000上运行...在办公室里不是最新的!!!
非常感谢
Lucy
是的，你需要拆分数据库。我使用Office 2003，但我相信它离办公室2000不远。
拆分数据库：
- 打开数据库到拆分
- 找到顶部的工具菜单
- 选择数据库实用工具
- 选择数据库拆分器
- 点击拆分数据库
- 选择后端的位置。文件。
后端（BE）是你所有桌子的所在。
你的前端（FE）是用户界面，包含您的表单，查询和VBA。它本质上是你的应用程序。
后端纯粹用于存储前端操作/创建/删除等所有数据。
- 如果为后端选择了足够的位置，请单击拆分。这通常是服务器上的共享驱动器，所有使用前端的用户都可以访问。
然后向导将拆分数据库。
您将在应用程序中注意到数据库窗口中保存的表现在都是链接的。表。那就是他们指向你的后端。
您可以将前端文件复制并分发给需要访问权限的人。每个需要访问数据库的人都需要拥有自己独立的前端副本。如果你让每个人都使用相同的前端，你会遇到和现在一样的问题。
你可以复制前端给用户发电子邮件或者你可以使用发行版这个程序比如AUTO FE更新程序（google it;）），它会更加可管理。
任何其他问题让我知道。
你好。虽然按照Munkee的建议拆分数据库确实是一个非常好的主意，但是你的单个共享数据库仍然应该由双方使用数据库打开并且可以更新。
两个人都必须阅读并且写入权限，以便共享任何网络区域。如果没有此Access，则无法创建其锁定文件，您应该看到该文件在打开Access数据库时出现在存储数据库的目录中。锁定文件与数据库同名，但扩展名为 .ldb 。如果在打开数据库时存在锁定文件，那么您将需要进一步调查它未被共享的原因。如果由于权限问题而没有锁定文件，则无法共享数据库。
-Stewart
感谢您的回复。当某人在数据库中时，您可以看到这是一个锁文件被创建，但仍然只有我可以访问数据库，如果其他人在其中...让我有点困惑。
我按照Munkee给出的步骤和欢乐的喜悦分离数据库的向导没有安装...我会看看我是否可以安装然后获取数据库拆分：o）
任何人都可以推荐一个很好的兼职晚间课程，我可以采取实际了解访问数据库...没有太基本但足够我可以创建和管理真的很好数据库？
I have created a database and it is used by two people. They rarely need to access the database at the same time.
I have created the Database as "Shared" but they are unable to open it at the same time - although I can open the database if one of them are in it.
Is this something to do with the network permissions? I have heard about splitting databases into front end and back end but have never actually done this before (I am self taught novice...learning as I go!!!).
Is there a simple solution to this? If I need to split the database can someone provide step by step instructions that are so simple even I can understand them!! LOL
I operate on Office 2000...not very up to date in our office!!!
many thanks
Lucy
Yes you need to split the database. I use office 2003 but I am sure it wont be far from office 2000.
To split the database:
- Open the database to split
- Locate the tools menu at the top
- Select Database Utilities
- Select Database Splitter
- Click Split Database
- Select a location for your "back end" file.
The back end (BE) is where all of your tables will be held.
Your front end (FE) is the user interface which houses your forms, queries and VBA. It is in essence your application.
The back end is purely for storing all of the data that your front end manipulates/creates/deletes etc.
- Click Split when you have selected an adequate location for your back end to be held. This is usually a shared drive on a server where all users who use front ends have access to.
The wizard will then split the database.
You will notice in your application the tables held within the database window are now all "linked" tables. That is they are pointing to your back end.
You can copy and distribute out the front end file to whoever needs access. Each person who requires access to the database needs to have their own seperate copy of the front end. If you had everyone using the same front end you would be in the same problem as you are now.
You can just copy and email the front end to users or you can use a distribution program such as AUTO FE Updater ( google it ;) ) which will be a bit more managable.
Any other issues let me know.
Hi. Although it is indeed a very good idea to split the database as Munkee suggests, your single shared database should still open and be updateable by both parties using the database.
Both persons must have read and write permissions to whatever network area is being shared. Without this Access cannot create its lock file which you should see appear in the directory in which your database is stored when you open the Access database. The lock file has the same name as the database but with the extension .ldb. If there is a lock file present when you open the database then you''ll need to investigate further why it is not being shared. If there is no lockfile as a result of permissions problems then the database cannot be shared.
-Stewart
Thanks for the responses. When someone is in the database you can see this as a lockfile is created, but still only I can access the database if someone else is in it..confusing me somewhat.
I went to follow the steps given by Munkee and joy of joys the Wizard for splitting databases isn''t installed...I will see if I can install and then get the database split :o)
Can anyone recommend a good part time evening course I could take to actually learn about access databases...nothing too basic but enough that I can create and manage really good databases?
这篇关于通过网络共享Access数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
