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

Heres another good example of using a winsock control to access a ADO database over a network/dialup connection. This project shows how to Add/Delete, Read/Write access with ease. Also I have inbedded authentication against the database via the winsock control. This project gives you the functionally to store and retrieve data remotely and keep track off multi-users online with up to date online and offline status's, into a treeview control. you can create personal folders and use drag drop features to move messages around (remotely). Also allows users to compress the database to keep hundreds of message clean and tidy. also this code shows how to export messages and send internal messages to the server to be export by email, by a internet dialup connection. Now works with Windows NT / Windows 2000. email me if it doesnt work. chris@hatton.com Please Vote....

Give you an idea of how to store your friends information Better version than earlier. Download it now and try it. Please vote me. Thank you!! If any bug please report, thanks.

This code shows how to use an array obtained from 'GetRows' and navigate through it as though you were using a pageable recordset

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!

MS Access developers will be amazed at this solution. Smart form requires zero programming on your part. What if you could intercept the MS Access sql statement before any database transaction occurred and record this statement in a journal, would this be valuable to you? Of course it would. What if you could replay the journal DML entries in the event a database crash occurred, would this be of value? If you haven’t solved the transaction problem you’ll love this article. Spread the word through the news groups.

Megacomputing - Waren Sortiment, enables yor Store your Sortiment, Computers Hardware etc in a database, with price EK _german buy price , and Sell price VK it wars prog for my hardware store i need it ************************************************ Updatet: Some bugs Fixed.

Backup and Restore your Outlook Address Books contacts. You can save your contacts as different profiles which means you can maintain different contact books and restore it whenever and wherever you want! Saves you considerable of time and resources since your address book is now intact and is stored in a Central repository. Ideal for a network environment with a central Database server(SQL Server, preferably).

I am doing a project for a retail system. In the design time, I need a command button for simulate the pageup and pagedown function for flexgrid. I have found no code reference for this function, so I post my own code here to share with you. Your feedback is welcome!

Very simple application that stores information about software. Stores Title,Serial#/CD-Key, Company/Author. Most significant thing is the use of DAO 3.6 to manipulate the database and write the report for printing. Code is commented, and clean. Limited error-checking and input checking. I do not plan on doing much more with this program, other than use it to keep a list of my own software. Please give me comments, votes NOT needed or requested.

This code lets you add a new table to existing database in SQL Server programmatically. Useful when developing a database application for off-line users. Simply send an executable through e-mail, and let it run once.

This project demonstrates a number of important ADO Data Base - VB methods and utilities. 1. Paramount of these utilites, from my perspective, is how to get the totals from a database field as well as how to multiply the items in two DB Fields and then create another field to show the answer. In addition a running total is kept, showing the Sum of the multiplied fields. This is a feature that any inventory data base requires. 2. Make an ADO Connection without using the ADO Data Control. When a program uses the ADO Data Control(s) it hard connects the data base to a given directory ("C:\My Documents\MyDataBase.mdb"), or worse yet the directory that the program is design / built in; (C:\Program Files\Microsoft Visual Studio\VB98\MyDataBaseProgram\etc"). This connection causes havoc when the product is installed to a client's computer. Of course a work around for this is to make a DSN Connection, but this requires the inclusion of numerous files in your setup/install program. When the connection is made through the use of code as opposed to using the ADO Data Control the Database file is located / installed in the program's deployed directory and is easily connected to. 3. Deploy and show all of the data using the MS DataGrid Control. Program shows how to fill and set the Data Grid. This demo allows adding and deleting of records directly on the Data Grid (Although this method is not recommended due to lack of ease, the better method is to use the programs Text Boxes). 4. Program sets up a TextBox and recordset movement procedure that emulates the familiar data control methods, i.e., The user can move through the records - movement is apparent in both the Data Grid and the Text Boxes, and the Current Record and Number of Records are continously displayed and updated when records are added or deleted. 5. Program makes use of the MS Report Designer in lieu of Crystal Reports. I have used Crystal Reports in the past and had numerous problems. I now use the MS Data Report exclusively. If you have any questions/problems with this demo it will be in this area. Study the DataEnviornment and DataReport Designers Structure

** PLEASE VOTE FOR MY CODE - EVEN IF YOU DON'T LIKE IT ** GREATLY simplifies accessing JET or SQL Server databases. No more Connection String, provider, data source, Persist Info etc. properties to fill in. Provides easy to follow instructions right inside the DLL.

Generates Insert, Update, Delete and Select stored procedures for SQL databases

This tutorial aims to provide an intermediate Visual Basic 6 user with the basic skills required to retrieve and manipulate data from many commercial databases and any ODBC compliant database using the Active Data Objects technology. It includes a sample project and a full tutorial in Word format. The html version can be seen at http://users.tpg.com.au/jaqmar/adotutorial.htm.

a simply sort on de collumsheaders of a datagrid

SQL Server Enterprise Manger clone (demo only, not complete). This demo can demonstrate that how to use SQLDMO to create your own SQL Server Enterprise Manager which may perform every job the Enterprise Manager can do. In this demo, the following things are included Enumirating SQL servers on the network Logging on to any Selected Server using Windows Authentication or User Name and PWD Getting List of all Data Bases Getting List of all Tables Getting List of all Stored Procedures Getting List of all Users Getting List of all Views Getting List of all Roles Getting List of all Rules Getting List of all Defaults Getting List of all User Defined Functions Getting List of all User Defined Data Types Getting List of all Accessing properties of each object listed above like date creation, owner etc. Creating New Database Creating New Table Creating New Stored Procedure Deleting Database Creating Table Creating Backup of Database Restoring Backup More things can be done by understanding the way these things work. Not very hard, just simple It will work only if you have SQLDMO Library, If you have SQL Server installed, then it will work definatelly Sameers (theAngrycodeR)

Please check it out. It is a good tool.

New and improved database application for storing Serial numbers and CD/Product Keys. It uses DAO 3.6 (part of MDAC, downloadable from Microsoft) flex grid, simple encode/decode function for keeping the database "secure." Let me know what you think, I dont care about the votes. Sorry, but I did NOT include ANY actual serial numbers or CD/Product Keys.

Exaple of using MS-Chart control and ADO database. Load data (by projet id, by dates) into 2 dim array and graph it. Ability to Save/Print/Copy graph .

Creates a Microsoft Database (MDB) on the fly and adds tables dynamically in Visual Basic. The program needs a reference to Microsoft ADO Ext for DDL and Security.