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

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.

This small application will allow users to search for contacts by name using a ComboBox. This project shows use of ADO, Search Methods, and Modular programming.

Copy the table structures and records from one database to another. In my case, I use this code to copy from an ODBC SQL Server database to a local Access to allow users access to a copy of the data when they are not connected to the network.

This COM app was developed as a drop-in module to access databases across the corporate network in a variety of applications. I'm posting it here to get feedback - am i doing the right thing, could i change it in any way? make it better? all comments (constructive!!) appreciated!

This code pastes into a Module that Create (if not exists) a MDB to record the errors that occur in your application.

All fields in the selected table are processed and the AllowZeroLength property of the fields are set to either True or False, depending on the Status given as the finaal parameter The function returns a boolean value that can be used by the user to determin other operations.

This is an ADO DB tutorial for programmers who know nothing about ADO. It is a good template to following when making your own project. I hope that it helps.

This VB6 project demonstrates how to edit an ADO multiuser recordset using databound controls. It is based on the 'single-record form' created by the VB wizard, but adds: * Enhanced error handling * Improved user interface The demo allows several instances of the form to be opened, for a 'pretend' multiuser network.

DAO based database program with many features in it, I also noticed after searching around I seen no databases that supported saving gaming info so I made one witht he ability for saving game info such as favorite game, gaming handle, clan name, clan rank... Also added the ability to change the color of almost virtually everything you can see. This is my first database I made or even attempted so don't expect much from this but I think for a first attempt this came out da!mn good... I know my error handling lacks a lot and I think I will be implementing the ability to email from this program, search may be implemented but I never had a use for a search option in all databases I used so thats a maybe... Also I plan on adding a user login feature, I tried to comment on as much as possible this is basically for those looking to break into databases since I think I successfully created a pretty good first database. **Extra Cool features** Double clicking on the email text box will open up your email application and fill in the To: field with the contacts email address, double click any phone area option to call up a form in which you can type in the contacts number and call them (example taken from the sample that comes with vb6, i just thought it would make an excellent option... Also your pc must be connected to the same line as your phone line in order to work) and double clicking on the Homepage Title or Homepage URL will open your browser and take you to the contacts homepage...I also included a timer feature so you can specify any hour or minute you wish and set the alarm then it will display a message box at the specified time reminding you to complete your task...

This Program generates ADO code and SQL Statements without the use of an ADO Data Control. It is available as a stand alone executable or as a VB-6.0 AddIn.

This code is used to search for clients in an access 2000 database using ADO and a parameter query. In our database we have roughly 20000 records to search and it still finds them very quickly.

A article showing how to create a global ADO connection to SQL server from a Visual Basic Client.I have more examples and programming solutions on my web site www.SQLwarehouse.com

Asynchronous Database Processing via Active EXE - When processing thousands of requests for a multi-user real-time application, you cannot afford to wait for the relatively slow database processing to occur. Here's the scenario: You have 1000 people already online and playing your multi-user game, and 10 people in the process of logging on right now. What do you do? You could process the logons right now, searching through thousands of user records, to load up their information - but then the game would appear to 'hang' for everyone already playing, waaaay bogus. You could process only 1 person at a time, in the main processing loop - that's better, but will add unnecessary slowdown to your program. What if you could log on the person in a BACKGROUND process, which wouldn't slow down the existing users? Ooh yeah. Or better yet, hand the request off to a machine across the network, dedicated to database processing? NOW we're talking! :-) You can do this easily, using Visual Basic ActiveX EXE's. Have fun with it!

A valuable tool in your programming toolkit. Use this routine for when an Access table goes bad. Often when this happens conventional INSERT or APPEND queries or cut/paste techniques don't work for backing up your table. This is a routine for copying data from one table to another table, field by field. As the information is processed, bad data fields are skipped over and logged in a log file. Only good data is deposited in the target table. **re-uploaded/Corrected II**