Click to See Complete Forum and Search --> : Database Access from Web Server


madhu_j
May 1st, 2007, 07:50 PM
Hi,
I am developing a software using VB.NET 2003, which has to update an MS-Access 2000 database located in a web server, apart from maintaining data in the local - client system.

The client database is updating properly in the local harddisk.
How to specify connection parameters for the server database(MS Access-2000) located in the website?

Whenever any updation is made in the local database, it should automatically update the database in websserver also.

How to connect to the server database using VB.net-2003.

Thanks in Advance

-madhu_j

TheCPUWizard
May 1st, 2007, 07:54 PM
You can specify the connection via IP address [IIRC, this is supported by Access, I know it works for SQL]...but...

It is usually better from a security and system perspective to implement a WebService on the serer system and use that to communicate with the Dabtabase.

The real decision needs to be based on the details of your requirements....

madhu_j
May 2nd, 2007, 06:40 PM
Thanks for your response.
How to connect with server database by giving IP address using MS-Access?
IP address followed by server path for the database?
I don't know the exact syntax.
Please help
Thanks.