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

Hello,

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

Brian

Was that mdb, set a password by any chance?

_________________________
- Vijay G
Strive for Perfection