I need a way of replicating an Access database over the internet. I am open to all suggestions but do not want to use replication manager as I can no longer purchase it. I would like a tool to sit on the server computer that will allow a remote user to sync the changes with there server. The client will have an active x control or vb application (command line program) that can be called to sync the database. Also I would like another tool to connect to the server to create a replica on the client’s machine. To clarify: 1. Server Application The server application must be written in VB6. I want it to listen for sync requests from the client. I also want the ability to send a SQL statement to be executed on the server’s database. 2. Remote User Application The remote user application will allow the user to request to sync their replica with the design master over the internet. It must be able to transmit changes both ways and then send a sql query to the server. It will also send the login details to the server (username and password and replica type) for the server application to run a query to check to see if the user can sync. This function will return a record if they can sync (I will write this query later). I am open to indirect as mentioned in this article: I would prefer not to be able to have the hassle of setting up a VPN or IIS on the server. But I would prefer the server to run IIS if you need this. We have had trouble setting up a VPN server and client in Windows XP so we don’t really want to go down this path. Please explain how you will complete this task so I can present this to my employer. We are interested in someone who can perform this job quickly and be able to do it for a competitive price. Thank you for reading my requirements and I look forward in working with you. Kind Regards, Mark
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Windows XP Microsoft Access 2000 / 2003 Visual Basic 6 All code commented