I'm trying to create a xml file that automatically updates with all the entries from my Microsoft Access database. It seems like it should be an easy task, but I don't have much experience with xml at all.
My database is hosted online at www.***.com/fpdb/webeditor3.mdb and I just want to retrieve and display the Title and Description fields for all the items from a table in the database called Results.
Can anyone help me out to what the code to use for this is? Would this file be saved as .xml or .asp or .aspx or what? Also, the server I'm using doesn't support PHP, so any solutions using it wouldn't work.