I am in need of help in Moving the weekly_poll.mdb file to another dir, outside of IIS. I have found that the weekly_poll.mdb file can be downloaded from the site if it is left in the same dir as the asp pages that go with it. after dl'ing the MDB you can read the admin name and password to the weeklypoll admin page, which is a little in-secure to me.

I have found the lines I suspect point to the location of the weekly_poll.mdb file, in the common.inc file, but have not been able to insert a corrected path: IE: Change this:

D4D1 wrote: DBQ=" & Server.MapPath("weekly_poll.mdb") to this: DBQ=" ("c:\winnt\temp\weekly_poll.mdb") or some other dir. Any help would be appreciated, Thanks

this was almost right

DBQ=" ("c:\winnt\temp\weekly_poll.mdb")

but it is

DBQ=c:\winnt\temp\weekly_poll.mdb"

i think thats right

well, not really I just gave it a try and got this:

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 0x9dc Thread 0xa60 DBC 0x20b0064 Jet'.

/wkp/common.inc, line 91

which on webwiz help states that it is most likely an error in the database location, IE:

This error can happen for a number of reasons the main reason being if the path to the database is incorrect.

You need to check that the path to the database is correct (You must use the physical path on the server to the database and not a virtual path).

The error is also quite common if the permissions on the server are incorrect. Check that IIS has sufficient permissions to access the registry and that the correct permissions, read and write, are set on the directory containing the database and the database itself, for the IUSR account.

I have checked the permissions and the iusr account has access rights to the dir and the file.

Thanks for the reply tho

does your strCon look something like this "Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\domains\breathofair.awsnet.co.uk\user\private\forum.mdb"
%>

ignore the bold that is for example perposes

Nope. it looks like this:

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("weekly_poll.mdb")

but I changed it to:

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\winnt\temp\weekly_poll.mdb"

of coarse I changed it back to the org. DBQ=" & Server.MapPath("weekly_poll.mdb") after  it didn't work.

sorry does it look like this

strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDbPathAndName

and

strDbPathAndName = "D:\private\portal.mdb"

ahhh, nope, but I also cannot find strDbPathAndName in the common.inc file either, but I did find this:

'strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("weekly_poll.mdb") 

is that the same thing as what you were asking about?

or do I add the dim varible, strDbPathAndName, in common.inc file and make it  = the dir I want to use before the strcon = section and change it to:

add this

Dim strDbPathAndName

and add this above the strCon call:

strDbPathAndName="c:\winnt\temp\weekly_poll.mdb"

and change this:

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("weekly_poll.mdb")

to this:

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & strDbPathAndName

?

Thanks for the help, It is really apperciated.

strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\winnt\temp\weekly_poll.mdb"

try that

that should work.... im off for now be on later....

ok, I will try that, thanks and catch you later.

That Work Perfectly!!! Thanks for the help, I really apperciated it.

Web Wiz Rocks!!!