has anyone had the issue of having to upload/download between a client app written in MS Access and and non-microsoft database server? In this case, our server is a Macintosh OSX, running Apache, MySQL and PHP, and is behind a firewall but ports 80 and 443 are "open". The users need to enter data into MS Access while not connected to the internet. Changing the firewall restrictions is not an option.
So, i decided to have a look at using SOAP and have managed to develop a test web service & WDSL in PHP and tested the connection to it using Microsoft Office Web Service Toolkit. I'm hoping that this would provide the necessary interface & interaction between MS Access and our server.
Its relatively easy to code Access to dial a connection (if needed), upload data and download data, check if the user has the most recent version etc etc. I haven't looked at security yet.
However, SOAP seems very very slow. It takes up to 10 seconds to retreive a little bit of test data even when MS Access is "dowloading" data from localhost!
Has anyone used SOAP with MS Access? If so, whats your experience with performance? How did you manage security of data? In general, has anyone had to upload/download data between MS Access with a server database accross the internet?
cheers,
dan.
So, i decided to have a look at using SOAP and have managed to develop a test web service & WDSL in PHP and tested the connection to it using Microsoft Office Web Service Toolkit. I'm hoping that this would provide the necessary interface & interaction between MS Access and our server.
Its relatively easy to code Access to dial a connection (if needed), upload data and download data, check if the user has the most recent version etc etc. I haven't looked at security yet.
However, SOAP seems very very slow. It takes up to 10 seconds to retreive a little bit of test data even when MS Access is "dowloading" data from localhost!
Has anyone used SOAP with MS Access? If so, whats your experience with performance? How did you manage security of data? In general, has anyone had to upload/download data between MS Access with a server database accross the internet?
cheers,
dan.