Hi All,
I tried this post in the Access VBA forum but got no response so I thought I'd try it here too.
I have a small Access 97 database storing descriptive fields for codes that exist in a number of other systems. I have very little knowledge of XML (just what I have picked up from the FAQ's).
I have developed a template (in Access97) for users to request updates to the data (including an approval process through lotus notes - since most requests will come from users that do not have access to the database itself). As a part of this process, I attach a file containing the fields for updating. Once approved, these files will be saved to a directory and uploaded into the main application.
My Questions:
1. Should my extract be in XML format for future compatability purposes, or should I stick with file formats I define myself? It is possible that other processes may want access to these files at some stage.
2. If so how do I create the XML file in the Access97 template (to attach to the e-mail) and how do I read the file for upload into the main application?
Any thoughts would be much appreciated.
Cheers,
I tried this post in the Access VBA forum but got no response so I thought I'd try it here too.
I have a small Access 97 database storing descriptive fields for codes that exist in a number of other systems. I have very little knowledge of XML (just what I have picked up from the FAQ's).
I have developed a template (in Access97) for users to request updates to the data (including an approval process through lotus notes - since most requests will come from users that do not have access to the database itself). As a part of this process, I attach a file containing the fields for updating. Once approved, these files will be saved to a directory and uploaded into the main application.
My Questions:
1. Should my extract be in XML format for future compatability purposes, or should I stick with file formats I define myself? It is possible that other processes may want access to these files at some stage.
2. If so how do I create the XML file in the Access97 template (to attach to the e-mail) and how do I read the file for upload into the main application?
Any thoughts would be much appreciated.
Cheers,