无法从A2003访问文件夹 [英] Unable to access folder from A2003

问题描述

使用A2003，我无法访问另一台

计算机上的文件夹中的文件，其中包含后端文件，更新文件等。这是

场景：


1）计算机＃1 - A2003

2）计算机＃2 - Access 2000 ;两个计算机的后端文件夹和

''更新''文件夹。


我有一个启动我的应用程序（MyApp）的启动程序。发射器

程序还检查位于更新文件夹中的MyApp的更新（在
计算机＃2上）。如果更新文件夹中有更新文件，

启动程序会打开DAO记录集并获取版本号。

如果版本号更新文件夹中的MyApp高于计算机＃1上MyApp的

版本号，然后更新文件夹中的MyApp为

下载并替换计算机＃1上的MyApp。


所有这些代码都可以正常工作。问题是在计算机＃1（A2003）上，

我在更新文件夹中访问MyApp时遇到问题。我保持

收到更新文件夹中的MyApp已经打开的消息

。我100％确定它没有打开，并且没有.ldb文件。


但是，如果我在计算机＃2上创建一个新文件夹（''NewFolder''），

更新文件夹所在的位置，然后将''更新''文件夹中的MyApp复制到

''NewFolder''，然后重置启动程序中的位置在计算机上

＃1到''NewFolder''（启动程序搜索更新的地方），

一切正常。没有更多的排他性错误。


我之前见过这个。这就像计算机＃2上的文件夹中的文件某种方式
现在可以通过A2003更长时间访问
（我从来没有遇到过A2K的这个问题）。


现在我只需使用Windows资源管理器在计算机＃2

上创建一个新文件夹并将文件复制到其中即可解决问题。然后我可以删除

旧文件夹并使用旧文件夹名称重命名新文件夹。但客户

不想这样做。


导致这个问题的原因是什么？我没有对Windows文件夹做任何事情

权限。两台电脑都运行Windows XP家庭版。


感谢您的任何想法，建议等。


-

通过AccessMonster.com发布的消息
http://www.accessmonster.com/Uwe/For...ccess/200605/1

解决方案

一旦确认您拥有当前的前端，您的启动程序用于打开Access和

数据库的命令行是什么？是否

默认情况下，在共享模式下设置为打开的所有计算机上的访问权限

（工具|选项|高级选项卡）？限制用户数量的共享

文件夹是否有任何限制？前端，后端或

工作组（mdw）文件是否具有相同的名称的第一部分（即

MyDatabase.mdw，MyDatabase.mdb） ？


-

Wayne Morgan

MS Access MVP

" rdemyan来自AccessMonster。 COM" < u6836 @乌韦>在消息中写道

news：60a244275175c @ uwe ...

使用A2003，我无法访问另一台
计算机上的文件夹中的文件找到了--end文件，更新文件等。这是
情景：

1）计算机＃1 - A2003
2）计算机＃2 - Access 2000;两个计算机的后端文件夹和
''更新''文件夹。

我有一个启动我的应用程序（MyApp）的启动程序。
启动程序
程序还会检查位于更新文件夹（位于计算机＃2上）的MyApp的更新。如果更新文件夹中有更新文件，
启动程序会打开DAO记录集并获取版本号
如果MyApp的版本号在更新文件夹高于计算机＃1上MyApp的版本号，然后下载更新文件夹中的MyApp，并替换计算机＃1上的MyApp 。

所有这些代码都运行正常。问题是在计算机＃1（A2003）上，我在更新文件夹中访问MyApp时遇到了问题。我保持
收到一条消息，'更新''文件夹中的'MyApp''已经打开了
。我100％确定它没有打开，并且没有.ldb
文件。

但是，如果我在计算机＃2上创建一个新文件夹（''NewFolder''），
更新文件夹所在的位置，然后将''更新''文件夹中的MyApp复制到
''NewFolder''，然后重置
计算机上启动程序的位置
＃1到''NewFolder''（启动程序搜索更新的地方），
一切正常。没有更多的排他性错误。

