473,671 Members | 2,557 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

HTTP 500.100 Microsoft Jet database Engine could not open the file.. already..

36 New Member
Hi,
I'm a student looking for any recommendation to finding a solution to the following problem.

(Hope I'm posting in the correct 'section' of the forum, since my error says both IIS and ASP)

I'm running IIS on my WIndows XP Pro OS.
I'm connecting an Access database (.mdb file) to Dreamweaver CS4.
I've made the connection with the following string

"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=C:\Inetp ub\wwwroot\mySi te\mySite.mdb;"

When tested it shows as successful. If I add words, tables, images and simple html codes it works fine when tested and previewed through the web browser.

However, once I add a recordset/or query it produces the following error:-

HTTP 500.100 Internal Server Error- ASP Error IIS

Error Type:
Microsoft Jet database engine cannot open the file C:\Inetpub\wwwr oot\mySite\mySi te.mdb
It is already opened exclusively by another user or you need permission to view its data
/mySite/index.asp/line 9


Line 9 is where my recordset is when I view the code.
I've tried IUSR/Localmachine
I've tried to work with user permissions
Uninstalled and re-installed IIS
I seem to be getting no solution.

Any help rendered would be greatly appreciated.
Thank you :-)
Oct 4 '09 #1
2 3666
Frinavale
9,735 Recognized Expert Moderator Expert
It sounds like you aren't properly closing the connection to your database.
If the resource is not properly closed then the next person accessing the website won't be able to do anything with the database.

If this isn't the problem then it could be that you need to implement some sort of lock on the database ensuring that new connections have to wait their turn while the existing connection uses the database.

I would first investigate the possibility that you aren't properly closing your connection though because I think that is the root to your problem.

-Frinny
Nov 17 '09 #2
student2
36 New Member
Thank you very much!
Nov 23 '09 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
2082
by: Abubakar | last post by:
Hello , I just finished developing a program using Microsoft Desktop Engine with C# as the front end. Everything is okay on my system. But, on trying to deploy it on a different system it gives an error message that it can open the database This is my first time in using the Microsoft Desktop engine. All this while I have been using Access as my database engine and normally what I do after developing a program is to transfer the Database file...
3
6883
by: Neal | last post by:
Hi All I am trying to connect from ASP.Net app to an Access Db. If i don't specify a userid an pwd.. I get this error The Microsoft Jet database engine cannot open the file 'C:\Documents and Settings\rogersn\My Documents\EEECourses.mdb'. It is already opened exclusively by another user, or you need permission to view its data." If i specify a userid (aspnet) no password I get
1
949
by: Morten Wennevik | last post by:
I'm transferring an Excel file from a client computer to a web-page on a server, then trying to open the file on the server causes this exception message to occur. The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data. I open the file using this connection string Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
2
3299
by: rh.krish | last post by:
Hi I'm trying to open an excel file uploaded by the user and read the content. I'm able to save the file in the web server, but when I try to open it - I get the following error: "The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data. "
4
2304
by: klynn | last post by:
Hi: I'm having problems reading a Microsoft Access file from my ASP.Net app on a Windows Server 2003 machine. The error message: The Microsoft database engine cannot open the file, <my_file>. It is already opened exclusively by another user, or you need permission to view its data. I've read some info about this (microsoft support article q316675) but I'm still confused on what to do?
0
12042
by: bazzer | last post by:
hey, im trying to access a microsoft access database from an ASP.NET web application in visual basic 2003.NET. i get the following error when i try running it: Server Error in '/CinemaBookingSystem' Application. -------------------------------------------------------------------------------- ERROR General error Unable to open registry key 'Temporary (volatile) Jet DSN for process
15
4598
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to communicate with a MySQL database table on a web server, from inside of my company's Access-VBA application. I know VBA pretty well but have never before needed to do this HTTP/XML/MySQL type functions.
7
1873
by: change | last post by:
peoples am having a problem with connecting to an access database can someone help me with a script that enables the connection so i can query the database
2
5430
by: =?Utf-8?B?c25henp5?= | last post by:
I have created an web application using Visual Studio 2008. The application works OK in Debug. However it does not work after publish. The following message appers "The Microsoft Jet database engine cannot open the file '\\192.168.0.2\Test\Test.mdb'. It is already opened exclusively by another user or you need permission to view its data".
0
8483
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8402
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8927
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8676
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7445
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6237
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4416
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2819
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1816
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.