Connect Access with MS SQL Server

I have an Access database application using Access tables, and a separate web-based application using SQL Server backend. I need certain fields (about 5-10) to be updated from Access to SQL Server and vice versa. In other words, field data from Access will need to be copied over to SQL Server, and SQL Server will need to be copied to Access. Only certain fields. The process could be fully automated and run in the background periodically, or 'on demand' via an Access form. The process will be initiated from Access, unless there is a clean way to initiate it from SQL Server. We should also create an update log, which records the results of the process each time it is performed. The rules regarding which fields to copy over should be relatively easy to change as we will be refining this process for a while. The connection string for the SQL database will need to be stored in Access somehow, or it should be easy to change. ## Deliverables 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). ## Platform MS Access 2000 MS SQL Server 2000