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

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.

This is a simple generic wrapper class to quickly general ADODB Connection strings, including password protected files & shaped recordsets. I've only needed support for Jet & xbase files so that's all I've included. Please feel free to expand and post them as long as I get a copy of any changes.

Small but has everything: Ado 4.0 Access2000 Database; Adding, updating, deleting, editing and printing. 2 different kinds of searching ( 1 thru a listbox, the other 1 thru a textfield ). Microsoft Outlook 2000 support included. (creates a new mail). Database infos given are recordcount, recordposition, databasesize.(in kb) All images with tooltips. Appl. has been tested and works. -------------------------------------- "Its not a bug, its a feature" (Epic Games)

On a machine where the Adobe PDFWriter is installed, the current printer is swapped out with the PDFWriter and the PDF file is created. The original printer is then restored.

This is a simple usage of database as long as VB and MS Access are concerned. But you can certainly use this on your literature class. Zip file includes a database containing more than 200 biographies of classical authors.

This code is a great help for those people without Microsoft Access and want to administer their Databases easily. Includes full source code. Shows all records at a glance, allows editing, adding and removing. If you like this please support me.

This is a Class that encapsulates the ADO object Model and make life a little easier for Developers. I have included the SmartSQL class for which all credit must go to FreeVBCode.com The ADO class simplifies DataShaping, SQL, Connection Management, XML RecordSets and many, MANY more

For conversion of MS Access Databases between JET 3.X and JET 4.X (MS Access 97 and MS Access 2000) using DAO 3.6. This is my first contribution after years of visiting PSC. Not detail commented. (Please see the ChangeMDBVersion.exe.txt for more information.)

Thanks to Collin McAllister for the 7/13/1999 submission this is based on!! A visual adhoc query form that allows multiple criteria selections and simple joins. A simple (limited) somewhat user friendly way to create simple queries.

Address DataBase Shows VB and ADO

This was a piece of software i did for my HSC major assesment, 93% cheerin! Anyway, i have put a fair bit of work into it, it still has bugs, coz i only finished it the other day i haven't had a chance to fully de-bug it. There are also some changes I would like to make in the near future, but it is basically finish, so please enjoy, let me know what u think, and PLEASE vote high, i would love to win this months comp :-) The Admin Password and Teacher password are both "Gilroy"

Add Your data to Access Database/Edit/Delete/Add to the main DB.

Updated: Dec 02 2001, Ver 2.5 updates are functionality to associate MS Access (.mdb) databases with Database viewer/editor, and to Maximaze the application. View/Edit data on databases that can be MS SQL-Server local/lan or remote on internet, or a MS Access database. Get Data by clicking databases/tables/columns/views/stored procedures or perform custom SQL queries. It shows ADO Programming and Some API. In this version I have fixed some bugs from previous releases and improved the functionality. Now you can view the "source" of all stored procedures and views in SQL-Server. Thanks to all who came with feedback/suggestions in previous versions of this application. The project is made with VB 6.0 Service Pack 5 and I used MDAC 2.5. Please help me grow as a programmer and come with feedback/suggestions.