Updating a remote database which sits on a secure windows 2000 server
Posted on 2005-05-10
I have a website that reside on a multi domain server provided by my ISP. I have developed a program that browses for images on local disk, you also fill in a few details and it uploads (FTP) the images, the data (what you've filled in your text boxes, the value of checkboxes, etc......) onto the server. No problem so far. Now along with the images and data, I also upload a text file that contains a SQL statement (INSERT INTO tblName .........).
To actually enter my data into the MS Access database which sits on the server, I need to execute the SQL statement. So using FilesystemObject I scan all my folders for the existance of this text file. Once I find any, I run it and providing the INSERT is successful, I delete the text file that contains the SQL statement. The whole thing does work, but something tells me this is not very elegant. Do any of you out there have a more clever way of updating a remote Access database? Please remember that I eventually intend to distribute this program and it will be up to a 200 users uploading their data onto the server. I also have to note that my ISP doesn't actually allow any settings, registry of the server to be changed, so I may have no choice but to go for a dedicated server.
I'd appreciate your inputs
Thanks - Med