我之前见过这个。这就像计算机＃2上的文件夹中的文件一样，现在A2003可以更长时间地访问它（我从来没有遇到A2K的这个问题）。

现在我可以只需使用Windows资源管理器在计算机＃2上创建一个新文件夹并将文件复制到其中即可解决问题。然后我可以删除
旧文件夹并使用旧文件夹名称重命名新文件夹。但
客户
并不想这样做。

是什么导致了这个问题？我没有对Windows
文件夹
权限做任何事情。两台计算机都运行Windows XP家庭版。

感谢您提出任何想法，建议等。

-
通过AccessMonster.com发布的消息
http：//www.accessmonster。 com / Uwe / For ... ccess / 200605/1 / / blockquote>

感谢您的回复：


1）不确定为什么启动MyApp的命令行（位于

本地计算机上的文件夹中）是一个问题。发射器在启动

MyApp程序时没有遇到任何问题。这是在同行计算机上打开MyApp更新文件

这就是问题所在。继续获得排他性问题。


但是：我查看了A2000和A2003之间的

（工具|选项|高级选项卡）中显示的命令行参数。它们是不同的。

当我启动MyApp时，我传递了一些信息，包括

后端文件的位置，工作组文件和一些告诉MyApp的布尔变量

连接到什么以及工作组文件的位置（我需要工作组文件

，因为MyApp也可以启动其他受工作组保护的文件。但是，A2003，

只在命令行参数中显示工作组文件!! ??


另一个区别是DDE操作.A2003有''启用DDE刷新''br />
而A2K没有检查任何东西。


但是，我遇到的问题是在启动程序中而不是MyApp一次它

打开。


2）是所有计算机上的访问权限设置为在共享模式下打开。


3）说实话，我不知道甚至不知道如何在Windows XP Home Edition中对共享文件夹设置限制

。任何对等计算机上的Windows资源管理器

可以看到位于计算机＃2上的更新文件夹（以及其中的文件）。

只有一个用户现在，所以我不确定这是不是问题。


4）所有文件都有不同的名称。


全部我最终得到这个工作是在计算机上创建一个新文件夹

＃2（作为服务器）并复制位于''更新''的文件

文件夹（这是给我的问题）到NewFolder。然后我将计算机＃1上的启动器上的

文件夹位置从更新更改为NewFolder和

一切正常!! ??


这可能是A2003问题。 A2000从未表现出这个问题。


Wayne Morgan写道：

你的启动程序用来打开Access的命令行是什么？
数据库一旦确定你有当前的前端？是否将所有设置为共享模式下打开的计算机上的访问权限作为默认设置
（工具|选项|高级选项卡）？限制用户数量的共享
文件夹是否有任何限制？前端，后端或
工作组（mdw）文件的名称的第一部分是否相同（即
MyDatabase.mdw，MyDatabase.mdb）？

使用A2003，我在访问后端文件，更新文件等所在的另一台计算机上的文件夹时遇到问题。这里是

[引用文字剪辑 - 44行]

感谢您提出任何想法，建议等。

-

留言通过 http://www.accessmonster.com

好的，只是为了澄清，您是否在复制更新的文件时遇到问题或

一旦你确定你拥有最新的文件就打开你的应用程序吗？


命令行会产生影响，特别是如果它有/ excl

开启它。这将独占打开文件。你在哪里查看

选项不是我指的。我指的是用于打开你的应用程序的命令行

。它将类似于：


"< path> \ msaccess.exe" "<路径> \MyDatabase.mdb" / wrkrgp

"< path> \ MyWorkgroup.mdw" / user UserName / pwd密码


如果先不使用更新程序打开应用程序会发生什么情况，

问题会消失吗？我怀疑更新程序正在锁定文件以获得一些原因。

-

Wayne Morgan

MS Access MVP

" rdemyan via AccessMonster.com" < u6836 @乌韦>在消息中写道

news：60a30d52ce523 @ uwe ...

感谢您的回复：

1）不确定为什么启动命令行MyApp（位于
本地计算机上的文件夹中）是一个问题。启动器没有启动
MyApp程序的问题。这是在同行计算机上打开MyApp更新文件
这就是问题所在。继续获得排他性问题。

但是：我查看了A2000和A2003之间
（工具|选项|高级选项卡）中显示的命令行参数。它们是不同的。
当我启动MyApp时，我传递了一些信息，包括
后端文件的位置，工作组文件和一些告诉
MyApp的布尔变量
连接到什么以及工作组文件的位置（我需要工作组
文件
因为MyApp也可以启动其他受工作组保护的文件。
A2003，然而，
只显示命令行参数中的工作组文件!! ??

另一个区别是DDE操作.A2003有''启用DDE
刷新''
而A2K没有检查。

但是，我遇到的问题是在发布程序中没有MyApp一次
它打开。

2）是所有计算机上的访问权限设置为在共享模式下打开。

3）老实说，我甚至不知道如何设置对共享
文件夹的限制
Windows XP家庭版。任何对等计算机上的Windows资源管理器都可以看到位于计算机＃2上的更新文件夹（以及其中的文件）。
现在只有一个用户，所以我''我不确定这是不是问题。

4）所有文件都有不同的名称。

我所做的最终让它工作的是在计算机
＃2（充当服务器）并将位于
''更新''
文件夹中的文件（给我问题）复制到NewFolder。然后我将计算机＃1上的启动器上的
文件夹位置从更新
更改为NewFolder
一切正常!! ??

可以这是一个A2003问题。 A2000从未表现出这个问题。

Wayne Morgan写道：

你的启动程序使用什么命令行来打开Access
和
数据库一旦确定你有当前的前端？是否将所有设置为共享模式下打开的计算机上的访问权限作为默认设置
（工具|选项|高级选项卡）？限制用户数量的共享
文件夹是否有任何限制？前端，后端或
工作组（mdw）文件的名称的第一部分是否相同（即
MyDatabase.mdw，MyDatabase.mdb）？

使用A2003，我在访问后端文件，更新文件等所在的另一台计算机上的文件夹时遇到问题。这里是

[引用文字剪辑 - 44行]

感谢您提出任何想法，建议等。

-
通过 http： //www.accessmonster.com

With A2003, I''m having trouble accessing files in a folder on another
computer where back-end files, update files, etc are located. Here''s the
scenario:

1) Computer #1 - A2003
2) Computer #2 - Access 2000; folder with back-ends for both computers and
''Update'' folder.

I have a launcher program that launces my application (MyApp). The launcher
program also checks for updates to MyApp located in ''Update'' folder (on
Computer #2). If there is an update file in the ''Update'' folder, the
launcher program opens it with a DAO recordset and gets the version number.
If the version number of MyApp in the ''Update'' folder is higher than the
version number of MyApp on Computer #1, then MyApp in the ''Update'' folder is
downloaded and replaces MyApp on Computer #1.

All of this code works fine. The problem is that on Computer #1 (A2003),
I''ve been having problems accessing MyApp in the ''Update'' folder. I keep
getting a message that ''MyApp'' in the ''Update'' folder is already opened
exclusively. I am 100% sure that it is not open and there is no .ldb file.

HOWEVER, if I create a new folder (''NewFolder'') on Computer #2, where the
Update folder is located, then copy MyApp in the ''Update'' folder to
''NewFolder'', and then reset the location on the launching program on Computer
#1 to ''NewFolder'' (where the launching program searches for updates),
everything works fine. No more exclusivity errors.

I''ve seen this before. It''s like files in the folder on Computer #2 somehow
can now longer be accessed by A2003 (I never have this problem with A2K).

Now I can solve the problem simply by creating a new folder on Computer #2
using Windows Explorer and copying the files into it. Then I can delete the
old folder and rename the new folder with the old folder name. But clients
aren''t going to want to do this.

What is causing this problem??? I''m not doing anything with Windows folders
permissions. Both computers run Windows XP home editions.

Thank you for any ideas, suggestions,etc.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1

解决方案

What is the command line that your launcher program uses to open Access and
the database once it is assured that you have the current front-end? Is
Access on all computers set to open in Shared mode as a default
(Tools|Options|Advanced tab)? Are there any restrictions on the shared
folder limiting the number of users? Do the front-end, back-end, or
workgroup (mdw) file have the same first part of their name (i.e.
MyDatabase.mdw, MyDatabase.mdb)?

--
Wayne Morgan
MS Access MVP
"rdemyan via AccessMonster.com" <u6836@uwe> wrote in message
news:60a244275175c@uwe...

With A2003, I''m having trouble accessing files in a folder on another
computer where back-end files, update files, etc are located. Here''s the
scenario:

1) Computer #1 - A2003
2) Computer #2 - Access 2000; folder with back-ends for both computers and
''Update'' folder.

