adodb | PHP 's database access functions | Database library

I have a piece of VBScript that queries an MS Access database. When the recordset query is on a table, I can go through my recordset and do a rs.MoveFirst to go back to the beginning. But when the recordset query is on a query, rs.MoveFirst fails with the error "Operation is not supported for this type of object" Code: 800004005.
Is this a known limitation? Can I get get around it by opening the recordset in a different way? I have tried rs.Open like many examples online, but rs.Open strQuery, Cn, adOpenDynamic, adLockPessimistic, adCmdText fails with "Arguments are of the wront type, are out of acceptable range, or are in conflict with one another."

This code works because MyTable is a table:

The following code creates a new access database and copies tables from two different access databases into the new one. This part works without error.

The problem is on the following line: TMPConnection.Open TMPConnectionString
It notifies that the file is already in use.

The following 2 queries are taken from tables on different databases

I have developped a VB.Net DLL that can read Postgres, Oracle and OleDb.

To allow this DLL to execute some SQL commands, I pass it a Connection object and I use it to execute some SQL SELECT command.

My problem now is that I want to pass all data contained in a GridView object that contains data obtained using a SQL command in EXE program (not in DLL) and that user can have changed.

Which type of object can I pass considering following constraints ?

1. argument passed cannot be a WinForm control as DataGridView (no Winform object in DLL)
2. another database's table cannot be filled with DataGridView content (not performant)
3. class used must be part of an .Net assembly (not a COM, too old technology)

Until now, the only solution found consist of using ADO or Microsoft ActiveX Data Object Record Set, but this class is not an .Net assembly and solution found on DataBase Journal does'nt work because Items property of Field class is Read Only.

Here is my code

Good afternoon,

I have got a "program" in VBA that has to write in a SharePoint Online list.

Problem:

I used to insert data from an excel file (via VBA) to a SharePoint 2013 list by connecting directivity to the database underlying (via ADODB connection).

With SharePoint Online this is no more possible, indeed I had to come up with a different solution by using CSOM (C#) library.

After struggling for a week to perform a well-done insert that satisfy all my needs…now I am stuck.

Goal:

I need a way in which VBA code can cast my insert (C#) by using the parameters that I communicate via VBA => Full Process/idea explained

I found some references c# - How to call .NET methods from Excel VBA? but for me it is difficult to implement it to my code.

This is my current code:

I'm trying to get data out of my ordered dictionary, and for some reason it's not printing the data in it. I can get to the first item in the data structure, but I'm having trouble iterating over all the rows. I'm using PowerShell 5.1 and visual studio code.

The code queries an mdb file, and returns multiple rows.

In Excel VBA with the SQLite ODBC Driver, my simple SELECT query run against a single table retrieves 'long' integers (10 or more decimal places) incorrectly. How can these values be retrieved correctly, without truncation or whatever garbling is going on?

(PLEASE NOTE: the database structure/field definitions can't be modified — the database belongs to an open source application, Anki, and changing the structure would break the software.)

The particular table I'm querying contains (at least) several fields that can contain longer integer values (10 or more decimal places). The primary key ("id") contains Unix timestamp (datetime) values, with milliseconds, so the integer in the primary key field always occupies 13 decimal places.

Here is the table definition:

For the code listed below, it runs fine except for the first SQL query. I'm pulling address and state information from the workbook, and running a query on the information to find the count of how many times the address appears in the table. If I run the code and stop it before the query is sent to Access, I can pull the query command from the Immediate window, go to Access, and run the query no problem. However, if I just run the VBA program and have it send the query to Access, I keep getting 0 for the result. So long story short, the query will run in Access and provide the correct result, but when Excel VBA sends the query to Access, I keep getting zero for the result (and no error messages). Any help would be greatly appreciated.

The VBA code for external connection has been given to my by our IT-department. I did not wrote it myself. I just made some adjustments to make it work for my database. I am not an expert. The function Clear_Analysis just deletes all records from tabel tbl_Analysis. The function Analysis_Check does work in all my other functions. I want to check if a table contains any records.