ASP Tryng to Modify a Different Access DB than Specified in the Connection String

[ginfeatures]

I am using ASP classic on a local machine running IIS7. I am also using an Access 2007 DB file.

My connection string is as follows:

set Conn=server.createobject("adodb.connection")
Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\TM6293\Documents\tta.accdb;Persist Security Info=False;"

I opened up the permissions on that particular file, and its parent folder.

When my code tries to send an SQL statement to the Conn objet, I get the following error:

Microsoft Office Access Database Engine error '80004005'
Could not find file 'c:\windows\system32\inetsrv\ginstaff.mdb'.

Where is it pulling this file information? It is nowhere in my code, and I can't find reference to it in the IIS control panel, or the ODBC control panel. Thanks in advance for your advice.

[jhardman]

that is weird. I've seen some crazy stuff where it looks like there is an old value cached somewhere, but in this case if you never used this file in the past then I don't know why you would get it now.

1- are you absolutely certain the web server is noticing that you are editing the script? Can you see other edits come through?

2- Do you have high-level access to that machine? Can you restart IIS?

3- Have you considered connecting with a DSN rather than a file path?

Jared

[ginfeatures]

Thank you for your quick reply.

Well, I can't say that this file never existed on that computer, and it's a file name I might have used in the past. But I'm pretty sure I never used it in conjunction with IIS. If it were a cached value, where would it be cached?

1) I'm not sure what you mean here. IIS is installed on a local computer (Windows Vista), and I am editing the files directly on that computer. I apologize if this isn't what you meant.

2) Yes, I log in as a user in the Administrator group. I have restarted the service and it gives the same error message.

3) I'm willing to try it. Do I set that up through the ODBC control panel?

[ginfeatures]

Update per 3) I made a system DSN and changed my connection string to "DSN=TTA-DB;uid=;pwd=;" and I get the same error (referring to c:\windows\system32\inetsrv\ginstaff.mdb').

[ginfeatures]

I've opened up regedit and searched for 'ginstaff.mdb' and it turned up no results.