I have a launcher program that launces my application (MyApp). The
launcher
program also checks for updates to MyApp located in ''Update'' folder (on
Computer #2). If there is an update file in the ''Update'' folder, the
launcher program opens it with a DAO recordset and gets the version
number.
If the version number of MyApp in the ''Update'' folder is higher than the
version number of MyApp on Computer #1, then MyApp in the ''Update'' folder
is
downloaded and replaces MyApp on Computer #1.

All of this code works fine. The problem is that on Computer #1 (A2003),
I''ve been having problems accessing MyApp in the ''Update'' folder. I keep
getting a message that ''MyApp'' in the ''Update'' folder is already opened
exclusively. I am 100% sure that it is not open and there is no .ldb
file.

HOWEVER, if I create a new folder (''NewFolder'') on Computer #2, where the
Update folder is located, then copy MyApp in the ''Update'' folder to
''NewFolder'', and then reset the location on the launching program on
Computer
#1 to ''NewFolder'' (where the launching program searches for updates),
everything works fine. No more exclusivity errors.

I''ve seen this before. It''s like files in the folder on Computer #2
somehow
can now longer be accessed by A2003 (I never have this problem with A2K).

Now I can solve the problem simply by creating a new folder on Computer #2
using Windows Explorer and copying the files into it. Then I can delete
the
old folder and rename the new folder with the old folder name. But
clients
aren''t going to want to do this.

What is causing this problem??? I''m not doing anything with Windows
folders
permissions. Both computers run Windows XP home editions.

Thank you for any ideas, suggestions,etc.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1

Thanks for the response:

1) Not sure why the command line to launch MyApp (located in a folder on the
local computer) is an issue. The launcher has not had problems launching the
MyApp program. It''s the opening of MyApp update file on the peer computer
that is the issue. Keep getting exclusivity problems.

HOWEVER: I looked at the command-line arguments shown in the
(Tools|Options|Advanced tab) between A2000 and A2003. THEY ARE DIFFERENT.
When I launch MyApp, I pass in some information including the location of the
back-end files, the workgroup file and some boolean variables that tell MyApp
what to connect to and where the workgroup file is (I need the workgroup file
because MyApp also can launch other workgroup protected files. A2003,however,
only shows the workgroup file in the Command-line argument!!??

One other difference is the DDE operations. A2003 has ''Enable DDE Refresh''
while A2K has nothing checked.

BUT, the problem I''m having is within the launching program not MyApp once it
opens.

2) Yes Access on all computers is set to open in Shared mode.

3) To be honest, I don''t even know how to set restrictions on shared folders
in Windows XP Home Edition. Windows Explorer on any of the peer computers
can see the ''Update'' folder (and files within) located on Computer #2.
There''s only one user right now, so I''m not sure that would be the issue.

4) All files have different names.

All I did to eventually get this to work was create a new folder on Computer
#2 (which is acting as the server) and copy the files located in the ''Update''
folder (which is giving me the problems) to the NewFolder. Then I change the
folder location on the launcher on Computer #1 to NewFolder from Update and
everything works fine!!??

