Hello Friends,
I have a web application where data are stored in a SQL Server database by using an online form in the website. Now I want to have an offline application which will store data temporarily in DB (say MS Access) and later on the data will be converted or uploaded to the online web application. Is this possible? Please give the solution.
Option 1. You can try to create an odbc connection to your sql server with its ip address and then use link tables and add some append queries.
Option 2. You can add a web service on your web server to access your sql server database and then add the following three references to your local Access file: Microsoft SOAP, Microsoft XML and Microsoft ActiveX Data Object Library. You will be able to program in vba to upload offline Access data to your web server database. P.S. you may be able to find some useful information on the tech support page at [snipped].
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.