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

I got the the layout and design of the program from CONTACTS 2000 made by [email protected]. BUT the code underneath is radically different! This program MANAGES AN ACCESS2000 DATABASE with SQL and query's with Recordsets. The best part about using a MS JETDB EnGINE4 is that the DB can be accessed through a network. It also queies a recordset and spits the results to the NEW DATA REPORT in VB6. I worked hard on this one! enjoy. READ README.doc for info on running. e-mail me at [email protected] for questions. PS. THANKS MICROSOFT SUPPORT (GENE MOODY)!

This article attempts to explain the Microsoft Jet collections and how you can use them in really useful ways. If you don't know about Jet collections, this is well worth reading.

The Stream object introduced in ActiveX Data Objects (ADO) 2.5 can be used to greatly simplify the code that needs to be written to access and modify Binary Large Object (BLOB) data in a SQL Server Database. The previous versions of ADO [ 2.0, 2.1, and 2.1 SP2 ] required careful usage of the GetChunk and AppendChunk methods of the Field Object to read and write BLOB data in fixed-size chunks from and to a BLOB column. An alternative to this method now exists with the advent of ADO 2.5. This article includes code samples that demonstrate how the Stream object can be used to program the following common tasks: Save the data stored in a SQL Server Image column to a file on the hard disk. Move the contents of a .gif file to an Image column in a SQL Server table. ** Article ID: Q258038 - I take no credit for the code, I simply created a project from the example in the article **

This a Search program that searches for a 'specific record in a database. This is a kind of DISTINCT search. Where u just have to enter the first letter of the data u want and it gives u an output in the grid.

Lists records into a listview control using basic SQL Statements.

The purpose of this example is to connect/display database records (using ADO) with a simple listbox. This is a work around to using bound controls. You will find your apps will run faster.

The purpose of this app is to show some basic operations on databases using DAO 3.51 . Very good for begginers.

Allows user to connect to database(Access or SQL Server), view schema(tables, fields, databases). It's main feature is to allow the user to point and click their sql queries using an updatable text file containing sql constants and a treeview of the actual database. Please let me know what you think.

This code demonstrates a simple way to save Images (or any binary data for that matter) into a database... I would like to receive all kinds of comments and suggestions so, please give the same...

A report wizard which allows users to create their own simple reports and outputs them to a word doc. Includes sorting and criteria. I have modified this from Oracle to Access for demo purposes. I am also still working on it so any positive feedback would be appreciated. There are a few more things I would like to do like sort the Criteria operators according to datatype with, add totals. Feel free to use and modify. If you come up with anything good send it on!! This is the first app i have uploaded so I hope it works!!!!! Please read the attached readme file as there is a few things to do before the app works. i.e. add a query to a database.

Backup and Compact a MS Access database file (*.mdb). Output a *.csv (Comma Delimited)File.

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.

A complete database application. Sorry, but the program is in Portuguese(brazil), I'm uptade to English soon. It is Intermediate because the code is not commented. Please vote for me or leave a feedback!

Dates in SQl queries often cause problems, as the date must be in the ANSI format whereas dates brought back can be in a different local format. This function simply returns the date in the required format and save having to type Format(DateString, "mm/dd/yy") every time.

Convert a database table to HTML

This simple little function just returns the total number of records in a ADO recordset.

For ADO database application: To show (1) How to use ADO schema to obtain a list of tables of a database. (2) How to provide a re-usable single form for any MDB file name, and with another form to display as many tables as there are in that database at the same time. Otherwise, you will have to repeatedly create/refer to an instance of connection and you may need 10 forms if there are 10 tables in a database (see "3"). (3) The possible techniques to enable opening several tables on the screen in the same session, yet without conflict (otherwise if you create 10 instances of the same form, some common event handlers will mix up Table B as Table A, e.g. when calling yet another form. But with appropriate techniques, this conflict is avoided). (4) How to display various properties/attributes/status in descriptive text(pneumonic), rather than the VB's original numeric codes. Note: MS TreeView itself limits the node count to 32767 only. (For a comparative study of DAO, refer my DBofDAO)

The code purpose is basically to show you how to add multiple files into one single archive structure and to be able to extract the file successfully without no loss of bytes. Any size files can be added in. A swap techneque is used so that in a loop only 1 meg of data is extracted from the file, plus also to save more memory instead of caching large files into memory. I've kept the code basic and easy to use because this is how coders like it. Functions are easy to extract from the code and problems are easy to minipulate.. not saying their is any of course. I've managed with a larger project to fit over 70000 files into an archive with no archive damage or errors, but after that amount of files the speed of file look up does get pretty slow, lol. This is optimized for all versions of vb I believe so it's a good piece of code. Please rate, comments would be good. Thank you for the input. Ps this code can be classed as a file database in a way, you just need to know how to implement it into your applications. Same goes for information instead of files adding, all you have to do is modify the functions to fit specifications.

Connect to SQL Server Database ,and see all tables and columns in Treeview , Datagrid. All Stored Procedures ( Names and Texts of SP ) , Triggers ( Names and Texts of Triggers ) Views ( Names and Texts of Views ), Defaults ( Text and Name ) , Constraints ( Text and Name ) Primary Keys ( relationships ) , Foreign Key ( relationships ). Search Engine , Combo1 > TableName | Combo2 > Column Name , Criteria >> with each letter (or any other character ) you type , you will narrow the result. Direct Connection to Enterprise Manager ( with SQL Namespace object lib ) . You can perform full administration and implementation of SQL server and every Database ( if you have those rights ) : Create Trigger , Stored Procedure , Role , Rule , Default , User def. Type. Find out about Table Properties, Permissions , Dependencies,Delete Table. You can use EM interface for Generate Scripts , Manage Indexes . You can call EM interface for managing SQL server security, New Db user, and use EM's wizards for Import and Export DTS . Everything is commented and Constants are attached in two Word .doc files. With Query Builder you can perform very complex queries , Create tables , Update , Insert , Delete . It supports T-SQL commands , so you can perform (almost) everything as you can with Query Analyzer. Sample Queries , are attached as comments inside module. How to manipulate , easy , with more recodsets at the same time. Practically , this is simple console for administration and implementation SQL Server database ,with using full power of EM. I hope that You can find this app. useful . If so , vote. Thanks.

New to ADO? Worried about ADO? This little subroutine gets round the problems of opening ADO recordsets. Please look elsewhere on this site for info on opening the database itself. If you open a Recordset in your code, ADO expects you to close it before re-opening. But if it's not open you can't close it... (Oh My!). Here's my solution. It requires a public ADODB.Connection - I call it gCn. The routine will open a new recordset (compatible with Janus GridEx), or refresh it if it's open or if the SQL has changed. Optional ReadOnly argument.