Automatically update db to web (1 Viewer)

[dcorey]

Hi, everyone.

My company would like to set up a website where clients could look up the results of lab tests we do for them. I have a working prototype written in ASP and using a "mini" version of our in-house database. My question is, what is the best way to update it?

I want to continue using a mini version of the database, since it's not necessary for all of the data to be on the web. I figure that updating the web database once a night would be sufficient. If anyone has had experience with this or has any good ideas on how to automatically create and upload a stripped-down version of the db, it would be greatly appreciated.

Thanks!
-dcorey

 

[jonnie_c]

Are the Dbase and the Website on the same machines? Different machines? If different, are they on the same Local network?

 

[dcorey]

We're small, so we don't have a server or anything. The website is just through a hosting service.

 

[jonnie_c]

oh. that shoots my ideas on the matter to heck then

 

[John.Woody]

Look up transferdatabase. If you create one query for each table you wish to put in the web db, you can use transferdatabase to transfer all the info into the web db and then upload the web db to your site.