本地App和.net Web App使用的MS Access DB [英] MS Access DB used by both a local App and .net Web App

问题描述

我正在开发一个项目，用于从现有应用程序控制的现有数据库中构建一个报告Web应用程序。

控制数据库的应用程序会为数据库创建一个锁定文件，此时我无法再使用我的Web应用程序访问数据库。无论如何，这还有吗？b $ b？我只需要只读访问

数据库就可以获得一些报告信息显示在网页上。


我在网络应用上看到的错误当我尝试访问锁定的数据库是

无法使用'''';文件已被使用。


任何人都有这方面的经验吗？

I am working on a project to build a reporting web app from an exsiting
database that is controled by a local application. The application that
has control over the database creates a lock file to the database and
at that point I can no longer access the database with my web app. Is
there anyway around this? All I need is read only access to the
database to get some report information to display on the web page.

The error I get on the web app when I try to access the locked db is
"Could not use ''''; file already in use."

Anyone have experiance with this?

推荐答案

我找到了这个帖子，但我没有按照问题的解决方法来解决。
http://groups.google.com/group/micro .. .80ef822df6e91c

I found this thread but I didn''t follow how the problem was fixed.
http://groups.google.com/group/micro...80ef822df6e91c

你的问题是，Access是一个单一的用户数据库，对于这种类型来说有点尴尬
scneario。


如果您所做的都是报告（读取活动），请在您使用asp.net访问临时文件时将文件复制到
并从中读取。那样

你应该总是有权访问并获得最新数据。


-

问候


John Timney

ASP.NET MVP

微软区域总监


" JonnyD" <毫安********* @ gmail.com>在消息中写道

news：11 ********************** @ o13g2000cwo.googlegr oups.com ...

Well your problem is that Access is a single user database and sucks
somewhat for this type of scneario.

If all your doing is reporting (a read activity), copy the file when you
access it using asp.net to a temp file and read from that instead. That way
you should always have access and will get up to date data.

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"JonnyD" <ma*********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

我正在开发一个项目，用于从现有应用程序控制的现有数据库构建报告Web应用程序。
控制数据库的应用程序会为数据库创建一个锁定文件，此时我无法再使用我的Web应用程序访问数据库。在这周围有吗？我只需要只读访问数据库就可以获得一些报告信息显示在网页上。

当我尝试访问锁定的数据库时，我在网络应用上遇到的错误是
无法使用'''';文件已经在使用中。

任何人都有这方面的经验吗？

I am working on a project to build a reporting web app from an exsiting
database that is controled by a local application. The application that
has control over the database creates a lock file to the database and
at that point I can no longer access the database with my web app. Is
there anyway around this? All I need is read only access to the
database to get some report information to display on the web page.

The error I get on the web app when I try to access the locked db is
"Could not use ''''; file already in use."

Anyone have experiance with this?

我想我3年前的建议仍然是好建议：


" Downloaded FileMon再看看。出现ASPNET没有我认为它对数据库和它所在的文件夹所做的

权限。修复了

那个，并且问题清理了


ASPNET用户必须对包含

..mdb文件的文件夹具有读/写权限。


Greg

" JonnyD" <毫安********* @ gmail.com>在消息中写道

news：11 ********************** @ z14g2000cwz.googlegr oups.com ...

I think my suggestion from 3 years ago still is good advice:

"Downloaded FileMon and took another look. Appears ASPNET didn''t have the
rights I thought it did to the database and the folder it resides in. Fixed
that, and the problem cleared up"

The ASPNET user must have read/write access to the folder containing your
..mdb file.

Greg
"JonnyD" <ma*********@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

我找到了这个帖子，但我没有按照问题的解决方法来解决问题。
http://groups.google.com/group /micro...80ef822df6e91c

I found this thread but I didn''t follow how the problem was fixed.
http://groups.google.com/group/micro...80ef822df6e91c

这篇关于本地App和.net Web App使用的MS Access DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！