connect to Access DB via IP address

[Rabbit]

Hi,

Like SQL Server, is it possible to build the connection string using IP
address for retrieving data from Access DB(.mdb) ?

Because I'm implementing an application in which the program installed on
retail shops which has boardband internet access, but the database is
located on Data Center, they have different subnet mask. So far I can think
of using VPN is the only solution to connect Access database in data center.

Thx in advance!
Keith

 

[Steve S]

Build yourself a WEB Service to provide the data access you require.....

While security is always an issue when you float data over the WEB, (as it
appears like your wanting to do)... you can use a simple encryption method
to permit data to flow and still keep it within the scope of what can pass
through firewalls.... to authenticate WHO you are to keep most of the
hackers out....

 

[Rabbit]

Thx for your suggestion!

Build yourself a WEB Service to provide the data access you require.....

While security is always an issue when you float data over the WEB, (as it
appears like your wanting to do)... you can use a simple encryption method
to permit data to flow and still keep it within the scope of what can pass
through firewalls.... to authenticate WHO you are to keep most of the
hackers out....