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

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

Enter your SQL server's information, and easily select a table (or all of them), and the application will print the Table's Field properties... Great for a quick-reference. ****BE SURE TO SET THE CONSTs IN MODULE1 TO REFLECT YOUR SERVER SETTINGS****

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 !

This code will blaze through creating even the longest SQL statements(Jet supports up to 64K). This is an updated version of the SQLHelper post I made about six or so months ago, with various optimizations made since then. I have found it to be very useful, hopefully you can too! All code was written by me and is free for all purposes with the exception of cStringBuilder.cls, which is from vbaccelerator.com.

we have to save data in TABLE i wrote this utility to help beginers in vb for saving data without using the old way LIKE rs!st_no=val(me.text1.text)

This Helps in maintainign the booking, vechicles, contacts and other important aspects of any transport organisation.

this code is made for experimental purpose only. this program recovers the database password created in MS-ACCESS 97. THIS program is created for learning purpose only.

THE PURPOSE OF THIS PROGRAM IS TO CALCULATE INDUSTRIAL PAYROLL IN INDIAN SYSTEM INCLUDING ESI,EPF etc. YOU MUST HAVE LITTLE KNOWLEDGE OF ORACLE TO RUN THIS PROGRAM SUCCESSFULLY OR JUST FOLLOW THE INSTRUCTION AS GIVEN IN README.TXT FILE. !!!!PLEASE VOTE FOR ME.!!!! !!!!PLEASE VOTE FOR ME.!!!! !!!!PLEASE VOTE FOR ME.!!!!

Hello To All This module demonstrates how to perform common operations with ADO. This bas is essential if you want to do any database access with ADO. It shows how to perform common task as well as complex task using ADO. The notes on top of each function is self explanatory. The important feature is that it shows comparison with DAO (the older database access technology)and instructs how to perform similar task in ADO and which parameter to use. Please Rate it. Thanks and Enjoy..

Here is my first submission on www.pscode.com, This project prepared to help you to convert your Ms Access Database into MySQL data source format. On this project, I'm using some API function to Draw caption or Picture, so it is helpfull for newbie in VB to learn about API programming. I'm using osenxpsuite controls, to improve my GUI application. if you does not have osenxpsuite controls, you can download it from: http://download.osenxpsuite.com/osenxpsuite.zip I WAS TESTED THIS APP IN MY PC P-III 730 Mhz, and It work fine. It can convert nwind.mdb to MySQL data source for 7.07 seconds If this project usefull for you, PLEASE VOTE THIS APPLICATION IN www.pscode.com Note: - MDAC 2.5 needed - OsenXPSuite controls (http://download.osenxpsuite.com/osenxpsuite.zip) needed - MySQL oDBC 3.51 Driver needed DOES NOT SUPPORT: • cREATE INDEX • CREATE PRIMARY KEY • CREATE FOREIGN KEY • CONVERT BINARY DATA VALUES (BLOB) IF ANY IDEA HOW TO SOLVE SOME TROUBLE ABOVE, PLEASE LET ME KNOW. I REALLY NEED HELP ADVANCE VB DEVELOPER TO SOLVE MY APP THANK YOU

This sample shows how to secure Access database using ADOX and SIDs. In apps where database is created on-the-fly from code its only way to prevent your database from being modified.

Good for beginners who want to learn database. I include simple code in searching,add,edit,delete,print in the system. It has good GUI.JUST TRY!!!

This class makes VB Database Applications easy to write on the fly! This class includes over 30 functions for ADODB programming in VB! It encapsulates all the Find Functions, Move Functions, along with AddNew, Delete, Update functions and a ton of error trapping for easy use! Also includes events to program at your disposal! Please leave comments/feedback and vote if you'd like. This is my first class file I have been working on.

A vb test application which opens queries from access instead of tables for a datareport.I could not individually open selected records so i made this instead.