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.
26
questions
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 ...
- 21
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/...
- 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 ...
- 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 ...
- 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 ...
- 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. ...
- 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 ...
- 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).
...
- 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 ...
- 75k
-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 ...
- 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 ...
- 668
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 ...
- 668
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 ...
- 668
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 ...
- 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 ...
- 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.
...
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 ...
user109261
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 ...
- 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 ...
- 41
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 ...
- 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.
<...
- 315
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:
...
- 315
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 ...
user28366
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 ...
- 629
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 ...
- 75k
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 ...
- 75k