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: 
(7 Votes)
DataAccessDLL's SUCCESSOR - as a control.
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 CTL with an 'INSTRUCTIONS' function.
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 also be used as an array for multiple recordset retrieval.
Download DataAccessCTL (14 KB)
VBcoders