Unanswered: Accessing MS-Access database remotely from ASP.NET
I have 2 systems which have public(static) IPs. One system is a Windows XP system hosting the ASP.NET site. The other system is a Windows 95 system having Ms-Access 97. The ASP.NET application needs to pull data from MS-Access on Windows 95 system.
I need help on how to connect these 2 systems remotely.
Not sure if I understand what "connect these 2 systems remotely" means, but it sounds like you want to create linked tables from the older database to the newer one.
I'm not sure how high of a level MS Access will allow linked tables to a '97 version (you didn't mention which version of Access is on the XP system). Depending on where on the network these are, you may want to use a UNC path when linking.
Also, are you going to be writing back to the '97 database from the newer one?
Anytime you expose resources to an externally facing IP there are definate security concerns.
You should restrict access for that directory to the ASPNET user account only, which is what IIS acts under for accessing UNC shares unless you've enabled delegation in AD and impersonation in your web.config file.