ASP+Access 怎么会出现 File already in use 的错误

zenyivon 2005-04-06 04:18:15
ASP+Access 的系统,跑在 Win2000 Svr+IIS+Access2003,是NTFS 格式,在其他页面也执行类似的语句,但是有一个页面上执行一个查询时,会出现:
Error Type
Microsoft JET Database Engine(0x80004005)
Cannot use ''; file already in use.
/......asp (文件名)
line 428

在自己的机器上都没有问题。数据库文件也加上了 XXX_IUSER 的访问权限了,也不知道怎么回事,以前客户那边是运行正常的,今天突然出现这个问题。

不知哪位有此经验?
...全文
108 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
  • 打赏
  • 举报
回复
可能是那个时候你打开了Access文件中的某个表
  • 打赏
  • 举报
回复
可能是那个时候你打开了Access文件中的某个表
zwei3000 2005-04-06
  • 打赏
  • 举报
回复
是不是access文件以独占的形式被别的程序占有了
我以前有过这方面的经历
baikaishui_0825 2005-04-06
  • 打赏
  • 举报
回复
在运行asp的时候不要打开access
1,xmldirviewer.zipThis is a sample from an XML implementation I created for my company's Intranet, giving the capability for user maintained content. 2,dnslookup.zipEasy DNS Lookup and Reverse Name lookup using qdns.dll (dll vb source is included in zip). For use see included sample ASP page. 3,SmartGuestBook.zipSpice up your site with this absolutely free interactive Flash guest book done in ASP and Flash. You can choose from various interfaces. SQL Server and Access database versions available.4,SmartReferrer.zipGive those important pages of your site individual attention (e.g. those you have been promoting recently). A compact product that consists of only one optimized ASP page for all functions including administration panel, comprehensive reports and help section. 5,AKimage.zipAKimage is a component that allows web developers to retrieve the dimensions, colour depth and file type of an image file residing on the server. Web pages can then be generated dynamically, using the information retrieved. A sample application and full documentation are included. 6,UploadFilesWithoutCom.zipAllows you to upload multiple files and fields without purchasing or registering COM objects. Great for shared hosts that frown upon 3rd Party com objects or charge an arm and a leg for them. 7,tellafriend.zipThis is an ASP Script simply to be used on your pages to allow users to email an article or page they've seen on your site. This Script also use JavaScript to validate the form. 8,下载_script.zipThis 下载 counter script uses ASP file system object to get the size of the 下载 file and to track how many times a file is already 下载ed. 9,k-base.zipK Base is a simple knowledge base that allows users to add and query database entries. Each user can be given their own username and password. There is also an admin status that lets them delete records and administer users. 10,comersus322.zipElectronic commerce software 100% in ASP that enable businesses to sell goods and services over the Internet with the following features: full cart, user profiling, database driven (Access, SQL), Taxes, BackOffice web, SSL, Sophisticated Shipping rates, multilanguage, stock and more. 11,vpasp.zipVP-ASP is a comprehensive, ready to use ASP shopping cart for business and developers. Can be use standalone or integrated into any web. Does not require any DLLs, it is fully ASP. 12,ASP_CDOMail.zipUsing Microsoft Technologies, a simple example of how to send email using ASP, CDO, and IIS. Full Source. Information on CDO is well documented on the Internet. 13,ashopKart20.zipShopping cart application written in ASP. 14,linkengine.zipA very basic ASP links engine. 15,ASPForums2.zipFree discussion forum written in ASP. This software uses no components (so it can easily be used in hosted ASP environments) and auto-generates its own DSN for its backend database. Supports MS Access by default, but also fully tested with MS SQL Server. 16,SiteGalaxyUpload.zipThe SiteGalaxy ASP Upload is free Active Server component that parses RFC-1867 HTTP requests. It can be used in ASP pages to accept files sent by client browser using encType= "multipart/form-data" forms. The object's interface is very similar to Request.Form with addition of some extra methods to handle upload file data. 17,MyLogin2000.zipMyLogin is created entirely in ASP. With just a few simple steps you can password protect any of your pages without knowing how to code ASP (But it Helps!) You can assign individual access levels or you can assign Group access levels. 18,WebWorX.zipThis is a fully functional Access database driven web site compliments of FailSafe Systems. Complete ASP source code is provided. Please read the included ReadMe.txt file before installing. 19,othello.zipFull ASP script for Othello game. 20,scroll.zipNot ASP code, but if you're a webmaster, this piece of HTML code will show you how to cause text on your page to scroll!
(60 MB) Use this MSI installer package to start coding .NET applications that access the Oracle Database. Oracle Data Provider for .NET provides Oracle data access in your .NET code. Oracle Developer Tools for Visual Studio enables Visual Studio data features such as Server Explorer integration, TableAdapter Configuration Wizard and Entity Designer and also includes many useful Oracle specific tools. Please select the newest version and click the "Download" button. (The newest version works with Oracle Database 11.2 or higher. Older versions are provided for archival purposes only) Important: Before you install this package please make sure to uninstall any version of Oracle Developer Tools for Visual Studio installed on the machine. This includes versions installed using the Oracle Universal Installer. Close any running instances of Visual Studio before installing If you already have Oracle software installed, install into a new "Oracle Home" software location (eg. a new subdirectory) This installation requires Visual Studio 2017 15.7.0 or later. Please note: In rare cases this installation may fail with a message to check a log file for more details and it may remain partially installed. This may cause an "already installed" error when you attempt to install again. Please use Add or Remove programs to uninstall, correct the error mentioned in the log and then reattempt the installation. This download includes: Oracle Developer Tools for Visual Studio Oracle Data Provider for .NET, Managed Driver Oracle Providers for ASP.NET This download does not include support for User Defined Types nor Oracle Database Extensions for .NET. If this is required, please return to the main download page and select "ODAC - Oracle Universal Installer".
(60 MB) Use this MSI installer package to start coding .NET applications that access the Oracle Database. Oracle Data Provider for .NET provides Oracle data access in your .NET code. Oracle Developer Tools for Visual Studio enables Visual Studio data features such as Server Explorer integration, TableAdapter Configuration Wizard and Entity Designer and also includes many useful Oracle specific tools. Please select the newest version and click the "Download" button. (The newest version works with Oracle Database 11.2 or higher. Older versions are provided for archival purposes only) Important: Before you install this package please make sure to uninstall any version of Oracle Developer Tools for Visual Studio installed on the machine. This includes versions installed using the Oracle Universal Installer. Close any running instances of Visual Studio before installing If you already have Oracle software installed, install into a new "Oracle Home" software location (eg. a new subdirectory) This installation requires Visual Studio 2017 15.7.0 or later. Please note: In rare cases this installation may fail with a message to check a log file for more details and it may remain partially installed. This may cause an "already installed" error when you attempt to install again. Please use Add or Remove programs to uninstall, correct the error mentioned in the log and then reattempt the installation. This download includes: Oracle Developer Tools for Visual Studio Oracle Data Provider for .NET, Managed Driver Oracle Providers for ASP.NET This download does not include support for User Defined Types nor Oracle Database Extensions for .NET. If this is required, please return to the main download page and select "ODAC - Oracle Universal Installer".
(60 MB) Use this MSI installer package to start coding .NET applications that access the Oracle Database. Oracle Data Provider for .NET provides Oracle data access in your .NET code. Oracle Developer Tools for Visual Studio enables Visual Studio data features such as Server Explorer integration, TableAdapter Configuration Wizard and Entity Designer and also includes many useful Oracle specific tools. Please select the newest version and click the "Download" button. (The newest version works with Oracle Database 11.2 or higher. Older versions are provided for archival purposes only) Important: Before you install this package please make sure to uninstall any version of Oracle Developer Tools for Visual Studio installed on the machine. This includes versions installed using the Oracle Universal Installer. Close any running instances of Visual Studio before installing If you already have Oracle software installed, install into a new "Oracle Home" software location (eg. a new subdirectory) This installation requires Visual Studio 2017 15.7.0 or later. Please note: In rare cases this installation may fail with a message to check a log file for more details and it may remain partially installed. This may cause an "already installed" error when you attempt to install again. Please use Add or Remove programs to uninstall, correct the error mentioned in the log and then reattempt the installation. This download includes: Oracle Developer Tools for Visual Studio Oracle Data Provider for .NET, Managed Driver Oracle Providers for ASP.NET This download does not include support for User Defined Types nor Oracle Database Extensions for .NET. If this is required, please return to the main download page and select "ODAC - Oracle Universal Installer".

28,390

社区成员

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

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