MS Access数据库网络路径 [英] MS Access Database Network Path
问题描述
我的服务器上有一些MDB（MS Access 2000）文件。这是我们的员工很久以前创建的小型应用程序。我看到这个
应用程序在网络驱动器G：和H :(两个驱动器都有相同的
数据库，我不知道为什么）。当用户访问此应用程序时，
从H：驱动器打开Timecard.MDB。 （当我断开电脑连接时
网络我收到错误，说找不到H：驱动器）。
我已将所有这些MDB复制到我的XP计算机在我当地的C：\ Agent.
文件夹中，当我尝试打开它时让我访问数据库但是当我从网络上断开计算机时再次获得
得到消息说
磁盘或网络错误。有人可以帮助我如何改变从B：到C：的
MDB应用程序的路径。
谢谢，
Mukesh
Hi,
I have some MDB (MS Access 2000) files on our server. It is small
application created by one of our employee long time ago. I see this
application is on Network Drive G: and H: (both drive has same
databases, I don''t know why). When user accesses this aplication it
opens Timecard.MDB from H: drive. (when I disconnect computer from
Network I get error saying couldn''t find H: Drive).
I have copied all these MDBs to my XP computer on my local C:\AccessDB
folder, when I try to open it opens and let me access the Database but
again when I disconnect my computer from network I get message saying
"Disk or Network Error". Can somebody help me how to change the path of
MDB application from H: to C:.
Thanks,
Mukesh
推荐答案
使用Access应用程序的路径并不神奇。该路径将包含在桌面快捷方式中，或者如果您使用
方法，或者在您双击<的文件夹中确定，则在命令行中包含 br />
申请。
我想，如果
你是唯一的用户，我可以使用隐含的工作组文件，并且本来是在驱动器H：上创建的，但是你
没有删除权限？无论如何，假设您可以访问MDB
来源，您可以获得第三方工具，例如Find&替换（来自
www.rickworld.com ）或Speed Ferret（来自 www.moshannon.com ）并搜索
看看你是否找到了 ; H："数据库中编码。
Larry Linson
Microsoft Access MVP
< mu ***** *******@gmail.com>在消息中写道
news：11 ********************** @ g10g2000cwb.googlegr oups.com ...
It''s not magic which path to use for an Access application. The path will be
contained in the desktop shortcut, or in your command line if you use that
approach, or determined from the folder in which you double-click the
application.
It is possible, I suppose, that the implied workgroup file is not used if
you are the only user, and would have been created on drive H:, but you
don''t have delete permissions? Anyway, assuming you have access to the MDB
source, you can get a third party tool such as Find & Replace (from
www.rickworld.com) or Speed Ferret (from www.moshannon.com) and search to
see if you find "H:" coded in the database.
Larry Linson
Microsoft Access MVP
<mu************@gmail.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...
我的服务器上有一些MDB（MS Access 2000）文件。这是我们的员工很久以前创建的小型应用程序。我看到这个
应用程序在网络驱动器G：和H：（两个驱动器都有相同的数据库，我不知道为什么）。当用户访问此应用程序时，它将从H：驱动器打开Timecard.MDB。 （当我从网络断开计算机时，我得到错误，说找不到H：驱动器）。
我已将所有这些MDB复制到我当地C：\上的XP计算机上AccessDB
文件夹，当我尝试打开它时让我访问数据库但是当我从网络断开计算机时再次打开我收到消息说磁盘或网络错误。有人可以帮助我如何将MDB应用程序的路径从H：改为C :.
谢谢，
Mukesh
Hi,
I have some MDB (MS Access 2000) files on our server. It is small
application created by one of our employee long time ago. I see this
application is on Network Drive G: and H: (both drive has same
databases, I don''t know why). When user accesses this aplication it
opens Timecard.MDB from H: drive. (when I disconnect computer from
Network I get error saying couldn''t find H: Drive).
I have copied all these MDBs to my XP computer on my local C:\AccessDB
folder, when I try to open it opens and let me access the Database but
again when I disconnect my computer from network I get message saying
"Disk or Network Error". Can somebody help me how to change the path of
MDB application from H: to C:.
Thanks,
Mukesh
谢谢Larry。
我可以完全访问数据库，但我不知道如何更改路径以便
每次我在本地计算机上访问此数据库都可以访问，而不需要
网络连接。
Mukesh
Thanks Larry.
I am have full access to DB but I don''t how to change the path so that
each time I access this DB on my local computer can have access without
network conenctivity.
Mukesh
嗨拉里，
我想从G：更改为C：驱动器：显示G：\SH Data.MDB。可以
你请指导如何改变这个。我不擅长Access但是
对MS Access知之甚少。
C：\ Access DBs \TIMECARD.mdb
（星期三，2006年5月10日）
表：TBL_TIMECARD
页数：1
属性
属性：Linked Connect：
; DATABASE = G：\ SH DATA.mdb
创建日期：7/12/2002 3 ：35：36 PM过滤器：
（（TBL_TIMECARD.WEEKENDDATE =＃8/2
0/2002＃））
GUID：长二进制数据最近更新：
1/21/2005 2:44:19 PM
NameMap：长二进制数据OrderBy：
TBL_TIMECARD.WEEKENDDATE DESC
OrderByOn：True Orientation：
0
RecordCount：-1来源表
名称：TBL_TIMECARD
可更新：错误
Hi Larry,
I want to change to C: drive from G: which shows G:\SH Data.MDB. Can
you please guide how to do change this. I am not good at Access but
knows little about MS Access.
C:\Access DBs\TIMECARD.mdb
Wednesday, May 10, 2006
Table: TBL_TIMECARD
Page: 1
Properties
Attributes: Linked Connect:
;DATABASE=G:\SH DATA.mdb
Date Created: 7/12/2002 3:35:36 PM Filter:
((TBL_TIMECARD.WEEKENDDATE=#8/2
0/2002#))
GUID: Long binary data Last Updated:
1/21/2005 2:44:19 PM
NameMap: Long binary data OrderBy:
TBL_TIMECARD.WEEKENDDATE DESC
OrderByOn: True Orientation:
0
RecordCount: -1 Source Table
Name: TBL_TIMECARD
Updatable: False
这篇关于MS Access数据库网络路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
