Hi all.
I have an app that runs on my computer, not on a network. The database is Access, app is VB
I want to make online "junior versions" that can import some of the tables from my pc's db. It won't be that complicated though. I want to export the tables from my hard drive db (I guess using the RS.Save method) and then FTP or INET the tables of data to my website and
Then...
go to a page on my website and import the data into the online database, so that the data can be used by the junior applications online.
Likewise, those apps will enter records in one of the tables of the web DB and I will have another webpage that can extract all that data to one file on my server, and go BACK into VB and import those records into the same table in my PCs DB.
Is there an easier way? This app has to stay on the hard drive, so does the db, and I cannot grant access to it via internet.
What would be the way to export an entire table/RS from my DB to a file on my server that could be imported by the web DB?
And vice versa?
Thanks all.
Wengang




Reply With Quote