I have a need to read and write data to several Access databases on my web site in order to update/post this information for web visitors. The server is not in-house so we can’t make a connection to it locally over the network.
What would be a good VB/client-side application solution to send/receive data to this remote server?
Can I make a remote connection to it’s DSN?
Should I use an FTP control or transfer control or browser control?
Please be detailed in your explanation – code sample or specific articles or books, etc.
The remote site is running NT 5.0 with security.
(I am looking for a solution that runs in VB, not ASP/HTML using VBScript.)