Results for "Category: Databases/ Data Access/ DAO/ ADO"

Contains One Class clsCompareDB and a Demo project. Purpose: To compare two MS Access tables in different databases. The code alse demonstrates: ADO Technique to retrieve the Table names from an MS Access Database using the Connection Object OpenSchema Method. ADO Techniques for using a recordset to retrieve Column Name, DataType and Size. This class came as a result of MS Access being so easy to Change. Before I Joined Tier Technology training I was employed by the United States Navy (DP1). Our Managers decided that the MDB file should not be locked in any way. We were requested to train the users what they can do and what they shouldn't do. This gave no Guarantee though. We had several programs that required that several tables in different databases (IE MDB's for different years) be identical in every way. The procedures in question copied information of processed information by Column Index (Column position) or by using For Each (which also relied on the Column Position). Recently I needed this technique to do some debugging on an application I wrote for Tier Technology Training. So I dug this program up. Converted it to a Class and converted all DAO code to ADO code (Just to see if I could do this). Also this allowed this class to easily be converted for use with other databases (Other than MS Access). Author: Joel Isenstadt([email protected]). I am a Microsoft Certified Trainer for Visual Basic and am Currently Employed by Tier Technology Training (www.tiertraining.com)

Last code of mine was about quering tables and i used a little bit SQL In this small code i will try to explain SQLText string. How is it created and working? This series will continue under this name !Lets Create Database Applications-V?

Advanced filtering and sorting (since v2.0) class for Microsoft Access 2000. Dynamically add and remove one or multiple filters while maintaining the current record if possible, the method used for this is faster than a FindFirst approach on ODBC connections. Prevents filters being added returning no data. RecordSource is created dynamically, no advanced SQL knowlege required. Disable all Access-own filtering and sorting functions as they'll interfere with the class. Import the class into your Access (library-)project. Code contains basic usage example and further explanations.

Browse to your database. This MDI program opens the database, seeks for tables and puts the fields into new documents. When double clicking a field from a table, the relation between other tables will be shown. Simple Code ..

This sample program is just used to show you how to load the entire Database into MSFlexGrid using ADO and SQL command.You can view and search all country Code by just a click.

With DYNDATA your are able to connect to a SQL-Server Database and edit the data in thier tables. DYNDATA builds dynamically the needed textfields and checkboxes. It uses ADO without databindingcontrols. You can select a database and table from a combobox and then connect to your given SQL-Server. All information about login, tables and databases are extracted from information_schema views and system tables. It is a tool I need for editing quickly data in tables without having additional tools. Thanks for voting

This code is an ADO modification to the previous post from Robert Row in December of 2000. This class adds AutoComplete functionality to a textbox. You start typing and the class searches for a record in an Access 2000 database that starts with the letters you typed, if it finds one, it completes the rest of the textbox with the record.

A simple example to add, update, delete and open Access2000 database.

Uses DTS (Data Transformation Services) from within VB

The program Creates a VB Class Module from a DTS Package on a SQL Server, with all events, and its own events(Progress, currentTask, etc) It creates a very compact script, so you can very large packages in a single routine. The Class Module "ClassDTSScript" is what is created when you get a package from the server and script it. Simply remove the example, and add one you have done to test it. The example execution asks you to navigate to the source and destination Access Databases, and uses the filepath to pass in an ADO style connection string for the source and destination connections. The parsing routine in the class module will work for SQL Server or ACCESS. I have not handled more complicated transformations such as Many to one column mappings and such, but Execute SQL and DATAPUMP Tasks work quite well. The Example "ClassDTSScript" module included was created from a package in SQL Server 7, and includes a couple of queries, two transformations, and running a stored procedure with a parameter, as well as demonstrating using the events that are called by the DTS Package object. Read the comments in the code carefully to better understand the uses.

I have used SQL queries for Add, Modify, Delete, Update and Search in the databases. Everything neatly coded and commented for each line. A very good example for beginners, who needs to know the coding standards for connecting to the database using ADO. Comments appreciated.

VB module to read and store ANY kind of picture file pictureboxes support into a database, it's easy and it's pretty fast... please, rate it, any comments are wellcome

Good database program to learn from. I suggest getting it. It was one of my first database programs, and this makes it easy and stuff. Has add, delete, edit and search feature. Also uses SysGarbage.ocx for system tray access. It is cool. Please rate.

Well This is my First App and my First Submit to PSC. Please take a look. I wanted to make an DataBase. To start simpel i made an Address book. I know there are a lot if this books here. But this one is diferent :). It has the function with Last File Opend, File Asosiation, (with open and print function) printing an DataReport and some other stuff. Im just an beginner with VB6. So comments and stuff are welcome. if ya wana Vote do so if not do not :). Greetz Black-Dextra

The purpose of this class is make easy to generate ConnectionStrings to open ADO databases. Just setting some parameters you can easy open Access MDB with or without password, SQL server using username and password or Windows NT login, DBase III files, Excel Worksheets, Oracle and ODBC. Plus, with a minimum of modification you can easily add support to any other database. Of course that you always can hardcode your connections strings but this class will make this for you on a very friendly way. I'm updated with minor changed and translation of comments to english. Since it's my first submission to planet source code will be glad if I have some feedback positive or negative. I hope that this class can be so useful for you as it is for me. :)

This code will show you how to connect to a mySql Database using a DSN. It is very simple program but it shows the basics.

There has been a few questions on how to use VB to connect to a mySql database. This will show you how to connect without using a DSN. Most of the code is from a ADO Tutorial from this site. I just modified it to show how to connect to a mySql Database.

This is a program which will allow you to test a connection to most databases (SQL,Oracle etc...) and run any SQL query through. The connection to the database is handled using RDO although this could be quite esily changed to ADO if required. To test the connection you will need to enter the desired connection settings like server name, database name and password, DSN name if required etc..

This Application is used for quick access to an Oracle Database. The DataFetcher gives you power to Add, Remove, Search, View, Records at a click. DataFetcher also has it's own built in SQL*Net emulator in it! If you access an Oracle database frequently, then this is a must have Application. You must have Oracle Client installed on your machine to take advantage of the ORacle Object used in this code. Please Email for any questions or feedback. Thanks.

Create a CSV file (ie. for Excel(???)) based on a parsed ADO-Recordset - very cute :)