Could this be an A2003 problem. A2000 has never exhibited this problem.

Wayne Morgan wrote:

What is the command line that your launcher program uses to open Access and
the database once it is assured that you have the current front-end? Is
Access on all computers set to open in Shared mode as a default
(Tools|Options|Advanced tab)? Are there any restrictions on the shared
folder limiting the number of users? Do the front-end, back-end, or
workgroup (mdw) file have the same first part of their name (i.e.
MyDatabase.mdw, MyDatabase.mdb)?

With A2003, I''m having trouble accessing files in a folder on another
computer where back-end files, update files, etc are located. Here''s the

[quoted text clipped - 44 lines]

Thank you for any ideas, suggestions,etc.

--
Message posted via http://www.accessmonster.com

Ok, just to clarify, are you having problems copying the updated file or
opening your app once you''ve made sure that you have the most current file?

The command line will make a difference, especially if it has the /excl
switch on it. This opens the file exclusively. Where you looks in the
Options isn''t what I was referring to. I was referring to the command line
used to open your app. It would be something like:

"<path>\msaccess.exe" "<path>\MyDatabase.mdb" /wrkrgp
"<path>\MyWorkgroup.mdw" /user UserName /pwd Password

What happens if you open the app without using the updater first, do the
problems go away? I suspect that the updater is locking the file for some
reason.

--
Wayne Morgan
MS Access MVP
"rdemyan via AccessMonster.com" <u6836@uwe> wrote in message
news:60a30d52ce523@uwe...

Thanks for the response:

1) Not sure why the command line to launch MyApp (located in a folder on
the
local computer) is an issue. The launcher has not had problems launching
the
MyApp program. It''s the opening of MyApp update file on the peer computer
that is the issue. Keep getting exclusivity problems.

HOWEVER: I looked at the command-line arguments shown in the
(Tools|Options|Advanced tab) between A2000 and A2003. THEY ARE DIFFERENT.
When I launch MyApp, I pass in some information including the location of
the
back-end files, the workgroup file and some boolean variables that tell
MyApp
what to connect to and where the workgroup file is (I need the workgroup
file
because MyApp also can launch other workgroup protected files.
A2003,however,
only shows the workgroup file in the Command-line argument!!??

One other difference is the DDE operations. A2003 has ''Enable DDE
Refresh''
while A2K has nothing checked.

BUT, the problem I''m having is within the launching program not MyApp once
it
opens.

2) Yes Access on all computers is set to open in Shared mode.

3) To be honest, I don''t even know how to set restrictions on shared
folders
in Windows XP Home Edition. Windows Explorer on any of the peer computers
can see the ''Update'' folder (and files within) located on Computer #2.
There''s only one user right now, so I''m not sure that would be the issue.

4) All files have different names.

All I did to eventually get this to work was create a new folder on
Computer
#2 (which is acting as the server) and copy the files located in the
''Update''
folder (which is giving me the problems) to the NewFolder. Then I change
the
folder location on the launcher on Computer #1 to NewFolder from Update
and
everything works fine!!??

Could this be an A2003 problem. A2000 has never exhibited this problem.

Wayne Morgan wrote:

What is the command line that your launcher program uses to open Access
and
the database once it is assured that you have the current front-end? Is
Access on all computers set to open in Shared mode as a default
(Tools|Options|Advanced tab)? Are there any restrictions on the shared
folder limiting the number of users? Do the front-end, back-end, or
workgroup (mdw) file have the same first part of their name (i.e.
MyDatabase.mdw, MyDatabase.mdb)?

With A2003, I''m having trouble accessing files in a folder on another
computer where back-end files, update files, etc are located. Here''s
the

[quoted text clipped - 44 lines]

Thank you for any ideas, suggestions,etc.

--
Message posted via http://www.accessmonster.com

这篇关于无法从A2003访问文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！