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

This nifty little program interrogates Microsoft SQL Stored Procedures and generates VB code to interface with them. The concept was Adapted for VB from David R. K. DeLoveh's work for Active Server Pages found at : http://www.15seconds.com/issue/010718.htm the article make for a very good read so do so if you can! I converted it to run under VB and spruced it up a bit. While programs like LockWoodTech's PROCEDURE BLASTER do the same thing they cost $$$ and this is free. If you like it remember to give a vote. And again thanks goes out to David R. K. DeLoveh's for his original work. With this code in hand it would be easy to modify it to be MTS/COM+ compatiable. For more extensive developers tools like this one check out www.LockWoodTech.com.

select any access database then select the table you want then select and insert any fields to a richtextbox then preform a mail merge like MSWord. you can then browse through the database while viewing the merged data.

Enables any user that can login to a database to monitor sybase activities. You can monitor your SQL transactions, functionalityy accdate, audflags,dbname,fullname,language,name,password,pwdate,resultlimit,spacelimit,srvname,status,suid,timelimit,totcpu,totio,affinity,blocked,cmd,cpu,dbid and much much more

Sorry !, My contents of snippet was posted very strange as below. So, i will post my source code Once again, Sorry

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

I was in need of certain application that can store data in to the database and the database is stored on the Web.. And I want it without XML. I asked many people that how Audiogalaxy and Napster are doing those all the things.. they told they are using such service like XML or other.. But I don't want to use XML. So I develope application for me.. It is really very easy to use and also very easy to develope.. This is made with Visual Basic and simple codes of ASP. Must See this code.. and please vote for it.. NOTE: Now probleme is that, that I am not able to get data from the web. If any one can do it.. please let me know..

This is a database application. It stores information for keeping track of company inventory. The database is empty, so you will have to populate it yourself

Stores CD-Keys, serial numbers and registration information for software. This shows database functionality with viewing, adding, deleting and updating records using DAO as a reference. Also, shows using the database to authenticate users, a simple encoding and decoding mod is included to somewhat encrypt the data in the database. This is worth the look, even if you do not plan on using the database. Sorry guys, I only include the database structure, not data. No serials/keys included. That's illegal ;> No votes requested, however I do like comments on how to improve the code. I will be adding comments when I get the chance.

This source code compares two database structures and wrote report or copy differences into second database. It uses DAO control and works with MDB database.

This VB test project demonstrates how to insert, delete, update and select from a Microsoft Access database using parameterized stored queries and ADO command objects. .mdb file in included.

This code will teach a user how to save their data and also how to retrieve it. Very easy to understand if you read the ' comments. :) Enjoy!

((UPDATED!!!)) I commented the code and added a "Generate Character Stats" button on the Add Character form... I still need to add some rules for the generation. This is a new program I am just beginning to work on. I would like ideas on what to add. It is far from finished, but like I said, I would like some ideas. It uses an Access2000 database (included) and I have included an executable.

visual user interface to construct a query

How to copy a database table. This may require some tweaking.... "Bill Pearson"

A short routine that backups the tables from an open Access database George Kinney

The following function creates a user. You can execute it under any user you like. [email protected] (Dror Dotan A')

This project demonstrates populating a Microsoft Access database dynamically into a treeview and listview control, by using loops and arrays. Also added the common Add/Edit/Update functions into the database for those who wish to learn the basics functions of ADO. Another purpose of designing the code the way I have with objects is so you can reuse the listview and treeview modules just in case you wanted to load the same information into another treeview or listview control, with out adding extra code. Once any database is loaded you can also edit the values in the treeview with the label edit functions. (F2). anyway there are lots of code samples available in this project. if you like this code please vote. Thanks.

*** A1 Database Copmarison Tool.... Can compare 2 databases for missing Tables.... Can compare 2 Tables for columns and report the missing one's... Generate the Create Table Script... Run the generated script on Target database.... lot more to come.... Uses ADO DB Objects... Can connect to MS Access NOW... SQL Server , Oracle , Foxpro etc ... later...

This will show new people to VB or Vb and Database's the basic's of using ADO with VB and access databases. *PLEASE VOTE*

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! Update available, More security: http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=41006&lngWId=1