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

Using ADO & ADOX, convert between various database formats like Text, Access, Excel, dBASE, Paradox, HTML.

This source code permits to connect to a DSN ODBC connection on a remote computer running dbTCP. THis can be very useful if ODBC licences are very expensive (I had the case).

This Program explains how you connect ORACLE with VB. How you retrieve table, view and stored procedure of ORACLE and Table Description. please Check Out subclasssing a Textbox and customizing Progress Bar. If I make any mistake please send me the right one. Check Each and every code.

to easyly find edit and store unlimited phone numbers

Compact Access Databases with one line of Code! "One line of Code", like this: ;-) CompactDB Database, ShowResume, Password or this example: CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" Private Sub CompactDB_Click() If DB Is Nothing Then 'the database is Closed CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" 'compact Else 'the database is open DB.Close 'close CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" 'compact [Call your Routine to load database] 'Open database End If End Sub Works fine with Access 2000 and XP Actual Revision - Jan/20/2004 Jan/20/2004 · some Form changes. · fixed some variables declarations. (Variants in place of Strings). · added Compact Password protected databases. · added some Comments. · added some Code examples. · added a compress level indicator. Jul/25/2003 · Initial Release

Hello guys!!! This submission is a complete OLE DB Provider Guide. Many beginner database programmers out there don't know how to connect there application in defferent database, in lan and even in a remote. This guide will help you a lot coz it gives all example on how to connect to a database using OLE DB Provider. Pls. Pls. Pls. Don't forget to vote this appliction.

shows how to filter a datagrid by selecting option buttons. useful to search multiple entries with a criteria. here i have shown how to filter payments by Due, by Paid, by student name etc... Hope u find it useful.pls vote.

This is an updated version to (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=53106&lngWId=1) It is quite out of date: 1.I found it years ago; 2.it is first written in 1992 by Ethan Winer; 3. seldmom people use dBase nowadyas. But I picked it up last night and decided to make it better: wrap it into a handy OO class, support for all character-sets, tidy up all the codes that strictly follows the coding standard. Changes: 2004/4/13 15:05 GMT-8 1.mimics part of the ADO mechanism(MoveFirst/MovePrevious/MoveTo/MoveNext/MoveLast/BOF/EOF) 2.State(Open/NotReady) 2004/4/14 09:55 GMT-8(v3) 1.all long types to support as more records as possible 2.built-in all field types

a Crystal Report TTX example Shows how to create a report using TTX files, that is you dont need to specify a fixed database for your report. It'll be based on a simple TTX file. Using this you can pass an ADO recordset to the report at runtime. This method solves great deal of problems for many crystal programmers who will benefit from the simplicity of intergrating their report with VB. The report will execute even if the database location changes or renamed. Only you hav to do is change the connection from VB. [supports versions 8 & above.] Read the step by step tutorial and the official crystal guide to TTX available at http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr8_ttxado.pdf.asp if you like it,dont hesitate to vote :)

Allows you to programmatically create an ODBC connection to a MySQL database using the Registry API.

Recovers an Access 2000 password

Sample of using VB access data from a MySQL database (Create Table ,Add ,Edit ,Delete ,Search ,Show and Upload Picture) for beginner. Tester with mysql-4.0.18 for Win32 and MyODBC-3.51.06.exe ***MySQL Server configure (set to no password) username:root port:3306 database:test

This Program explains how to connect ORACLE with VB. How you retrieve table, view and stored procedure of ORACLE. Also featuring subclasssing a Textbox and customizing Progress Bar. If I make any mistake please send me the right one.

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.

Hi, This project gives you an idea how to access ORACLE through VB and ADO. Project describe How you interacting with ORACLE Table, view, Stored Procedure, Type, Package, Package Body, Synonyms, Sequence etc. I developed an Active X Skin which is used throughout the project. If you want to test the Skin just put the controls (OFrmCtl, Edge Right, Edge Bottom, Edge Region) in a form and run the project. Please close the project from FORM CLOSE Button, otherwise IDE will be crashed. Please check all the menus and form. Now, I’m trying to develop this project in Visual Basic.NET. Resize the form From X Axis and Y axis. Check it out. Using of My developed Active X Skin and other components are strongly prohibited.

Add any BLOB you like to an Access database. For example, add pdfs, docs, mdbs,zips etc. All the different types are displayed in a tree view and you can view them by dragging into a frame and launching their respective application.

A simple PIN Generator with access database. Try it!!!!

[Updated 27/2/05] Make your recordset universal! Use this class to export ADO recordsets into the industrial standered [csv], commercial standered [html] and the power user standered [Excel]. This is an updated version of my previous work, now complete Events, Properties, Documentation and even more options! Fuly optimized and commented. All bugs fixed. A must have for any database devoloper and a must add to any code library!

This is a very usefull code, which i want to share it with u all, as i am working on an accounting package, this package closes it files at year end, and places it in backup database files. But the running year may need reports based on old data, i.e. the date range from the close file. Here is the SQL which can be used to get data form multiply database file in the fastes possible manner.

Hi! This is my first submision. This is a complete address book with picture likes school database to keeps track of your relatives, your friends and your classmates. Look and feel of WIndows XP regardless an operating system. download now! and don't forget to vote me .....