Getting data from secure access database

[LittleSmudge]

I have an ASP page that lookas at an Access database using

Set Conn = Server.CreateObject("ADODB.Connection")

strconnect = "DRIVER={Microsoft Access Driver (*.mdb)};" _
           & "DBQ=" & Server.MapPath("/LS/database/Smudge.mdb") & "; " _
           & "wrkgrp=" & Server.MapPath("/LS/database/SmudgeMDW.mdw") & "; " _
           & "Usr=Fred; Pwd=abcdef; "


Conn.open strConnect

Set rst = Conn.Execute("SELECT * FROM tblData ")

The problem is that Fred is not a User in SmudgeMDW.mdw HOWEVER the Conn.Execute sill opens the database and I can use rst to read the data

What am I doing wrong that is allowing the data out ?






G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[LittleSmudge]

Okay - so now that I AM using the correct .MDB file I get an ASP error

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xca0 Thread 0x8ac DBC 0x9eac014 Jet'.

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[LittleSmudge]

But still no further forward.

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[newmediaguy]

Hi

The folder that has the database in it needs write permissions [on the IUSR_MachineName account] so that it can create the temporary lock files etc..

You may also want to apply this permission to the database but I would look at this and the potential impact before doing that.

Thanks





Glen
Conception | Execution

 

[LittleSmudge]

Hi Glen,

Thanks for your comments.

The database AND the .MDW file are in the /Database folder that does have write permission.

LS/Database is THE folder that the ISP provides that allows Write access. It is specifically for ASP connected databases.

The database opens fine if I don't use the .MDW security. SO it must be allowing the creation of the database lock file.

It is just the addition of the .MDW User/Group security that is messing up the system.







G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.