How to: Update Record (complicated)

Hi experts this is an urgent question. how do you import and export database online?

I have 2 equal database. I uploaded my FrontEnd(OPAC) and Database online. I have also a same database in my BackEnd(VB6) located in my computer. My problem is how do i update both database in every transaction done.

E.g. I added a record in my backend, the system will automatically update the database record online.

how can i accomplish this? is it possible? Tnx.

BTW im using VB6, ASP and Access

--
Kenneth
"Better Than Yesterday"

re: How to: Update Record (complicated)

Well because your BackEnd(VB6) database is located on your computer, I for one think you should create a desktop application in VB to push data up to your online database.

Can I ask you a question? Why is your environment set up that way? Can users update the FrontEnd(OPAC) database? If so don’t you need to push down that information to your BackEnd(VB6) database? Or does all data come from the BackEnd(VB6) database and get moved up to the FrontEnd(OPAC) database? If that is how it is set up then why not just give read access to web users to query the FrontEnd(OPAC) database and create a new database user to have the permissions you edit the FrontEnd(OPAC) database, then you can get rid of the BackEnd(VB6) database. Just asking so I understand your environment better.

Hope you get your answer~