Haylp

[doppelganger]

Hey guys, I'm pretty new to this kind of stuff, so bear with me here. I just received a huge new account for my business, and i'm trying to meet some of their needs, but i've never dealt with any of this before. I'm computer savvy, but not really web-creating savvy.

Anyways, heres what has to happen: I have an ordering page on my site already made with all of the fields and everything, and those fields are being sent to an Access database. (i know, i know) Now what i wanna do is save everything in my access database to an xml daily (preferably automated, but i can't figure that out), and then clear the current info out of the database (not the columns or whatever, just in the info in em) and start with a fresh one daily. I know this is best done using SQL and all of that, but I have neither the time nor money to do this, so consider that not an option. I can probably figure out the automated xml part of it, but how do i clear this database and start fresh everyday? Theres alot more to it, but these are the only things that i can't seem to figure out, and i have a week or so to do this. What are some quick and easy ways to accomplish all of this?

Thanks a bunch,

-Trey

[doppelganger]

Well i didn't think about this before, but i could copy my .mdb into another folder, then write a batch file to go through everyday and copy it to the folder the existing one is in and overwrite it. Problem solved there.

Any suggestions on how to automate the xml part of it? Thats the last step i have to overcome! :D

[TheBearMay]

Access has an export as XML function available for tables and forms.

[PeOfEo]

what kind ofdata are we talking about. Seems to me you can do best with asp or asp.net by creating an rss feed if this is news or something similar.

[doppelganger]

Originally posted by TheBearMay
Access has an export as XML function available for tables and forms.

Yeah, i had checked that out. My problem is that I can't always be around to go through and manually export all of it out, so i was looking for some type of automated way to go through and extract it. A WSH file with some type of javascript way of doing it would be nice, but i have yet to find something like that in my previous searches. :(

[doppelganger]

Originally posted by PeOfEo
what kind ofdata are we talking about. Seems to me you can do best with asp or asp.net by creating an rss feed if this is news or something similar.

Its for a hospital, and what i'm doing is taking orders for a charity event they hold ever so often. I've made a page in asp that has all of the information fields and all of that, which then saves into access. From there i have to extract all of that info into xml form, encrypt it, and send it out to them. I've taken care of every other part but the xml myself, but this i'm just having a big problem with.

[PeOfEo]

Then just write the data to an xml data base. You can keep the access if you have grown attached to it but you can use xml as a data base too and update it with sql statements. You wont get the kind of functionality you get with access if you try to go all xml I think, so you might run them side by side.