Remote access to a ms-access db

[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

 

[Arvin Meyer]

I use asp pages to connect to an Access database and it works quite well
both on the internet or on a corporate intranet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Hans Jakob]

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

 

[Albert D. Kallal]

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