Classic ASP Discussion - Microsoft Access can’t open the database

Print Page | Close Window

Microsoft Access can’t open the database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=11238
Printed Date: 31 March 2026 at 11:58am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Microsoft Access can’t open the database

Posted By: vinodkalpaka
Subject: Microsoft Access can’t open the database
Date Posted: 20 July 2004 at 2:37am

hi all,

I have a problem with devoloping an asp program , that shouldl open ms-access using

Set objAccess = Server.CreateObject("Access.Application")

here is my asp code.

<%
    Dim objAccess
    Set objAccess = Server.CreateObject("Access.Application")
        objAccess.OpenCurrentDatabase request("APPL_PHYSICAL_PATH") & "databasename.mdb"
    objAccess.DoCmd.OutputTo 3, "reportName", "Snapshot Format (*.snp)", "snapshotname.snp", 0
    objAccess.DoCmd.Quit 2
%>

It shows the error in my IE browser.

error '800a1eba'

if i trap the error through asp code it shows below message.

Microsoft Access can't open the database because it is missing, or opened exclusively by another user.

What should be the reason of this error ?

Please help me?
Thanking in advance.

from
Vinod

Replies:

Posted By: WebWiz-Bruce
Date Posted: 20 July 2004 at 3:24am

Usuauly this means the database is open in another program.

If you have the database open in access you often get this error.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting