Dreaded Jet DB error 80004005 help needed. What causes this???

[JackV]

Hi All,

I'm trying to understand what causes this error message:
Microsoft JET Database Engine error '80004005'

The Microsoft Jet database engine cannot open the file
'\\Devadp\cdrive\Inetpub\wwwroot\cgi-bin\HSW.MDB'. It is already opened
exclusively by another user, or you need permission to view its data.

/newopenedcasedupload.asp, line 28


My code works when the access db is located locally but when I try to access
a remote database on another server, I get the above message. Here is my
working code (when db is local) below. How can I access the remote db?

dim connectionstring, rs, db, Querystring

connectionstring = "provider=microsoft.jet.oledb.4.0;data source=
\\Devadp\cdrive\Inetpub\wwwroot\cgi-bin\HSW.MDB;persist security info=false"

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DataUpload","InsertUpdate","xxxx"
set db = Server.CreateObject("ADODB.Connection")
db.Open connectionstring
Set rs = Server.CreateObject("ADODB.Recordset")

[Ray at]

See the steps you need to take here first.

[url]http://www.aspfaq.com/show.asp?id=2168[/url]

Ray at work

"JackV" <vituja@consumer.org> wrote in message
news:%23YMun%23i%23DHA.3284@TK2MSFTNGP09.phx.gbl.. .

> Hi All,
>
> I'm trying to understand what causes this error message:
> Microsoft JET Database Engine error '80004005'
>
> The Microsoft Jet database engine cannot open the file
> '\\Devadp\cdrive\Inetpub\wwwroot\cgi-bin\HSW.MDB'. It is already opened
> exclusively by another user, or you need permission to view its data.
>
> /newopenedcasedupload.asp, line 28
>
>
> My code works when the access db is located locally but when I try to

access

> a remote database on another server, I get the above message. Here is my
> working code (when db is local) below. How can I access the remote db?
>
> dim connectionstring, rs, db, Querystring
>
> connectionstring = "provider=microsoft.jet.oledb.4.0;data source=
> \\Devadp\cdrive\Inetpub\wwwroot\cgi-bin\HSW.MDB;persist security

info=false"

>
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open "DataUpload","InsertUpdate","xxxx"
> set db = Server.CreateObject("ADODB.Connection")
> db.Open connectionstring
> Set rs = Server.CreateObject("ADODB.Recordset")
>
>
>
>

[JackV]

Thanks for the info Ray




"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:ez9IIFj%23DHA.3668@TK2MSFTNGP09.phx.gbl...

> See the steps you need to take here first.
>
> [url]http://www.aspfaq.com/show.asp?id=2168[/url]
>
> Ray at work
>
> "JackV" <vituja@consumer.org> wrote in message
> news:%23YMun%23i%23DHA.3284@TK2MSFTNGP09.phx.gbl.. .

> > Hi All,
> >
> > I'm trying to understand what causes this error message:
> > Microsoft JET Database Engine error '80004005'
> >
> > The Microsoft Jet database engine cannot open the file
> > '\\Devadp\cdrive\Inetpub\wwwroot\cgi-bin\HSW.MDB'. It is already opened
> > exclusively by another user, or you need permission to view its data.
> >
> > /newopenedcasedupload.asp, line 28
> >
> >
> > My code works when the access db is located locally but when I try to

> access

> > a remote database on another server, I get the above message. Here is

my

> > working code (when db is local) below. How can I access the remote db?
> >
> > dim connectionstring, rs, db, Querystring
> >
> > connectionstring = "provider=microsoft.jet.oledb.4.0;data source=
> > \\Devadp\cdrive\Inetpub\wwwroot\cgi-bin\HSW.MDB;persist security

> info=false"

> >
> > Set Conn = Server.CreateObject("ADODB.Connection")
> > Conn.Open "DataUpload","InsertUpdate","xxxx"
> > set db = Server.CreateObject("ADODB.Connection")
> > db.Open connectionstring
> > Set rs = Server.CreateObject("ADODB.Recordset")
> >
> >
> >
> >

>
>