You should create a SOAP v2 client (with vba) in MS Access 2007 (run on 32 bit Microsoft) that are able to;
1. - download order header data (customer data, delivery setup, messages, ...) and order row data (articles, text, quantity, price,...) and save it to ONE local Access table (table setup will be given at a later stage) - only get order data after a defined date/time stored in a settings table
2. - download new articles (articles that has been changed since stored date in table (a settings table)
3. - upload and change order status to a defined value for a given order number reference
4. - upload new stock level data for a given article reference number
The code will be "cut out" to an existing MS Access database, so no time need to be spent on the design of the user interface. The SOAP client must be able to handle diffrent "shop numbers" in the same Magento installation. We need to be able to work with diffrent shop (on same Magento installation, or separate servers).