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

Creates a Microsoft Database (MDB) on the fly and adds tables dynamically in Visual Basic. The program needs a reference to Microsoft ADO Ext for DDL and Security.

This code will allow you to make a DAO database using code instead of the Visual Data Manager. This is good if you need to make a program that makes a database from scratch on the user's computer. Has many uses if you are a creative person! Please vote for this code if it helps you in anyway. If there are any questions, just email me. Thanks!

THIS IS AN EXAMPLE OF HOW YOU CAN DO A SIMPLE TABLE WITH DATA, SO YOU CAN NOT USE THE FREEFILE() , YOU CAN MAKE MSFLEX GRID, TEXT BOX,COMBO BOX ETC WITH THIS CODE, AND IS SO EASY, TRY IT, PLEASE DONT FORGET TO VOTE FOR ME THANKS.....

BUG correction!!! Version 1.01 A solution for who does not want to use ADO/DAO or ODBC to have access its database in MySQL. With only one DLL you it has the power on all functionalities of the MySQL.

A solution for who does not want to use ADO/DAO or ODBC to have access its database in MySQL. With only one DLL you it has the power on all functionalities of the MySQL.

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

UPDATED!!!!! This usercontrol allows to get/put files in an Access 2000 mdb with one line of code!!! And I've forgot to mention it, if the file is a picture, it is autom. shown !!! Please leave me a comment !

Shows how ADO technology connects globaly. Also shows how to integrate ADO Data Control and the Data Grid. This project uses the phonebook concept to show these concepts.

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.

In development of dynamic website using ASP, recordset paging is one of the very useful feature. This code "Dynamic Paging in ASP" makes the recordset paging a child's play. You just have to modify three parameters in the paging.asp file and voila, you can use this code anywhere in you website. Just gives the name of database file, name of table and no. of records to display. That's it ! I am sure it will be a very handy code for any serious ASP Developer.

Connect to any ODBC compliant db using RDO. by the way MySQL, Oracle, FoxPro, Excel, Access, Sybase are all ODBC compatible. Use this code to connect to Unix databases, Linux databases, etc. Very simple (easy to follow) code. If you would like to see the same in ADO, or want me to add DB creation/editing capabilities let me know. Currently you can just add, update and delete records as well as run queries. Please Vote, I stayed up late working on this. Comments positive and negative welcome.

By default Access string fields contain NULL values unless a string value (including a blank string like "") has been assigned. When you read these fields using recordsets into VB string variables, you get a runtime type-mismatch error. here is a nice code to get rid of that

Define a connection in Excel, run a SQL query from excel and return the results into an Excel spreadsheet.

vbs script code , using recursion , collections , this code convert xml files into sql recordsets. Usefull for search purpose , news management etc...

Creates a database using a Random-access file. also shows how to use Multi-Interface Documents in your applications.

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

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.)

A Visual Basic application development framework for Microsoft Great Plains (Dynamics and EEnterprise) accounting software. This application runs completely independant to Great Plains. (If you require seamless integration consider using Dexterity and/or VBA). The initial version allows a user to login to the system, and select a company. The project has also been registered on www.sourceforge.net as open source (search for Great Plains). The idea is to build up a library of code and accelerate application development. Included is a sample program to copy security settings from one user to another. (Be sure to read the readme.txt before using this program!)

This code can be used as a template for creating master forms.

This shows you how to make an address book with databases.