并发Web和直接访问Access DB [英] Concurrent Web- and direct access to an Access DB
问题描述
我正在设置一些查询Access数据库的基于Web的（ASP）报告。我还要
希望某些人能够直接访问和操作数据库
。
但是，如果数据库是在Access中打开，我无法通过ASP访问它：
Microsoft JET数据库引擎错误''80004005''
无法使用'''';文件已经在使用中。
无论如何，网络应用程序和直接访问用户可以和平地使用
共存吗？我知道Access在并发访问方面并不是很强大，但我认为
它应该至少能够处理这个...
谢谢
克里斯
I''m setting up some web-based (ASP) reports that query an Access DB. I also
want certain people to be able to access and manipulate the database
directly.
However, if the database is open in Access, I cant access it via ASP:
Microsoft JET Database Engine error ''80004005''
Could not use ''''; file already in use.
Is there anyway the web application and direct-access users can peacefully
coexist? I know Access isnt really strong on concurrent access, but I figure
it ought to at least be able to handle this...
Thanks
Chris
推荐答案
CJM写道：
我正在建立一些网络查询Access数据库的基于ASP的报告。
我也希望某些人能够直接访问和操作数据库。
但是，如果数据库是在Access中打开，我无法通过ASP访问它：
Microsoft JET数据库引擎错误''80004005''
无法使用'''';文件已经在使用中。
无论如何，网络应用程序和直接访问用户可以和平共存吗？我知道Access在并发访问方面并不是很强大，但我认为它应该至少能够处理这个...
I''m setting up some web-based (ASP) reports that query an Access DB.
I also want certain people to be able to access and manipulate the
database directly.
However, if the database is open in Access, I cant access it via ASP:
Microsoft JET Database Engine error ''80004005''
Could not use ''''; file already in use.
Is there anyway the web application and direct-access users can
peacefully coexist? I know Access isnt really strong on concurrent
access, but I figure it ought to at least be able to handle this...
这个涵盖在 http://www.aspfaq.com/show.asp?id= 2009 - 80004005错误
Jet数据库的所有用户都需要包含数据库的
文件夹的读/写（更改）权限。这包括IUSR帐户。
Bob Barrows
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。这个电子邮件帐户是我的垃圾邮件陷阱所以我
不经常检查它。如果您必须离线回复，请删除
无垃圾邮件
This IS covered at http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors
All users of a Jet database need read/write (Change) permissions for the
folder containing the database. This includes the IUSR account.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don''t check it very often. If you must reply off-line, then remove the
"NO SPAM"
" Bob巴罗斯[MVP]" <再****** @ NOyahoo.SPAMcom>在消息中写道
新闻：％2 **************** @ TK2MSFTNGP11.phx.gbl ...
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
CJM写道：
我正在设置一些基于Web的（ASP）报告来查询Access数据库。
我也希望某些人能够访问和操作
直接数据库。
但是，如果数据库在Access中打开，我无法通过ASP访问它：
Microsoft JET数据库引擎错误''80004005''
不能使用'''';文件已经在使用中。
无论如何，网络应用程序和直接访问用户可以和平共存吗？我知道Access在并发访问方面并不是很强大，但我认为它应该至少能够处理这个...
这是由 http://www.aspfaq.com/show.asp?id=2009 - 80004005
I''m setting up some web-based (ASP) reports that query an Access DB.
I also want certain people to be able to access and manipulate the
database directly.
However, if the database is open in Access, I cant access it via ASP:
Microsoft JET Database Engine error ''80004005''
Could not use ''''; file already in use.
Is there anyway the web application and direct-access users can
peacefully coexist? I know Access isnt really strong on concurrent
access, but I figure it ought to at least be able to handle this...
This IS covered at http://www.aspfaq.com/show.asp?id=2009 - 80004005
错误
Jet数据库的所有用户都需要对包含数据库的
文件夹的读/写（更改）权限。这包括IUSR账户。
鲍勃巴罗斯
errors
All users of a Jet database need read/write (Change) permissions for the
folder containing the database. This includes the IUSR account.
Bob Barrows
它已被覆盖，但它没有解决我的问题，因此我
张贴......
It IS covered, however, it DOESNT solve my problem, hence the reason I
posted...
CJM写道：
" Bob Barrows [MVP]" <再****** @ NOyahoo.SPAMcom>在消息中写道
新闻：％2 **************** @ TK2MSFTNGP11.phx.gbl ...
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
CJM写道：
我正在设置一些基于Web的（ASP）报告来查询Access数据库。
我也希望某些人能够直接访问和操作数据库。
但是，如果数据库在Access中打开，我无法通过ASP访问它：
Microsoft JET数据库引擎错误''80004005''
不能使用'''';文件已经在使用中。
无论如何，网络应用程序和直接访问用户可以和平共存吗？我知道Access在并发访问方面并不是很强大，但我认为它应该至少能够处理这个...
I''m setting up some web-based (ASP) reports that query an Access DB.
I also want certain people to be able to access and manipulate the
database directly.
However, if the database is open in Access, I cant access it via
ASP:
Microsoft JET Database Engine error ''80004005''
Could not use ''''; file already in use.
Is there anyway the web application and direct-access users can
peacefully coexist? I know Access isnt really strong on concurrent
access, but I figure it ought to at least be able to handle this...
这是在 http://www.aspfaq.com/show.asp?id=2009 - 80004005
错误
Jet数据库的所有用户都需要对包含数据库的文件夹的读/写（更改）权限。这包括IUSR账户。
鲍勃巴罗斯
This IS covered at http://www.aspfaq.com/show.asp?id=2009 - 80004005
errors
All users of a Jet database need read/write (Change) permissions for
the folder containing the database. This includes the IUSR account.
Bob Barrows
它已被覆盖，但它没有解决我的问题，因此我发布的原因。 ..
It IS covered, however, it DOESNT solve my problem, hence the reason I
posted...
对不起，我错过了您原来发帖中你说过你读过的那篇文章
这篇文章...... ;-)
只要所有用户（包括IUSR和IWAM帐户）对包含数据库的文件夹具有文件系统
权限，就应该没有
问题。这对我来说可以。我猜您需要提供更多
的信息。
Bob Barrows
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。这个电子邮件帐户是我的垃圾邮件陷阱所以我
不经常检查它。如果您必须离线回复，请删除
无垃圾邮件
Sorry, I missed the part in your original post where you said you had read
this article ... ;-)
As long as all users (including the IUSR and IWAM accounts) have filesystem
permissions to the folder containing the database, there should be no
problem. It works fine for me. I guess you need to provide some more
information.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don''t check it very often. If you must reply off-line, then remove the
"NO SPAM"
这篇关于并发Web和直接访问Access DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
