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

Need Part 11 compliance then you will need multi-level password security with passwords that expire. This sample application will show you how to this to your applications. All you need to do is copy 2 forms, a class module and a module to your application (see below) and you are ready to go. It was written to use an Access database (ADO). You set up the access rights, add users, and assign these rights to the users. New users, by default, are assigned the password of password, which they must change the first time they try to log-in. A user can change their password anytime they choose as long as they know what their assigned password is. The security file (security.pwd) can be renamed to anything you like and is password protected. You can assign a unique application ID to insure that the security file can only be used with that application. If you are connected to a network, the application will display your network log-in ID automatically in the Log-in ID text box. The passwords can be set to expire after a user-defined number of days.

A "single-form" utility program, to be used (1) when one does not have an Access program in hand, but wants to create an Access DB or to modify the structure of an existing one, or (2) if one wants to include a simple form as a handly tool in a project involving DB. The program provides functions (i) to display the hierarchical structure, properties and other relevant information of a database; (ii) to rename or delete tables/fields/indexes/queries (or delete relations); (iii) to create a new DB from scratch or by copying the selected tables from an existing DB, with or without index and/or data; (iv) to build a new table with specific field and index property settings; (v) to re-start an auto increment field; (vi) to print a table structure; and (vii) to browse &/or copy records, etc.

This program will allow you to physically map fields between two Access databases and then transfer the data (overwrite or append). You physically map it by clicking on an item in a list and then drag a 'Connector' object (just a bunch of lines thrown together in a class) to a field in another list. This code has been tested minimally. Please let me know if you find any errors. I will fix them. Thanks for your vote. All constructive criticism welcome! This is my first submission so help me out.

This is an improvement on my previous Access Field Mapper. This program allows you to open two Access databases and Map fields between two different tables (performs AutoMapping as well). After you've finished mapping the fields you can transfer the data with one click. This version will do type compatibility checking and if you transfer data that is not directly compatible it will coerce it for you.

3-TIER Test project illustrating high performance Data Access for SQL Server using ADO command objects and Stored Procedures in a 3-TIER ENVIRONMENT USING VB CLASSES for Insert, Update, Delete and Select. This project runs on Northwind db.

A utility to import/export Access database from/to other application formats, e.g. Excel and text files (single field or delimited entries for multiple fields). With sample files and help, as well as ample remarks. It is advisable to run the sample files first (and read remarks in each frame). Once you are familiar with the pertinent rules, you may then begin to use the program to process your other files.

Have you ever try so send a string variable to MS Access that have apostrophes using a SQL Statement? If YES you will get a run time ERROR Here is your solution....A function that formats the variable before sending it to the database.

This code creates a Microsoft Access MDB dynamically.

It is nice technique for dbgrid sorting.You can sort Dbgrid Columns by clicking on the grid column header in two ways ascending or descending.

This is to show new developers to Databases how to develop applications with VB and ADO. It is very well formated, step by step. And if you like it Please vote!

This is to show developers (mostly new ones) how to use XML / ADO technologies from within VB. I got the XML source code from a project on this site and put it to use! I hope that this will help someone out!

I wrote this code when i was developing a software for an Estate Agent. The code copies the database path in the System Registry and everytime picks it from the registry. If connection fails another dialog box opens where you can specify where the Database is saved. Secondly, you can take out the report of all the data in the table using MS Word. A small routine to accomplish the task. This is basically a three in one program. Save DB Path in the registry, Create Report using MS Word and Specify the database path. Just copy extract the .zip in C:\post directory. Please rate it.

This database comparison tool can compare 2 databases for differences. It can give you missing Tables, a script to create it... Check 2 tables for missing cols... Right now this works with only MS Access Databases... planning to include SQL Server and Oracle too.... This uses ADO objects... so mdac 2.5 is required on your machine. This is available in Microsoft's Website.

This is the only one ADO Boolean Search on Planet Source Code !!! [ AND / OR / NOT / AND NOT ]

This code demonstrate how to connect to database (Patients97) using ADO code alone. I also demonstrate using the MonthView control and MSHFlexgrid control. The database called Patients97 contains customer details like name , address, customer number etc and appointment date and time. On the form, I have an MSHFlexgrid control, a MonthView control and a command button(cmdViewAppt). Clicking the command button connects to the database using ADO code and the details are displayed on the MSHFlexgrid control. You can display appointments for a particular date by clicking on a date on the MonthView control (MonthView1_DateClick event) and the result is displayed on the MSHFlexgrid control. I have not figured out how to create a report yet. What I'll like to do is to be able to pull the information on the MSHFlexgrid control and display it as a report which can be viewed and printed.Preferably I'll like to use the data report designer but I won't mind using excel or word or is there a way to use DataEnvironment designer? Please e-mail me any improvements or additions at supo@orimogun.freeserve.co.uk.

I got the the layout and design of the program from CONTACTS 2000 made by Deatree@Yahoo.Com. 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 mikren@vianet.on.ca 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.