Remote access to a ms-access db

  • Thread starter Thread starter Hans Jakob
  • Start date Start date
H

Hans Jakob

Hello

On my webserver I' ve got a ms-access database running. Now I would like to
establish a remote access to this database, like the same I know in mysql.
Are there any possibilities via ODBC-driver and over HTTP-Protokoll to
access onto a ms-access db?

Thanks a lot.

Cheers - Hans
 
Hello Arvin

Thanks for your answer.
But the reason of the remote access is, that I need the data in my local
ms-access db to make different querys and then I make an export to excel.

Is there possibility to make an connection over http-protokoll like I know
it with myODBC and mySQL?

Thanks a lot.

Cheers - Hans
 
The problem is that you can't really use a odbc connection to ms-access.

You can use a ADO odbc connection to ms-access, but you always must
"resolve" to a actual file name.

Like word, or like excel...ms-access is simple a file share when using a mdb
file.

You can't connect to Excel, or Word across the internet, nor can you do the
same with a standard ms-access file (so, in this regards..you have a simple
file...just like word, excel, power point etc.).

So, you simply have a file here, and to use it you MUST BE ABLE to browse to
a folder, and "see" the file name.

Further, using a file share across the internet is NOT fast enough.

If you need something that gives you a remote socket connection over the
internet, then you use the free desktop editing of sql server included on
the office cd..

I outline some of your choices to solve this problem in this article:

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