Connecting to passworded Access DB

[John L.]

I want my ASP page to write data to a passworded Access database. This code
works fine on my computer using Win 98SE and PWS. However, it does not work
on my web site's server. The code used is:

dim Conn
DBName = "../folder1/data.mdb"
set Conn = server.createobject("ADODB.Connection")
ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)};"
ConnStr = ConnStr & "DBQ=" & server.mappath(DBName) & ";"
ConnStr = ConnStr & "PWD=password;"
Conn.open ConnStr

Error message is:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
/folder1/submit.asp, line 19

Line 19 is the Conn.open ConnStr line.

I have double checked and the password is correct, so there is something
wrong with my Connection String. Any advice?

Thanks, John L.

[Kris Eiben]

Username?

John L. wrote in message <3a416118$1@news.devx.com>...
>
>I want my ASP page to write data to a passworded Access database. This code
>works fine on my computer using Win 98SE and PWS. However, it does not work
>on my web site's server. The code used is:
>
>dim Conn
>DBName = "../folder1/data.mdb"
>set Conn = server.createobject("ADODB.Connection")
>ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)};"
>ConnStr = ConnStr & "DBQ=" & server.mappath(DBName) & ";"
>ConnStr = ConnStr & "PWD=password;"
>Conn.open ConnStr
>
>Error message is:
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
>/folder1/submit.asp, line 19
>
>Line 19 is the Conn.open ConnStr line.
>
>I have double checked and the password is correct, so there is something
>wrong with my Connection String. Any advice?
>
>Thanks, John L.
>

[John L.]

As far as I know there is not a username. This is simply a "database
password" as opposed to the user and/or group permissisons/accounts. To open
this database in Access or in Visual Basic I only have to enter the
password. The folder where the database file sits on the server does not
have a user name or password either. I am fairly new to ADO (I still use DAO
most of the time)

Kris Eiben <eibenkthisisforspammers@yahoo.com> wrote in message
news:3a4208ae$1@news.devx.com...
> Username?
>
> John L. wrote in message <3a416118$1@news.devx.com>...
> >
> >I want my ASP page to write data to a passworded Access database. This
code
> >works fine on my computer using Win 98SE and PWS. However, it does not
work
> >on my web site's server. The code used is:
> >
> >dim Conn
> >DBName = "../folder1/data.mdb"
> >set Conn = server.createobject("ADODB.Connection")
> >ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)};"
> >ConnStr = ConnStr & "DBQ=" & server.mappath(DBName) & ";"
> >ConnStr = ConnStr & "PWD=password;"
> >Conn.open ConnStr
> >
> >Error message is:
> >Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
> >/folder1/submit.asp, line 19
> >
> >Line 19 is the Conn.open ConnStr line.
> >
> >I have double checked and the password is correct, so there is something
> >wrong with my Connection String. Any advice?
> >
> >Thanks, John L.
> >
>
>

[Madhon]

the default username for an access db is "admin"

"John L." <mynista@mynista.com> wrote in message
news:3a421d94@news.devx.com...
> As far as I know there is not a username. This is simply a "database
> password" as opposed to the user and/or group permissisons/accounts. To
open
> this database in Access or in Visual Basic I only have to enter the
> password. The folder where the database file sits on the server does not
> have a user name or password either. I am fairly new to ADO (I still use
DAO
> most of the time)
>
> Kris Eiben <eibenkthisisforspammers@yahoo.com> wrote in message
> news:3a4208ae$1@news.devx.com...
> > Username?
> >
> > John L. wrote in message <3a416118$1@news.devx.com>...
> > >
> > >I want my ASP page to write data to a passworded Access database. This
> code
> > >works fine on my computer using Win 98SE and PWS. However, it does not
> work
> > >on my web site's server. The code used is:
> > >
> > >dim Conn
> > >DBName = "../folder1/data.mdb"
> > >set Conn = server.createobject("ADODB.Connection")
> > >ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)};"
> > >ConnStr = ConnStr & "DBQ=" & server.mappath(DBName) & ";"
> > >ConnStr = ConnStr & "PWD=password;"
> > >Conn.open ConnStr
> > >
> > >Error message is:
> > >Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > >[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
> > >/folder1/submit.asp, line 19
> > >
> > >Line 19 is the Conn.open ConnStr line.
> > >
> > >I have double checked and the password is correct, so there is
something
> > >wrong with my Connection String. Any advice?
> > >
> > >Thanks, John L.
> > >
> >
> >
>
>

[Francis]

Check out the MS Knowledge base...

They have an answer for, some server use the ADO 2.5 whow not connect as
ADO 2.0 or 2.1

"John L." <mynista@mynista.com> wrote:
>
>I want my ASP page to write data to a passworded Access database. This code
>works fine on my computer using Win 98SE and PWS. However, it does not work
>on my web site's server. The code used is:
>
>dim Conn
>DBName = "../folder1/data.mdb"
>set Conn = server.createobject("ADODB.Connection")
>ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)};"
>ConnStr = ConnStr & "DBQ=" & server.mappath(DBName) & ";"
>ConnStr = ConnStr & "PWD=password;"
>Conn.open ConnStr
>
>Error message is:
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
>/folder1/submit.asp, line 19
>
>Line 19 is the Conn.open ConnStr line.
>
>I have double checked and the password is correct, so there is something
>wrong with my Connection String. Any advice?
>
>Thanks, John L.
>