|
Subject:
|
SOAP using VBA Access
|
|
Posted By:
|
bundersuk
|
Post Date:
|
12/14/2006 9:06:55 PM
|
Hi,
Not sure if this is the correct forum. Sorry if its wrong.
I have an Access Database with customer details which are filtered by queries and displayed in forms and reports. I have been asked to query data and transfer it to our other office. I have been told they want it transfered using XML and SOAP. The XML and SOAP parts have got me stumped. Struggling to get my head round it, can anyway guide me in the right direction. It would be very appreciated.
Thanks
Allan
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
12/15/2006 7:31:21 AM
|
Sounds like they are pulling your leg. Why would you use this interop function when the data is going from Access to Access? If it were going from Access to web (SQL/Oracle?MySQL, etc) or even... or the other way around... or from one system to another, sure. But not Access to Access.
When you say "tansfer," what medium will you be using?
mmcdonal
|
|
Reply By:
|
bundersuk
|
Reply Date:
|
12/15/2006 7:59:28 AM
|
The data is to be transfered on a daily basis to update there system because they are running the SMS system where customers can txt a number followed by there account number. They will receive a text back with upto date info. They are running SQL with a webservice. Thats why they said they want it sent using SOAP and xml.
|
|
Reply By:
|
bundersuk
|
Reply Date:
|
12/15/2006 8:01:42 AM
|
Soory I wasnt more specific.
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
12/15/2006 8:21:10 AM
|
You need to go to their system administrators to get instructions on how to do this then. Lotsa hurdles. Access will export data as XML, and there is code to do this, and ways you can send it, but they have to tell you what to do. Unless you are the system administrator.
Can you see the SQL server as a SQL server from your network? In other words, can you use a system DSN to connect to the SQL server?
mmcdonal
|
