| |
You are here: Experts > Computing/Technology > HTML/XML > XML > XML Usage Scenario
Topic: XML
Expert: Alexander Radev
Date: 3/29/2007
Subject: XML Usage Scenario
Question
Alexander Good Morning,
I would like to harness XML in the following scenario, and I would like your advice on what tools & how to start / proceed please.
I have an MS Access/SQL Server application used on a single pc/laptop. The Access app generates a report of a 'fix' that needs to be done by a remote Systems Dept.
I would like to generate the XML files from Access 2003 (ok with this), then somehow link these to a 'form' that can be emailed to the SysAdmins team, who then do the fix requested and update the data in the XML files.
The SysAdmins then sent the Form and XML files back to the Access app owner by email, who reads the XML data into the database, via a VBA module.
What is the best way forward ?
Many thanks in anticipation
Kind regards
Geoff Johns
Answer
I will recommend you to use .NET platform and setup a server that accepts request at the Systems Dept. side. This can also issue work orders and also issue reports back when the work is completed (or changed state).
There are many approaches to do such system, but since I am guessing you are more comfortable using VB/Microsoft platform - this is the path I am going to recommend. And since the communication will happen via XML, this leaves room for reimplementation in a different platform (say Java, PHP, you name it).
If you have further questions, feel free to ask me!
Best Regards,
Alexander
Add to this Answer
Ask a Question
|
|
