'Moving Ms Access Database over cloud and access them by API on vb6 [closed]
I have a legacy application written in Visual Basic 6.0 (VB6) This application uses a read-only local database. It's an MS Access database (.mdb Extention)
I work with the data with ADO connection
I want to move this DB over the cloud with a new type of DB (like SQL SERVER) and access this data with REST API.
Is possible to read the data with the API in XML format and put them into a ADO RecordSet?
I need to manipulate these data by filtering them. What is the best way to do this?
Can I use a RecordSet or any other data types?
My idea is to change this code from:
SQLTmp = "SELECT * FROM Versioni WHERE Codice = " & DbCarVersioneScelta
Set RsDBCarVersioni = DBCar.OpenRecordset(SQLTmp, dbOpenSnapshot)
to
XMLFile = *API THAT RETURN XML FILE*
Set RsDBCarVersioni = XMLFile
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|