Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old July 23rd, 2004, 04:20 AM
Authorized User
 
Join Date: Jul 2004
Location: , , .
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to vinodkalpaka Send a message via Yahoo to vinodkalpaka
Default Microsoft Access can't open the database because.

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.Visible = False
objAccess.OpenCurrentDatabase "E:\spon\Spon.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.

I did not opened that database elsewhere.
What should be the reason of this error ?

Please help me?
Thanking in advance.

from
Vinod


  #2 (permalink)  
Old July 23rd, 2004, 07:25 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hello,

Do you have the Spon.mdb database open in Access, or is a .ldb file generated before you run the code?

Brian
  #3 (permalink)  
Old July 24th, 2004, 04:37 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Was that mdb, set a password by any chance?

_________________________
- Vijay G
Strive for Perfection


Similar Threads
Thread Thread Starter Forum Replies Last Post
The Microsoft Jet database engine cannot open .mdb hunzian78@yahoo.com ASP.NET 1.0 and 1.1 Professional 13 February 1st, 2007 12:47 PM
Microsoft Jet Database Engine Cannot Open hunzian78@yahoo.com ADO.NET 3 February 23rd, 2006 01:40 PM
Problem Connecting to Microsoft Access Database eric_lim_1 Classic ASP Databases 1 September 17th, 2005 03:12 AM
Microsoft Access can't open the database because. vinodkalpaka Classic ASP Components 2 August 4th, 2004 06:27 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.