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

While searching for a way to repair a corrupted database file, that couldn't be fixed with just Repair and Compact, i found this undocumented option that prooved to repair and optimize my database file. Read the whole article. Any comments or feedback are welcomed.

These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script. The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.

My Address Book(AnyAddress) allows you to add the persons name, email,Homepage ,Address, phone number and so many other fields. It also have good GUI. It is fully User friendly So u can easily use it. I have used Microsoft Access as Database Sql for searching the records.

This is an Home Inventory program that uses the cuecat that was given out by Radio Shack. It also show ADO connections Data Reports. You can keep track of your movies, what you have and who borrowed them as well if you sold any. You can scan or key in the UPC from movies as well as groceries. This still needs a little work, but I am on the right track.

This program retrieve the tables and column existing from DSN ODBC. To do, use the OpenSchema method frmo ADO.

Complete Library Management Software fully commented,No dirty coding. Very useful for beginners!!!!!! Please vote

Create Shape Statement For Master/Detail Form In Visual Basic.I Made This "Generator" Because I Couldn't Remember The SHAPE Statement And Now I Publish It For All Developers Who Cannot Remember It And It Is A Good Example Of ADOX And ADO.The New Version Is With Full Test Of SHAPE Statement.

This code is an ADO modification to the previous post from Robert Row in December of 2000. This class adds AutoComplete functionality to a textbox. You start typing and the class searches for a record in an Access 2000 database that starts with the letters you typed, if it finds one, it completes the rest of the textbox with the record.

Treeview Database sorry it is in German and my first Submission. If you like it I will put it up again in English.

Ado Database which stores Usernames, Passwords, Notes. Passwords are kept encrypted. For the Encryption i used the DS2 Class I found on this site.(Author: David Greenwood)So far the best Encryption - Example I could find here. Uses the Microsoft-Style of Ado Database. Features Add, Update, Delete, Cancel, Edit and a Listbox. See Screenshot!

to all programmer out there who is like me...download code and don't know how to manage it.. :) this simple program shows and help us (maybe..)to manage code/program/module...u can modified it as u like...i'm new in this area..i'll be glad to have some comment(s) from u to help my programming skills...c ya..

This code takes a user specified Access Database (I used Access 2000) and prints the database structure to a printer or to an HTML file. Currently working on adding Queries, etc. to the mix as well (Version 2.0!!) if i get any feedback.

This article explains how to, using pure code, without having to reference Excel, Access, dBase libraries, etc, export data from one format to another.

Example for data validation, database and data manipulation. If you like to see implementation for Search and Filter than take a look at ABCStores_02. Please vote.

How to create Access database directly from VB code? This program will create BAS module with all the database structure informations and you can include that module in your app. and create as many databases as you want. Sample code and infos included. Don't have to vote, just use it and send an e.mail for any error you find, any feature that you like me to include (like compact, replication, etc)

This code demonstrates how to use a connectionless recordset.

The purpose of the following code is to demonstrate how you can load a datagrid with data from a text file.

Demonstrates many common VB controls, ADO databound controls, Datagrid, and input validation in a VHS movies library. Hopefully demonstrates good code style.

This demonstrates how to create a database and components at runtime from a public sub called from the AdoxData class with ADOX 2.1 objects

This submission was deleted due to the recent hacker attack. So I'm re-posting it to give access to other users who want this code.