Can't connect to Access DB with ODBC

Hi,
I am using WIN XP, IIS 5.1 and MS Access as database support. I set up the file security to include IUSR_MYNAME on the permissions list for all my web files, DB and scripts.

I set up and ODBC connection (system) and linked it to my Access database file.

I am however getting the same error when I try to load any ASP page on the line where I command the script to open the connection. Are there any local security issues I am forgetting?

This is what my connection code looks like in ASP.

Set conn= Server.Createobject("ADODB.Recordset")
Conn.Open "MyAlias"

that's where I get the error.
"Error type:
Provider(0x80004005)
Unspecified Error"

Now I know this code works, because it work on my WIN98 machine and another WIN XP machine at work . Can anyone help please?

Mike

Please post your question only once.

http://forums.devshed.com/t106863/s.html