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.
24 questions
2
votes
1
answer
174
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
432
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/...
- 415
1
vote
1
answer
253
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 ...
- 415
2
votes
0
answers
109
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 ...
- 415
7
votes
1
answer
359
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
494
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
11
votes
3
answers
407
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 ...
- 75.6k
-1
votes
1
answer
38
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 ...
- 297
4
votes
1
answer
2k
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 ...
- 698
6
votes
1
answer
431
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 ...
- 698
2
votes
1
answer
613
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 ...
- 698
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
580
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
185
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
106
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