Connecting DB on other server

I use this string today:
Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath ("db/data.mdb")

is it possible to use something like
Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
http:www.another-server.com/db/data.mdb")

Maarten.

Re: Connecting DB on other server

Maarten wrote:
> I use this string today:
> Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath ("db/data.mdb")
>
> is it possible to use something like
> Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
> http:www.another-server.com/db/data.mdb")
>
> Maarten.

No. It has to be a file path (Access is a file-based database).

See www.aspfaq.com or www.able-consulting.com/ado_conn.htm for ideas about
connecting to an Access database on a remote server.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Connecting DB on other server

See http://www.aspfaq.com/2168

(Hint: you need to know specifics about the file system on the remote
server, and hope that they don't change.)

--
http://www.aspfaq.com/
(Reverse address to reply.)




"Maarten" wrote in message
news:F%0id.9342$EC6.452747@phobos.telenet-ops.be...
> I use this string today:
> Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath ("db/data.mdb")
>
> is it possible to use something like
> Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
> http:www.another-server.com/db/data.mdb")
>
> Maarten.
>
>