Questions tagged [adodb]

ActiveX Data Objects is Microsoft middleware for accessing data sources. ADODB allows to access data from various languages without knowing how the database is implemented. Successor of RDO (Remote Data Objects) and DAO (Data Access Objects), first introduced in 1996.

Filter by
Sorted by
Tagged with
2 votes
1 answer
99 views

One way Synchronize 2 Access Tables with VBA ADODB

I am synchronizing two MS-Access databases. One of them on a network drive, the other one on the local machine. (For testing purposes both in the same directory) The Databases both contain a table ...
MZiegaus's user avatar
2 votes
0 answers
322 views

SQLite C/ADO VBA library with reflection

SQLite C/ADO VBA library with reflection The SQLiteCAdo library is a VBA middleware facilitating access to SQLite databases. Its two subpackages provide alternative connectivity options: via ADODB/...
PChemGuy's user avatar
  • 425
0 votes
1 answer
209 views

DbRecordset: Updatable recordset with transaction and affected rows count check

DbRecordset is a new class added to a fork of the SecureADODB library, which wraps the ADODB.Recordset class. It complements the functionality of the DbParameters class from the previous post and ...
PChemGuy's user avatar
  • 425
2 votes
0 answers
85 views

Extending the SecureADODB library

SecureADODB is a very instructive VBA OOP demo. I have played with SecureADODB for a while and plan to integrate it into the prototype of my database manager application. In my previous post, I showed ...
PChemGuy's user avatar
  • 425
1 vote
0 answers
131 views

ContactEditor - Excel VBA db app: Storage Library

ContactEditor uses Excel VBA as a prototyping platform for a personal information manager combining the "Model, View, Presenter" (MVP) pattern and a persistent storage manager. Fig. 1. Data ...
PChemGuy's user avatar
  • 425
7 votes
1 answer
290 views

VBA-Sync code feedback

I was hoping to get some input on a class module I'm designing to abstract away the boilerplate of utilizing asynchronous queries in VBA. cQueryable supports both synchronous and asynchronous queries. ...
beyphy's user avatar
  • 171
4 votes
1 answer
407 views

Creating a values only copy of an excel workbook without opening it

I have created a working VBA script that allows the user to select a workbook and make a values only copy of it without opening it. This is useful for getting data from a workbook that is very slow to ...
S. Melted's user avatar
  • 221
1 vote
0 answers
15 views

there are a better solutions to set FIELDS as data at ADODB query from xls file (exported from SAP)

My excel program import from another workbook, exported from SAP, some columns to update my dashboard. To do this I use ADODB, the code run right and fast (26K rows and 32 columns on 00:00:26:1226). ...
Fabrizio's user avatar
  • 307
11 votes
3 answers
348 views

Secure ADODB: Unit of Work

I've been meaning to revisit this old code for a long time, and this week finally ended up doing it. The resulting code is on GitHub, and for full context and disclosure I wrote a blog article about ...
Mathieu Guindon's user avatar
-1 votes
1 answer
26 views

SQL Group qry by codeProduct and Last(description) [closed]

For the ADMIN: I wrote this tread on S.O. questions/61183026, but I think that is more correct to post this tread here, if you think no, please scuse me and delete this message. Hi, I've one xls ...
Fabrizio's user avatar
  • 307
4 votes
1 answer
1k views

Getting Windows User Info From The Active Directory

I took some boilerplate code that I have been using for determining an active windows user's info to either send emails with their details, or to pass to a error logging class, and encapsulated it in ...
rickmanalexander's user avatar
6 votes
1 answer
351 views

ADODB Wrapper Class (Revisited)

I recently posted this question on my implementation of an ADODB Wrapper Class. I realized in my own review that I was missing some very important things, so much so, that I decided it would be worth ...
rickmanalexander's user avatar
2 votes
1 answer
520 views

ADODB Wrapper Class

I use ADO (specifically for accessing SQL) daily at work. So, I finally decided that I was going to create a class that makes it simple for myself and other programmers on the job to use. Just the ...
rickmanalexander's user avatar
1 vote
1 answer
2k views

Node.js DataBase class for adodb databases

A while ago I was working on a multipurpose database class (an es6 javascript class) that works with any database supporting adodb. This class is a wrapper on the "node-adodb" npm library. This ...
MilesZew's user avatar
  • 167
2 votes
1 answer
529 views

Executing arbitrary SQL statements using VBA in Excel

I built a workbook to help me extract data from a MSSQL database into Excel. I realize that this is fairly easy to do with Microsoft SQL Server Management Studio, but I can't easily get that installed ...
neelsg's user avatar
  • 173
0 votes
2 answers
147 views

Run a query for each value in a column

For each ID found in Column A in the XLS file, run a query to retrieve and save a customer. ...
Ruby Harris's user avatar
2 votes
0 answers
99 views

Programmably Typing the Tables, Views, and Columns Properties of a Database

Programmably Typing a Database gives you the advantages of Intellisense and Compiler Type Checking. Notice that single public DatabaseAlias variable of public Type DatabaseAlias is used. The ...
user avatar
5 votes
1 answer
14k views

Passing multiple parameters to an SQL query

I am trying to use this VBA code to pass a SQL stored procedure multiple values from an excel sheet. In order to have the procedure run multiple times and insert multiple sets of information into the ...
mag123's user avatar
  • 51
4 votes
0 answers
836 views

PowerShell GUI to display information about users

I have a GUI file which is currently being ran by VBS, but I have a few issues: PowerShell v2 is what is being run on every machine and I cant change that, runs very slow on first time launch. it ...
Visar Baci's user avatar
4 votes
1 answer
4k views

SQL + VBA Populating Data in Cell Range

I currently have a code that is connecting to SQL database in VBA. The data is populating correctly. However, I was wondering if there is a way to condense the code below. I have 4 different columns ...
Sagar S's user avatar
  • 41
3 votes
2 answers
232 views

Populating fields from stored procedure

I was just wondering if my code below is a good way of populating data from database. I have had no issues with this really but I am being taught this and just wondering if it is the best practice. <...
Richard Glass's user avatar
2 votes
1 answer
8k views

Calling Stored Procedures with Lots of Parameters

I have this piece of code for running a Stored Procedure, and I was wondering if there is a way of cutting code like: ...
Richard Glass's user avatar
15 votes
3 answers
2k views

Creating an object oriented model in VBA using COM and ADODB from 2 depended SQL tables

The story... A bit of background info and how is the database designed... Please notice you don't really have to rebuild the tables in SQL but I shared an SQL Fiddle just in case and screenshots1 of ...
user avatar
24 votes
1 answer
2k views

Executing large SQL script file with GO statements using ADO

I wrote a small component (still in the works but working) which takes a large SQL script file, splits it into different "blocks" based on GO statements, and executes them one by one. The only major ...
Jerry Dodge's user avatar
14 votes
4 answers
3k views

Materializing any ADODB Query

Following-up on Creating ADODB Parameters on the fly and pushing the "wrapping" of ADODB a step further, I have written two more classes that allows me to expose methods that don't require a ...
Mathieu Guindon's user avatar
33 votes
5 answers
16k views

Creating ADODB Parameters on the fly

I have put together a small wrapper class to simplify creating parameterized ADODB queries with VB6/VBA. At this point I'm keeping things simple, so it's only supporting input parameters and from what ...
Mathieu Guindon's user avatar