I have a test database set up on an Internet site.
This is the code I use to try to get a recordset returned from it (using VBA in Access 97).

Dim Conn As New ADODB.Connection
Dim RemRs As New ADODB.Recordset
Conn.Open "Provider=MS Remote;Remote Server=http://WireMagic.com;DSN=ADOTest,UID=Admin,PWD=password"
RemRs.Open "Table1", Conn, adOpenStatic, adLockOptimistic
NumRecs = RemRs.RecordCount
Conn.Close

When statement REMrs.Open executes I get an error 8447 Internet server Error.
The WireMagic web site is accessible from the web, so the telecommunication connection itself is not the issue.

Any one get similar errors previously and find a solution for it?

Thanks in advance for any help,

Bob