Search code examples
delphims-accessweb-sql

How to connect Delphi to remote MS Access Database through the internet?

Possible Duplicate:
How to connect to an Access 2003 database located on a web server via HTTP?

I have a working Delphi program that uses a MS Access Database to obtain reports etc. Now I want to migrate the database to a webserver running my website. The website must be able to connect to the database as well, to update data (users inserting contact details as an example).

How do I now connect my Delphi program to the database which is now on the webserver, without losing any functionality? Is this possible?

Thank you for any help.

Solution

  • One of the cases is to provide DB computer IP-address in ADOConnection.Connectionstring:

    Data Source=X.X.X.X,Port