I want a dependable routine that takes a JSON response from our external system and synchronises it with an existing Microsoft Access database. The focus is strictly on customer Contact details and Account status; the solution should leave every other table and field untouched for now. Scope of work • Build or integrate a parser that ingests the JSON payload (the format is consistent and can be shared once the project starts). • Map JSON fields to the corresponding Access table columns for Contact details and Account status, updating existing records or inserting new ones as needed. • Include solid error handling, transaction-level rollback, and a concise log that flags any records the script could not process. • Design the routine so it can be triggered on demand or scheduled, with clear instructions on how to adjust the connection string or API endpoint. • Provide concise documentation and a simple test data set so I can verify the update before we go live. Preferred tech Native VBA within Access is fine, but I’m open to a small companion utility in C#, Python, or PowerShell if that achieves cleaner JSON handling. The final solution just needs to run locally without extra licensing costs. Deliverables 1. Source code and compiled file (if applicable). 2. Written setup guide and field-mapping reference. 3. One brief call or screen-share to walk through deployment and testing. After this phase, I may expand the sync to Order history and Product details, so please keep the code modular enough to accommodate additional endpoints later.