Hi, I'd like to connect several Access and Excel applications to SQL Server databases to take my clients to the next level with a modest enhancement. It would be simple if I could expose SQL Server to the web, but this seems out of the question for security reasons.
Ã?Â
I plan to make a client .NET app that calls a web service (which queries SQL Server and passes back a DataSet) and then updates� an� MDB on the client workstation, for instance to get the latest version of data to report on.
Ã?Â
Do you see problems, or suggest a better approach? Thanks!
...
Go to the complete details ...