by Austin K. Hayward (4 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: (15 Votes)
** PLEASE VOTE FOR MY CODE - EVEN IF YOU DON'T LIKE IT **
GREATLY simplifies accessing JET or SQL Server databases. No more Connection String, provider, data source, Persist Info etc. properties to fill in. Provides easy to follow instructions right inside the DLL.
Inputs
SQL - user id, password, authentication mode, server name, command text
JET - database name, command text
Assumes
A basic knowledge of ADODB is helpful, SQL statements (select * from whatever)
Code Returns
ADODB Recordset(s) - can be used as an array for multiple recordset retrieval.
Download DataAccessDLL (8 KB)