Posting Microsoft Access Information “Into the cloud”

Adding a record

To get data into a Web2 website requires you to create an XML string with your new information then Post that information. This is subtly different to retrieving data as shown in part one of this article. The trickiest thing about programming in this environment is just finding a correctly structured (VBA code) sample to borrow from. Generally the samples online are written in trendy languages such as .Net or Ruby. Once you have that sample, you then fill the XML by plugging your data between the XML tags. Let's see how we do that.

Adding a new person to the Highrise Website from your Access application

Let's look at the full code that you need to add a person. This is analogous to an append query in Access and as you will see, it takes a lot more code to achieve the same result. I illustrate this with error checking because error testing is important to verify the data has been added. I will break down the code with descriptions in subsequent sections of the article.