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

Easily Compact & Repair a MS Access Database and display the size differences.

This will give you the tools and instructions necessary to convert your DAO project to ADO.

Hi folks, The purpose of this code is to scan a database's table and then export them into a number of text files. Simplely change the name of the ODBC. Cheers

This is just a small login app you can use in your programs. It uses an access database. You can add users. Starting username: username password: password. Please give feedback. I know there are bugs.

MyVbQL is a Visual Basic API for accessing MySQL databases. This API was developed as an alternative to the MS ADO - MyODBC interface that VB developers must use for MySQL database connectivity. For more information, visit http://www.icarz.com/mysql/

PROBLEM: Creating a copy of a Recordset could mean using the Recordset.Clone method sometimes. However, this is not always appropriate because ADO’s Recordset.Clone method creates a Recordset which points to the same data as the original Recordset. This means that you really do not get a physically distinct copy of the original Recorsdet. Consequently, changes to the clone copy could modify the data in the original Recordset. An alternative solution would be to use a loop to append each record to a new recordset. This, however could end up being an unwieldy solution with potential performance penalties. SOLUTION: ADO 2.5 comes with a Stream object that can be used to create physically distinct copies of Recordsets. The article below demonstrates the use of the ADO 2.5 Stream object in copying Recordsets and the difference between the Recordsets created by the Recordset.Clone method and ADO 2.5 Stream object. Please see attached file.

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. (The login password is set to nothing for the moment so if you want to access the application just click the login button)

This code can be used as a template for creating master forms.

Search data in a database depending of what you write in the textbox, if you press the "M" key in the textbox you will get all the data that begins with "M", VOTE FOR ME !!

Simple program that views a database, transacts custom SQL statements in SQL Server 2000. The SQL-VB connection established here is the foundation of many front-end applications in RDBMS nowadays. This project uses ADO programming techniques.

What you can do is hook up to a database, and with the use of a timer control, you can make a list of any/all records you want in a database. You can use an SQL statement (in the code already) to find a certain part of a string. The return results are any record that contains that particular string in it. Then with the click of a button it will go through each record found and make a list of them. For example, For a spell checker, I took a database that contained over 5,500 words. It went through that database in a little over 5 minutes to get every word made into a list. Very good ideas can come from this, have fun with it!

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

Print a crystal report in a certain date range

Have you ever try so send a SQL String to a database that has apostrophes ? If YES you will get a run time ERROR Here is your solution....A function that formats the variable before sending it to the database

Fix Apostrophe in strings for SQL query

Heres a good example of using a winsock control to access a ADO database over a network/dialup connection. You will be able to access the database fully, with Add/Delete, Read/Write access. Also i have inbedded authentication against the database via the winsock control. This program is simply for basic job tracking, from inhouse, and for remote access areas. Bascially how this works, It sends the server a few commands/strings, and the server generates the sql statement and sends back the results, to the client winsock application, it then recieves the information and displays it out into a listview control with columns. --------------------------------If you like the code please vote!

Provides a simple to use, yet useful phonebook/contacts program. I have gone through and sussed out pretty much every bug I could think of, see if you can find any!

This program generates code that will open and close an ADO connection and recordset. There is also an option to generate navigation code. There are several other options which allow the user to select cursor style, cursor location, and locking style. Note: This project is an add-in. In order to use it, load the project, go to file and choose make ADOToolbox. Then load it from the add-in manager.

UPDATED: Added better error handling just to be safe and neater... Also added more sound so all commands have a sound and upon loading a 3 second wav plays also... Great for learning how to add sound to enhance your program...Great for newbies to learn from...My first ADO database, i learned from tutorials on here specifically from Jerry Barnes so i think this would be great for people new to ADO databases to learn from but i suggest finding Jerry Barnes ADO For beginners source because it is incredibly commented on and will surely have you creating ADO within 20 minutes. I tried my best to eliminate any bugs but of course there has to be some somewhere... I also used sheridans active listbar for this program, the ocx is packed in witht he zip. Please let me know if i didn't include a needed ocx,file or just if something doesn't work right so i can fix or at least try to fix it. This took me awhile to make so please at least vote for me. Fixed a bug witht he extra button caused by a incorrectly placed setfocus, also fixed abug with the edit option displaying when save was pressed and causing an eof and bof error after the person tried to edit after re-opening the database later. Fixed a lot more bugs in this newer zip. -- IMPORTANT: Password for login is chris

We had a client who 'accidently' copied one databse table into itself causing duplicate records. Unfortunately Access only allows 10 columns in its De Duplicate wizard and we had twenty! This code allows you to pick the database you want deduplicating, lists the tables and the fields within the table so that you can chose the 'key' fields to deduplicate on. Then it creates a table within the database which contains all of the deleted duplicates from the table you chose. It assumes that you don't mind which instance of a duplicate record you want to keep and it uses Jet 4.0. Also if you run the appliaction twice on the same table you will loose all of the deleted records from the first session (it dosent create a second instance of the deleted table). It also dosen't contain Error trapping as I use Aivostso's VB Watch addin that creates error trapping for you. However, leaving that in would add superflous code so I have omitted it here. This code was wriiten on the quick but it has ben used in anger with correct results. Any constructive comments will be appriciated.