共享Access数据库的位置 [英] Location for shared Access database
问题描述
嗨新闻组！
任何人都可以告诉我在哪里放一个简单的Access数据库文件
命令可以访问网络中的每台计算机（同样
工作组）？不需要任何保护（我听说有人说
我应该购买一台专用服务器或者每个用户都有特殊权利和
每个用户，但我可以保留它很简单，因为没有入侵者 -
没有互联网连接 - ）。
我不认为程序文件夹是正确的位置。
我应该只在主硬盘上放置一个文件夹，例如
" C：\ MySharedDatabaseFolder"？
这也适用于Vista吗？
欢迎任何帮助!!
感谢您的回复，
埃尔顿。
Hi newsgroup!
Can anyone tell me where I should put a simple Access database file in
order to be accessible for every computer in the network (same
workgroup)? There does not need to be any protection (I heard people say
that I should buy a dedicated server or have special rights for each and
every user, but I can keep it simple since there will be no intruders -
no internet connection available -).
I don''t think that the "Programs" folder is the right place.
Should I just place a folder on the primary hard disk, like
"C:\MySharedDatabaseFolder"?
Would that work on Vista, too?
Any help is welcome!!
Thank you for your reply,
Elton.
推荐答案
" Elton Cohen" < el ********* @ gmail.comwrote in message
news：eD ************* @ TK2MSFTNGP02.phx.gbl .. 。
"Elton Cohen" <el*********@gmail.comwrote in message
news:eD*************@TK2MSFTNGP02.phx.gbl...
嗨新闻组！
谁能告诉我在哪里放一个简单的Access数据库文件
命令可以访问网络中的每台计算机（同一个工作组）？
不需要任何保护（我听说有人说我应该
购买专用服务器或拥有每个用户的特殊权利，但
我可以保持简单，因为没有入侵者 - 没有互联网
连接可用 - ） 。
我不认为程序文件夹是正确的位置。
我应该只在主硬盘上放置一个文件夹，例如
" C：\ MySharedDatabaseFolder"？
这也适用于Vista吗？
Hi newsgroup!
Can anyone tell me where I should put a simple Access database file in
order to be accessible for every computer in the network (same workgroup)?
There does not need to be any protection (I heard people say that I should
buy a dedicated server or have special rights for each and every user, but
I can keep it simple since there will be no intruders - no internet
connection available -).
I don''t think that the "Programs" folder is the right place.
Should I just place a folder on the primary hard disk, like
"C:\MySharedDatabaseFolder"?
Would that work on Vista, too?
网络共享访问数据库的正确位置是
c： \
The correct location for a network-shared access database is
c:\
Recycle.Bin。
对于网络共享数据库，请改用SQL Server：
SQL Server Express Edition（免费）
http://msdn.microsoft.com/vstudio/ex...r/default.aspx
用于访问的SQL Server迁移助手（SSMA访问）
http://www.microsoft.com /sql/solutio...s/default.mspx
然而，如果那不是一个选项那么
C：\\ \\MySharedDatabaseFo lder
很好。您还需要在该文件夹上添加共享，并授予
网络用户读写访问权限。这也适用于Vista，虽然
你需要调整本地文件夹权限，因为用户没有
对c：\的写权限默认情况下。
请记住，在创建共享时，必须设置两个级别的权限
：共享级权限和文件夹级权限。
如果您的用户不在域中，那么您必须在共享计算机上创建本地
帐户，其用户名和密码匹配
用户工作站上使用的
。
David
Recycle.Bin.
For a network-shared database, use SQL Server instead:
SQL Server Express Edition (free)
http://msdn.microsoft.com/vstudio/ex...r/default.aspx
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutio...s/default.mspx
However, if that''s not an option then
C:\MySharedDatabaseFolder
is good. You will also need to add a share on that folder, and grant
network users read write access. This will work on Vista as well, although
you''ll need to adjust the local folder permissions since users don''t have
write permissions on c:\ by default.
Remember when creating a share, there are two levels of permissions that
both must be set: share-level permissions and folder-level permissions.
If your users aren''t in a domain, then you will have to create local
accounts on the shared computer with usernames and passwords matching the
ones used on the users'' workstations.
David
我认为SQLServer Express数据库不允许股票价格为b $ b;我以为它们只是一次性使用。这不是真的吗？
Robin S.
---------------------- -----
" David Browne" < davidbaxterbrowne没有盆栽 me**@hotmail.com 写在
消息新闻：ey **** ********** @ TK2MSFTNGP02.phx.gbl ...
I thought SQLServer Express databases were not permitted to be
on shares; I thought they were single-use only. Is that not true?
Robin S.
---------------------------
"David Browne" <davidbaxterbrowne no potted me**@hotmail.comwrote in
message news:ey**************@TK2MSFTNGP02.phx.gbl...
>
" ;埃尔顿科恩 < el ********* @ gmail.comwrote in message
news：eD ************* @ TK2MSFTNGP02.phx.gbl .. 。
>
"Elton Cohen" <el*********@gmail.comwrote in message
news:eD*************@TK2MSFTNGP02.phx.gbl...
>嗨新闻组！
任何人都可以告诉我在哪里放一个简单的Access数据库文件
命令可以访问网络中的每台计算机（相同的工作组）？不需要任何保护（我听说有人说我应该购买专用服务器或者每个用户都有特殊权利，但是我可以保持简单，因为没有入侵者 -
没有互联网连接 - ）。
我不认为程序文件夹是正确的位置。
我应该只在主硬盘上放置一个文件夹，例如
C：\ MySharedDatabaseFolder？
是否适用于Vista，是吗？
>Hi newsgroup!
Can anyone tell me where I should put a simple Access database file in
order to be accessible for every computer in the network (same
workgroup)? There does not need to be any protection (I heard people say
that I should buy a dedicated server or have special rights for each and
every user, but I can keep it simple since there will be no intruders -
no internet connection available -).
I don''t think that the "Programs" folder is the right place.
Should I just place a folder on the primary hard disk, like
"C:\MySharedDatabaseFolder"?
Would that work on Vista, too?
网络共享访问数据库的正确位置是
c：\
The correct location for a network-shared access database is
c:\
这篇关于共享Access数据库的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
