Hi,

I have some users ofan app of mine and I need to allow them to export the data from the app (jet, DAO) and send it to a server and then import this data into a centralized database on the server. The good news is that I have already have done this. The bad news is that the way I have done it may not be that stable.

I am basically using ASP/vbscript to grab the uploaded export file (text) out of the upload directory and then import it into Access on the server. My thought originally was that with the right record locks this might be just fine (to prevent problems with concurrent uploads). But now I am thinking that maybe putting an exe on the server (Active X or something) might be better, rather than doing it with vbscript in an ASP page called by the uploader.

Any advice?

Thanks