I currently have an MS Access Database that uses adodb recordsets for retrieving data from a remote MS SQL server database that is currently exposed to the internet. Having the database exposed to the internet in this way is bad practice and is open to it being attacked. The alternative is to create an API web service on the same server where the SQL Database resides. I would then like to have 4 basic web api's that can be used for Creating, Retrieving, Updating and Deleting records from a single table. I can already programatically call an API service using VBA with help of the WinHttp or Microsoft xml v6.0 object libraries from within MS Access. I need to have a web service that will receive http calls and return responses in Json notation.
9 freelancers are bidding on average £150 for this job
Create, Retrieve, Update and Delete API web service Relevant Skills and Experience Microsoft Access, Microsoft SQL Server, SQL, VB.NET, Visual Basic 7 years experience Proposed Milestones £88 GBP - task
Hello, I have very good experience in building APIs .. I got understand that you are looking to develop a new web API service. please message me. we will discuss in detail. Thanks, Sheik