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

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

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.