By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,162 Members | 1,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,162 IT Pros & Developers. It's quick & easy.

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

P: 4
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.
Jul 13 '12 #1
Share this Question
Share on Google+
4 Replies


jhardman
Expert 2.5K+
P: 3,405
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
Jul 13 '12 #2

P: 4
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?
Jul 13 '12 #3

P: 4
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').
Jul 13 '12 #4

P: 4
I've opened up regedit and searched for 'ginstaff.mdb' and it turned up no results.
Jul 14 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.