asp vbscript + access 的问题

no3l2001 2008-11-07 10:04:54
我是用dreamweaverMX2004,当我用火狐或IE测试我做的动态表格数据转换时出现了以下:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Office Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data.
/project/try.asp, line 8

要如何解决?
...全文
109 8 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
8 条回复
切换为时间正序
请发表友善的回复…
发表回复
no3l2001 2008-11-08
  • 打赏
  • 举报
回复
如何give the IUSR_<machinename> account full control to the ASP page, and the folder and files where the database is located???
no3l2001 2008-11-08
  • 打赏
  • 举报
回复
[Quote=引用 6 楼 sy_binbin 的回复:]
看我1楼的链接没???
[/Quote]

看了,才从那抄来的啊!
sy_binbin 2008-11-08
  • 打赏
  • 举报
回复
看我1楼的链接没???
no3l2001 2008-11-08
  • 打赏
  • 举报
回复
这是从microsoft抄来的:
RESOLUTION
If the page is meant to be accessed anonymously, give the IUSR_<machinename> account full control to the ASP page, and the folder and files where the database is located. Additionally, if the path to the database is being referenced using UNC (\\Server\Share), ensure that the Share Permissions allow the IUSR_<machinename> account full access. This step applies even if the share is on the local Web server.

If the page has been secured such that the IUSR_<machinename> can't access the file or database, then ensure that the user's account that is being authenticated has full control to the appropriate folders and files.

At a minimum, the account being used needs Create, Destroy, Read, Write to work with the .ldb file. Specific permission can be applied to the database to limit access

虽然知道是解决方案,却不懂要从何下手,请哪位能详细的解释。
什么是IUSR_<machinename>,UNC (\\Server\Share),how to ensure the user's acount is being authenticated has full control to the appropriate folders and files???
不耐烦 2008-11-08
  • 打赏
  • 举报
回复
<%
db = "db.mdb"'路径
SET conn = Server.CREATEOBJECT("ADODB.Connection")
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
conn.OPEN connstr
%>
试试这个连接代码 怀疑你是用的老的驱动
「已注销」 2008-11-08
  • 打赏
  • 举报
回复
我估计你现在试试就不会有这现象了
你的access当时被你自己打开了或者是被dw打开了
然后数据库驱动引擎就不能访问了

跟代码没有关系,不用改
不是你的错,谁的错都没有
sy_binbin 2008-11-07
  • 打赏
  • 举报
回复
http://topic.csdn.net/u/20081107/20/713b8372-9c65-4bad-a52a-99e13d8f868c.html

好这个帖子一个毛病!你试试1楼的方法
sy_binbin 2008-11-07
  • 打赏
  • 举报
回复
http://support.microsoft.com/kb/174943/

28,409

社区成员

发帖
与我相关
我的任务
社区描述
ASP即Active Server Pages,是Microsoft公司开发的服务器端脚本环境。
社区管理员
  • ASP
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