How to: Update Records (complicated)

[werks]

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

[SheSaidImaPregy]

Yes it is possible, but in ASP you need to create two connections, one to each server, along with two recordset objects. Once you do this, just do an update on both. However, you need to make sure that your one at home is connected to the internet at all times.

If you do not wish for this to happen, then you need to manually create a page that grabs all records in the online database that are not within your home database. Then insert those. Use something like:

SELECT * FROM Comments WHERE CommentID IN (" & An array of your comment id's from yoru home database & ")

[werks]

How can i do that.. Please guide me through

[SheSaidImaPregy]

well, are both connected to the internet? If so, just create two connections:

conn1 = Server.CreateObject("ADO.Connection")
conn2 = ...

conn1.provider.. etc.
conn2.provider.. etc.

Then just grab your information from conn1 with an SQL statement:

SELECT * FROM Users WHERE DateCreated > (lastdateyoudidthis.Thisavoidrecordsrepeated)

Then just do a loop for insert statements:

while Not recordsetname.EOF
SQL = "INSERT INTO Users_Bak "....
conn2.execute(SQL)

recordsetname.MoveNext
loop

[sbv]

Hello,
This is good issue. And a nice solution.