Connecting to MS access db

[Dishaa V]

Hello I need to connect to an access db which is on the internet. I do
know that URL of the same. its http://www.vallury.com/balance/bank.mdb.
Its just a test db.

How can I connect to that db from either my desktop application or from
my intranet website.

Thanks and Regards




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Albert D. Kallal]

Re: Connecting to MS access db

"Dishaa V" <dishaa@vallury .com> wrote in message
news:40864328$0 $197$75868355@n ews.frii.net...[color=blue]
> Hello I need to connect to an access db which is on the internet. I do
> know that URL of the same. its http://www.vallury.com/balance/bank.mdb.
> Its just a test db.
>
> How can I connect to that db from either my desktop application or from
> my intranet website.[/color]

Connecting from your desktop, and connection via a website are two complete
different problems.
[color=blue][color=green]
>> How can I connect to that db from either my desktop application[/color][/color]

ms-access is a file share. Thus, you can't open word, or Excel, or any other
file across the internet. You can open a word file IF YOU transfer the file
to your local computer first..and then open it. So, open the above url..you
can click on it..but in fact you will wind up download a copy to your local
computer.

If you want to "link" to that file..then you need to use the linked table
manger..and YOU MUST BE ABLE to browse to the folder on that pc. That means
you need access to the directory's are that computer (you would need the
admins of the two computers to setup a network link between the two
computers so you could browse via the network neighbourhood to that file).
However, using a file share across the internet is too slow. You can read on
a solution and what the problems are at:

http://www.attcanada.net/~kallal.msn/Wan/Wans.html

[color=blue]
>or from my intranet website.[/color]

If the website is on that server, then those ASP pages can open, and read
and use the mdb file. Of course, with asp pages you are NOT using ms-access,
but only need the jet database engine. (none of your forms etc will work).
However, when using you IIS server, it will still need to be able to open
the mdb file. If you mean how can one web server connect to that mdb file on
another server..then again you have the exact same problem of "linking" to
the back end database (you need to be able to "browse to" the folder..and
open it). So, if you mean how can one web server connect to that mdb
file..then yes..both your questions are exactly the same!


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
pleasenonoSpamK allal@msn.com

http://www.attcanada.net/~kallal.msn