Runtime error while accessing .aspx page if .mdb database is open

Gayathri

Hi
I am using MS Access to store the data in an .mdb file. And I observe that, if the .mdb is open, I receive a runtime error whenever I/someone tries to access any of the .aspx pages that needs to access this .mdb. My .aspx pages are using OleDb for the data retrieval. I do not want those runtime errors. Please enlighten me as to how to get rid of those runtime errors. Thanks a ton in advance...

Nov 18 '05 #1

Subscribe Reply

2473

Ken Cox [Microsoft MVP]

You can't open an Access database from the file system (as the logged on
user) and from the Web application at the same time. There's a locking file
(*.ldb) that prevents this type of use.

Do all of your work through the Web pages and you'll have better luck.

Ken

"Gayathri" <an*******@disc ussions.microso ft.com> wrote in message
news:DF******** *************** ***********@mic rosoft.com...

Hi,
I am using MS Access to store the data in an .mdb file. And I observe
that, if the .mdb is open, I receive a runtime error whenever I/someone
tries to access any of the .aspx pages that needs to access this .mdb. My
.aspx pages are using OleDb for the data retrieval. I do not want those
runtime errors. Please enlighten me as to how to get rid of those runtime
errors. Thanks a ton in advance...

Nov 18 '05 #2

George Ter-Saakov

I believe you can open database with MS Access. Just need to be cautious how
you do that.

1. Make sure that "open mode" is set to shared. in MS Access 2000
Tools/Option/Advanced

2. When you want to share MDB file the LDB file is created. The most common
mistake, when used from web application, is that people forget to give
"Create File" permission to ASP.NET account on the folder where MDB files
is.
The result is: LDB file is not created and database is opened in Exclusive
mode.
If you want it to work correctly you must give "Create File" permissions to
the ASP.NET account (or whatever account used) on the folder where MDB file
resides.

Good luck with Access, and as soon as you can switch to MS SQL or at least
MSDE.
George.

"Ken Cox [Microsoft MVP]" <BA************ @sympatico.ca> wrote in message
news:ej******** *****@TK2MSFTNG P10.phx.gbl...

You can't open an Access database from the file system (as the logged on
user) and from the Web application at the same time. There's a locking file (*.ldb) that prevents this type of use.

Do all of your work through the Web pages and you'll have better luck.

Ken

"Gayathri" <an*******@disc ussions.microso ft.com> wrote in message
news:DF******** *************** ***********@mic rosoft.com...
Hi,
I am using MS Access to store the data in an .mdb file. And I observe
that, if the .mdb is open, I receive a runtime error whenever I/someone
tries to access any of the .aspx pages that needs to access this .mdb. My .aspx pages are using OleDb for the data retrieval. I do not want those
runtime errors. Please enlighten me as to how to get rid of those runtime errors. Thanks a ton in advance...

Nov 18 '05 #3

Similar topics

4315

Great Difficulties Accessing my Database from an FTP site

by: prodirect | last post by:

Hi all, I hope someone can help me. I've recently created a database and wanted to put it up on an ftp sight so that multiple people could access the same tables at the same time from different geographical locations. I have been completely unsucessful in acheiving this goal so far however. Things I have tried: Create a shortcut to ftp sight via browser then tried to map local drive to

Microsoft Access / VBA

15112

Access Runtime and Security

by: Nathan Bloom | last post by:

Hi, I have a secured database that runs fine on the computer the database is installed on. I have several workstations with access runtime installed that also need access to the database. Access runtime runs fine when accessing an unsecured version of the database. However once the database was secured it generates a runtime error after asking for the user and password and won't open. The shortcut to the secured database is: "path...

Microsoft Access / VBA

539

Asp.net runtime error - multiple users with Access Db

by: mark | last post by:

I have an asp.net ecommerce web application on a remote web server. I'm using an Access database on the back end. I've notice a few strange things. When I mimic an multiple user environment by surfin it in multiple browsers simultaneously the site generates a generic runtime error after awhile. I'm thinking this has something to do with my access database and multiple connections. I'm using forms authentication with a login page. Is...

ASP.NET

1556

Help: Runtime error

by: VB Programmer | last post by:

If I try ANY aspx pages on my server, even INVALID, bogus pages, I get a "Runtime Error". Any idea why? Here is the full message: Server Error in '/' Application. ---------------------------------------------------------------------------- ----

ASP.NET

1510

ASP.NET Timeout Error

by: Pritam Javale | last post by:

When using Datagrid ASP.NET pages, the time required to execute a report is much more greater than when the same report is generated using a ASP page. Also the ASPX page almost always gives a 'TimeOut Expired Error'.

ASP.NET

5621

Insert Server Control Into HTML String (via Literal) at runtime

by: Guadala Harry | last post by:

In an ASCX, I have a Literal control into which I inject a at runtime. litInjectedContent.Text = dataClass.GetHTMLSnippetFromDB(someID); This works great as long as the contains just client-side HTML, CSS, etc. What I want to do is somehow insert a *server control* into the , then set the server control's properties at runtime.

ASP.NET

2213

Response.Redirect Error in Custom Class

by: Joe Rigley | last post by:

Hi, I have a custom class with a public method. I want to perform a repose.redirect if an error occurs in the public method GetUserRoles. Unfortunately, Visual Studio 2003 is throwing an error when I try to do this. I have imported the System.Web namespace and the same code works fine on a ..aspx page. Can you not perform response.redirects in a custom class that is being called by another aspx page? Please help.

ASP.NET

22851

[OleDbException (0x80004005): Unspecified error]

by: Jim McGivney | last post by:

ASPX page from VS.net-C# on host's computer using oleDataAdaptor to connect to Microsoft Access database. The page loads, but when connection to the database is attempted to fill a datagrid the following error is generated. Any help would be appreciated. Thanks, Jim Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information

ASP.NET

2145

error in accessing database

by: le0 | last post by:

guys, this is my first time to deploy website to the server, but every time i access the page this error always appears. --------------------------------------------------------------------------------------------- Server Error in '/sample' Application. -------------------------------------------------------------------------------- The Microsoft Jet database engine cannot open the file

ASP.NET

8481

What is ONU?

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...

General

8400

Changing the language in Windows 10

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,...

Windows Server

8602

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8672

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

7441

AI Job Threat for Devs

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...

Career Advice

5702

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4412

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2058

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1814

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General