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

Improved code production, index/relation handling and now supports Queries. Database Coder analyses an Access Database and produces the code to create a blank copy of it. Supports Tables, Fields, Indexes, Relations and Queries. Interested in comments. Updated 26 May 2000: Improved handling of default field values and minor bug fix.

The problem with Access databases is that when you delete records, the .MDB file doesn't shrink. It just grows and grows and grows – until someone either compacts it or you run out of disk space. This tip will show you how to compact a JET database up to 100 times!

Provides a wrapper around ADO future proofing your code and making accessing your database much easier. Ensures all your code is standard and uses the best data base access techniques. Also provides functions to convert a recordset to HTML or CSV format - handy for web pages as well as client/server applications. WOULD love your feedback, feel free to contact me directly or submit comments.

Hi,Family Address Book v3.0 - Final Update has been released on October 03, 2000. Please don't be fooled by the name, it is not just a simple address book - check it out and you will see. This time around I mostly use ADO instead of DAO and now the user is allowed to add or remove any category of their choice. DAO is only used to create the database, every thing else uses ADO. It has a lot of features such as Personal Contacts, Personal Internet Links, Search and Printing, Personal Reminders and also Sending Email using the vbSendmail component found on http://www.freevbcode.com. Please read the file readme.txt before you begin. All the source codes are included so you can compile the code for yourself. Please leave your comments or feedbacks And Remember to VOTE!!!. Last Updated : October 03, 2000. The ZIP File Contains a SELF-EXTRACTABLE FILE with the Source Code. If you hav any suggestions for the next version please let me know.

This is a family address book program created using VB6. Its main purpose is to store personal address book information for each member of a family. THIS IS AN UPDATED VERSION OF THE ONES THAT I CREATED SOME TIME AGO. THIS VERSION HAS ALOT MORE FEATURES SUCH AS PRINTINING / SEARCHING, Personal Internet Links ETC. IT ALSO USES THE LISTVIEW AND TRE VIEW CONTROL TO GIVE IT A BETTER INTERFACE. REQUIREMENTS Microsoft Windows Common Control 5.0(SP2) - COMCTL32.OCX Microsoft DAO 3.51 Object Library. Please write any question comment or suggestion. Tell me if you find any bugs. Note : Read the file readme.txt before you begin using it. If you are running the program for the first time you have to allow the program to Create the Database file. Filesize : 296KB. CHECK IT OUT!!!. Author : OmarSwan.

Hi, This is new version of a family address book that I released some time ago. Please don't be fooled by the name, it is not just a simple address book - check it out and you will see. This time around I mostly use ADO instead of DAO and now the user is allowed to add or remove any category of their choice. DAO is only used to create the database, every thing else uses ADO. It has a lot of features such as Personal Contacts, Personal Internet Links, Search and Printing, Personal Reminders and also Sending Email using the vbSendmail component found on http://www.freevbcode.com. Please read the file readme.txt before you begin. All the source codes are included so you can compile the code for yourself. Please leave your comments or feedbacks And Remember to VOTE!!!. Last Updated : October 03, 2000. The ZIP File Contains a SELF-EXTRACTABLE FILE with the Source Code. Note : the bugs with the vbsendmail component has been fixed. If you have any suggestions for the next version please let me know.

Hi,Family Address Book v3.0 - update 3 has been released on September 25,2000. Please don't be fooled by the name, it is not just a simple address book - check it out and you will see. This time around I mostly use ADO instead of DAO and now the user is allowed to add or remove any category of their choice. It has a lot of features such as Personal Contacts, Personal Internet Links, Search and Printing, Personal Reminders and also Sending Email using the vbSendmail component found on http://www.freevbcode.com (DLL File include in this ZIP FILE). Please read the file readme.txt before you begin. All the source codes are included so you can compile the code for yourself. Please leave your comments or feedbacks And Remember to VOTE!!!. Last Updated : September 25,2000. The ZIP File Contains a SELF-EXTRACTABLE FILE with the Source Code.

