connecting to a remote access database

[Bluemonkey]

how can i get this bit of code to conect to a databse thats on another server

strconn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("users.mdb")

sqluser = "SELECT * FROM users WHERE Username = '" & request.Form("Username") & "'"

set rs = server.CreateObject("ADODB.Recordset")

rs.Open sqluser,strconn,2,2


thank you for your help

[whammy]

Is the server on your LAN?

[Bluemonkey]

nope its on the internet

[whammy]

I don't personally know of any way to connect to an Access database on a remote server (and I am fairly sure it isn't possible - which is a great thing!!!)... if it was on a LAN, you could simply browse to the server through "My Network Places" and get the path to the database that way.

Why would you need to look at an Access database that was in a completely different location?

If it's the same company, or a client, etc. you could always have them send data to you on a regular basis... I have some clients export their data to me in whatever text format and import into access since it is not very much data.

[scroots]

it might not work but, in asp you can put some code in a page and it will tell you the address of the page, run the page to find out the directory and then just put it in your code.



scroots

[BigDaddy]

Server.MapPath("users.mdb")

The above code would mean that the database resides on the server, hence the "server."

If you want to hit a database on another machine, you'd have to be able to map a drive to that machine, etc. You can't get to it by just giving it the ip address and browsing to it.