Search results 24

Sorted from new to old.

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Mar12

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

USB format in Android

What is the best format to use a USB storage for using in Android phones and ...

2023Sep28

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

List of Databases

Script to list databases available in a server using ADODB connection From

2019Oct6

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3

1 2