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

This Project Allows the end user to access a MSAccess Database through a Client Winsock application, without having any Data Access Components installed on the local machine. This also allows fast read/write access through modem, or a dead slow computer. The client app sends the server a few strings and then generates an SQL statement, and then does all the hard work and sends back the results to the client.

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

This code is the beginning of a library circulation program. Two of my freinds and I woked on this. It doesn;t have many of the feature implemented, but Take a look, show different was of accessing databases. Login:David Smith Pass:98022 The Use Administration >Books to get barcode numbers And use Administration > Patrons to get patron Numbers Then Use Signout. Try double clicking on a book Please send any comments to the feedback or daveismith@hotmail.com

zwo routines for easily retrieving Table- and Fieldnames of MS-Access-Databases

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!

Connect to text file(s) and perform advanced queries using ADO. You can even return recordsets on CSV file without a header.

This sample project shows how to scan a network for all domains, then list either all servers on the domain or only the SQL servers on the domain. It uses the NetEnumServers API call and a NetEnumDomains function found in the NIMM.bas module which was originally written and posted here by *Patrick Herbst*. The NIMM.bas module has a TON of features for network management. FANTASTIC JOB Patrick! Thanks also goes out to Michael Monaghan for directing me to the posting that LED me to this solution. Even if this sample is the greatest thing since sliced bread to you (doubt it), please do not vote for this module, 99 percent of the REAL CODE was not written by me. I used alot of ideas from alot of authors (including Microsoft's technical articles).

3-TIER Test project illustrating high performance Data Access for SQL Server using ADO command objects and Stored Procedures in a 3-TIER ENVIRONMENT USING VB CLASSES for Insert, Update, Delete and Select. This project runs on Northwind db.

A article showing how to create a global ADO connection to SQL server from a Visual Basic Client.I have more examples and programming solutions on my web site www.SQLwarehouse.com

Connects a Data Grid control to a data source using Datalinks and an SQL statement.

Populates a treeview with a database's tables then uses the node click event of the treeview to populate a data grid.

There has been a few questions on how to use VB to connect to a mySql database. This will show you how to connect without using a DSN. Most of the code is from a ADO Tutorial from this site. I just modified it to show how to connect to a mySql Database.

Have you ever wondered how to remotely fire a DTS Package in SQL Server 7 from a Visual Basic Application? Me too... So through rigorous research and aggrevation I figured out a very simple way to do this.

UPDATED - 12/07/01!!! This kind of goes against my article earlier this this week. In a new environment I was able to do two things. I was able to query a list of DTS Packages from my Server and then execute a chosen Package remotely. This can be easily modified to accept collections and remotely fire multiple Packages on a timer (which is what I'm using it for). If you downloaded the zip file earlier you may want to download it again since I've updated it and revised some of the references. NOTE: If you use a DSN connection it must be pointed at the MSDB database to get the list of DTS Packages, not the Database you are trying to run the DTS Packages Against.

visual user interface to construct a query

This will read the table form an access database and then creat the textboxs on a form with the field names mapped to the textbox names. It will then create the code to save what is in the text boxs back to the data base

This code is used to search for clients in an access 2000 database using ADO and a parameter query. In our database we have roughly 20000 records to search and it still finds them very quickly.

Complete application. Customers Database, inventory system, search databse records, cool gui, Debtors alert, password protected. http://www.codeauction.com

Complete application. Customers Database, inventory system, search databse records, cool gui, Debtors alert, password protected. This application is suitable for a car shop. Whenever the mechanic finish a job on a car the only thing he has to do is to use the service wizard and select the parts he used from a list and the number of the parts. The application substract the number of parts used from the inventory and gives the subtotal and total price. http://www.codeauction.com

This sample shows how to use Access Database by using DAO Library. It shows all that you need to know about database using. Its well commented and there is help about all commands used.