Database Synchronization

[query4u]

Hi,
I am developing an application in Vb6.0 & backend as MS-Sqlserver 2k. this application is client-server & also i am developing for web.in this my database will be at offline server & same database will be on webserver. now i want to synchronize those two databases which r offline & which is on web, means whichever update,delete,insert operation will take place at offline or db on web should affect both db.if i delete or update any record at offline db, when i will run db synchronization code then same updation should affect the db which is online.
i got db synchronization s/w but it just synchronize the structure of db but not the records.Is this possible using vb6.0?Please anyone tell me how to do that.

i ve tried snapshot replication, but it is not solving my problem. i ve done it on local server.
I am using MSSQL Server 2k personal edition, it is not showing me transaction replication option active & when i select merge replication then it is not showing me objects,like tables in the database. please guide me.

[exterminator]

Please merge this thread with this one - Database Synchronization. Regards.