| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 898 人关注过本帖
标题:access 数据库问题
只看楼主 加入收藏
luyulin
Rank: 1
等 级:新手上路
帖 子:66
专家分:0
注 册:2004-12-18
收藏
 问题点数:0 回复次数:5 
access 数据库问题
数据库老出现这样的错误,导致站点无法打开。
無法使用 '' ; 檔案已在使用中。
Microsoft JET Database Engine|-2147467259
请各位大虾帮忙解决,谢谢
搜索更多相关主题的帖子: 数据库 access Microsoft Engine 
2007-12-10 10:30
madpbpl
Rank: 4
等 级:贵宾
威 望:11
帖 子:2876
专家分:244
注 册:2007-4-5
收藏
得分:0 
我搜索了一下百度。这个可能是楼主的数据库路径或是磁盘空间不足造成的影响。
楼主最好把代码贴出来,让大家分析一下。
2007-12-10 10:36
luyulin
Rank: 1
等 级:新手上路
帖 子:66
专家分:0
注 册:2004-12-18
收藏
得分:0 
路径应该是对的
路径应该是对的,我所有的创建connection对象都是使用同一个名为connfig.asp的文件来实现的,站点是有时后连不上数据库,错误是说“档案在使用”。
2007-12-10 14:32
madpbpl
Rank: 4
等 级:贵宾
威 望:11
帖 子:2876
专家分:244
注 册:2007-4-5
收藏
得分:0 
试试这样行不行
因为你手动打开ACCESS后,系统默认为独占打开,也就是说这时别的程序已经不能访问ACCESS了,只有你在修改完成后,退出系统才会允许别的进程来访问~

如果要改回原来的状态,只需要打开该MDB文件,然后选择工具---选项---高级---默认打开模式,选择共享就好~~
2007-12-10 15:09
luyulin
Rank: 1
等 级:新手上路
帖 子:66
专家分:0
注 册:2004-12-18
收藏
得分:0 
MSDN解决方案
RESOLUTION
To verify that the server and the computer where the Access database is located are configured correctly, follow these steps: 1. Verify the identity of the Internet Guest User account. To do this, follow these steps:a.  In IIS version 4.0, Right-click the Web site in the IIS Management Console, and then click Properties.
b.  Click the Directory Security tab, and then click Edit in the Anonymous Access and Authentication box. The Authentication Methods dialog box appears.
c.  Click the Edit button next to the account that is used for anonymous access. The Anonymous User Account dialog box appears. This dialog box displays the Windows NT user identity that IIS impersonates for the Web site. Note that the setting is set specifically for each folder or virtual directory of the Web site, and for each specific ASP page in the Web site.

If a specific ASP page is experiencing problems, verify the properties for the ASP page and for the Web site.  
 
2. If the Access database is located on a remote computer, you must take additional steps to configure the remote computer. For additional information about how to connect to a remote Access database, click the following article number to view the article in the Microsoft Knowledge Base:
253580 ([url]http://support.[/url]) How to connect to a remote Access database from Active Server Pages  
3. Set the permissions for the Access database. The database file must have at least read, write, execute, and change permissions for the Internet Guest User account. Additionally, configure the database folder to have at least read, write, execute, and change permissions.
4. The Microsoft Jet database engine uses temporary files while you work with Access databases. If the temporary folders are not defined in the system variables for the computer, the Microsoft Jet database engine creates and modifies the temporary files in the WINNT\System32 folder.

The temporary folder that the Access database uses requires that access be granted to the Internet Guest User account. However, it is not a good idea to give users this type of access. We recommend that you configure both the System TEMP environment variable and the TMP environment variable as follows:a.  Right-click My Computer, and then click Properties.
b.  Click the Environment tab, and then click an existing variable in the System section of the tab. The variable name and the value appear in the text boxes of the System Properties dialog box.  
c.  To change the variable name, click the variable name, and then type TEMP in the Variable box.  
d.  In the Value box, modify the text to reflect the location of the temporary folder on the computer. Typically, the path is C:\TEMP.  
e.  Click SET. The variable is added to the System section.  
f.  Repeat steps 4a through 4e for the TMP environment variable.
g.  Restart the computer.

Note You must restart your computer for these changes to take effect.
The temporary folder must have at least read, write, change, and delete permissions for the Internet Guest User account
2007-12-10 16:34
madpbpl
Rank: 4
等 级:贵宾
威 望:11
帖 子:2876
专家分:244
注 册:2007-4-5
收藏
得分:0 
根据msdn已经解决了?
2007-12-10 16:55
快速回复:access 数据库问题
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.062355 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved