Access to SQL Conversion

Thank you for your reply. After reading some of the responses from bidders I’d thought it would be best to better describe myself and the problem I am having. Personally my internet specialty is layout and creative. I am new to databases. In fact I began on unix in 1997 and it wasn’t until recently I switched to Windows Server and SQL, thus my lack of knowledge when it comes to them. Up until Jan 1st I had a very experienced SQL programmer working with me on various projects. He has since moved on to a high level programming job and regretfully can no longer assist me (strictly a time issue). SQL issue. The program I need assistance with can be found here: <[login to view URL]> It is written for Access DB. The program works perfectly until I display it on a heavy traffic page (500+ concurrent ??" 300,000 daily displays). At that point the DB can no longer serve up the ads. The ads will display the first few page loads then the errors and page freezes occur. Microsoft JET Database Engine error '80004005' Unspecified error Etc… Since I already have another type of Ad Rotation script like this using SQL I figure an SQL version of this script should work too. Upon the program authors request I upgraded the Access DB to SQL using the Wizard. I sent him the results via a text file: [login to view URL] He was unable to write a working conversion for me and suggested I seek an SQL programmer. The author is cooperative in finding me a solution for this and therefore my posting here. Hopefully this explains the problem I am having in better detail. Please reply back if you are still willing to assist on this and perhaps future projects. Thanks Webdeco ## 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 Script is hosted on a Windows Server, MSSQL and written in asp Thanks