This is an application that allows you to connect to a database and view all the properties of a stored procedure and writes the VB and ASP code for you to run each particular sproc you are viewing. It is a pain to have to write wether a sproc parameter is inout or output and what type of parameter and what is the max length...etc. Just point to the sproc and all the code is created. There's even setting based on how you would like the code written for you.

This program demonstrates how you can take a table from a database (MS Access only in this demo) and convert all the records in that table into an HTML document for viewing in a web browser. With very little effort, you can add more HTML tags, more records, etc to have a really nice looking web page. I'm working on one that will use SQL statements to get certain information, instead of the whole thing. The code is well commented, and any questions can be directed to me

Read a list of Stored Procedures from a SQL 7 Database and pull their parameters out and format them into code that can be pasted into a code module. This can save a ton of time if you have sprocs with over 20 arguments.

This article attempts to explain the Microsoft Jet collections and how you can use them in really useful ways. If you don't know about Jet collections, this is well worth reading.

Sorts the records in a datagrid form when clicking on the column header. Toggles between ascending/descending sort order.

This SW allows you to create complex SQL sentences, working with the Dictionary of the Data Base in use. This sentences can be saved to use it later. IMPORTANT: This SW was made in Spanish. As I drop the source code, change it to English is easy. Advances: -Works like the ISQL command. -You can select the number of records to be recalled, and the timeout. -The response will be separated by ASCII 9. Pass it to an Excel Worksheet to work with the results. -You can create the masks for: insert, select, update, delete of the tables. -You have a create table/index template. -The sentence can be converted to a string to pass it trough the clipboard onto your VB project. -You have an internal buffer, to work with two 'clipboards'.

This Project is an example of how to open a file into a byte array and save that byte array to an Access database, and to extract binary data from the Access database back into a byte array and save it back to a file. This example uses .bmp and .jpg graphics files but with minor modifications any type of file can be saved in binary format to a database. again this is only an example application. I threw this togethor in a couple of hours so there are some minor bugs in the code. a little bit of error handling should clear them up. Hope you find this usefull

This is a prefabricated database browser to be used with bookmark- and clone-supporting SQL databases (MS-Access for example). It lets the user browse a database or search for specific entries and then select an entry for further processing. The appearance and contents are customizable. Everything above the blue line is part of the OCX Control. Simply stick it in a form, set a few properties and you're go with a commercial quality browser/record selector. A cross linked help file is included. Download is only 20.5 kB.

To show how to ADD / EDIT / DELETE information from an access Database. Fully Functional - Ready to be used in your programs!!!

This code will demonstrate opening, reading, editing, moving within, adding and deleting records within an Microsoft Access 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.

Do you hate trying to remember fields in your database? Do you wish you could view/modify your data on a mainframe using an access-like interface? Well now you can! DataFX2 allows you to open any ODBC data source and view the contents of the database. The fields will be displayed in a list from which you can drag and drop right into your code! Never have to remember or type those long field names again! Whats even better is that you can open a table and add, delete, and modify data in a simple access-like interface. And every window has the stay on top or fall behind feature which allows you to make a window always appear in front of other windows so you can view your field names and data while you are coding. On the datasheet, you can filter records using SQL. One of the nicest thing about this program is that it shows you how to prompt the user with the ODBC data source dialog window (I couldn't find this anywhere on PSC). The program also has the ability to open databases using either ADO OR DAO!!! The recent file list also keeps track of which databases or datasources you have recently opened so you can quickly open a frequently used datasource. The recent file menu shows which items are ADO or DAO. Another nice thing about this project is that its a good way for beginners to compare ADO to DAO because almost every line of ADO code has the DAO equivilent below it. The program is also commented and easy to read. Please leave comments and suggestions!

Ever be in the middle of coding a program and you forgot the name of a field in your database? You had to open MS Access, find the database, open the table and get the name of the field. Then you had to go back to VB. Well this program gets rid of all that hassel. You start the program, open the database and it stays on top. It displays all of the fields and tables as well as field types and properties. It will also allow you to modify information in the database. No more going back and forth, just put it off to the side and all the info is right there. Check out a sleeker version of this software here http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=33286&lngWId=1.