Connect to a database on anther server

I have my access database on a xp workstation setup as a web server using IIS. I am trying to access the mdb from another web server, but when I run my code below I keep getting :

Microsoft ADO/RDS error '800a20ff'

Internet Server Error.


Set conn=Server.CreateObject("ADODB.connection")
Set rs=Server.CreateObject("ADODB.recordset")

Conn.Open "Provider=MS Remote;" & _
"Remote Server=http://100.100.2.90;" & _
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Temp\Test.mdb", _
"admin", ""

Chances are it's some kind of permissions/security error.

Remember that IIS has its own user called something like IUSR. It needs to have the right permissions to the folder's remote DB. Could be that.

How can verify the security settings on the shared folder?

I haven't set up for access to a remote DB, but if it was a local DB, then you would right click on the folder to get Properties, and it would be under the security tab. If you can't see the security tab, then you need to turn off simple file sharing.

The IIS user is called Internet Guest Account(NAMEOFCOMPUTER/IUSR_NAMEOFCOMPUTER)

When I set up on my own XP Pro machine, I found I also had to give IUSR Read/Write to the Windows/Temp folder, or it wouldn't connect to the DB

You may be able to guess from this what you need to do. (This may not be the problem at all, but I have a strong hunch that somewhere you need to set a permission).

Make sure the "admin" account exists on the target computer and that its password really is a null value ( "" ).

On a side note... this is very interesting to me since I didn't think MDB databases could be accessed on a remote server. I'm connection to one of my own fine, but I can't pull up records from it. Where are you getting your code for this from?