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

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)

Ado Database which stores Usernames, Passwords, Notes. Passwords are kept encrypted. For the Encryption i used the DS2 Class I found on this site.(Author: David Greenwood)So far the best Encryption - Example I could find here. Uses the Microsoft-Style of Ado Database. Features Add, Update, Delete, Cancel, Edit and a Listbox. See Screenshot! Update available, More security: http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=41006&lngWId=1

Load your categorys in a treeview, create new entries under your personal categorys. Three (!) completely different kinds of searching will help you finding any entrie you are looking for. You can create new categorys, delete or modify them. Learn how to create a better database for contacts, source code or whatever. The Treeview is resizeable ! easy by draging it to the left or right! The sample application is 90% done, fully functionally and kept without a personal note for a simple demo. (means no pics and icons you are deleting anyway ) You can easily change everything for your own needs. The database is MS Access 97 Format. (You can upgrade to MS Access 2000 without changing any code. )

...for storing your websites,emails and passwords. High security: connect to an user/password restricted ms access 2000 ado-jet database.Bulletproof: Store all your passwords ONLY in their encrypted hex value. Please check the 2 textfiles for more infos about the encryption used (Buisness strength) and the database.

This is a simple Database i have been created it for a factory , its works very nice i liked to share the codes in planet source wish you like it (WITH ACCESS DATA BASE!)

to all programmer out there who is like me...download code and don't know how to manage it.. :) this simple program shows and help us (maybe..)to manage code/program/module...u can modified it as u like...i'm new in this area..i'll be glad to have some comment(s) from u to help my programming skills...c ya..

This code takes a user specified Access Database (I used Access 2000) and prints the database structure to a printer or to an HTML file. Currently working on adding Queries, etc. to the mix as well (Version 2.0!!) if i get any feedback.

Memory leakage is probably one of the most difficult programming problems to solve. This article tell you why, and how to do it.

This article explains how to, using pure code, without having to reference Excel, Access, dBase libraries, etc, export data from one format to another.

Just select your databasename, sourcetable and see... (Please vote....)

Example for data validation, database and data manipulation. If you like to see implementation for Search and Filter than take a look at ABCStores_02. Please vote.

If you want to build an application that can work with several database engines, the main problem you will have to deal with is the different ways for specifying date expressions. This class will allow you to forget those differences. You can enter date strings in any format "dd/mm/yy", "mm/dd/yy", etc.. The class will validate the correctness of the date string and convert it into an expression you can use. Works for SQLServer, MySQL, Access, Informix and Oracle, and it's easy to add more engines.

SQL Writer Pro (using ADO) is a Universal Data Access (UDA) tool. It lets you query OLE DB data sources, author SQL scripts and queries, return query results to a grid, retrieve provider properties, execute multiple SQL scripts or stored procedures simultaneously, and more! This is a work in progress. I ran out of time before being able to complete this application. If you can improve upon it or complete it, please let me know. Otherwise, enjoy!

Allows you to load and view any outside XI report file from your VB6 code.

How to create Access database directly from VB code? This program will create BAS module with all the database structure informations and you can include that module in your app. and create as many databases as you want. Sample code and infos included. Don't have to vote, just use it and send an e.mail for any error you find, any feature that you like me to include (like compact, replication, etc)

To show how to use ADO Data Control

This is a gym application that I created for my VB class. This App. keeps track of members, employees and inventory. This program uses MS Access with SQL DAO.

This code demonstrates how to use a connectionless recordset.

The purpose of the following code is to demonstrate how you can load a datagrid with data from a text file.

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.