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

This small program is very usefull when you want to compare destination mdb file from your development mdb. It is not only compare the database (tables, indexes and queries) schema but also Fix It !, this prog use temporary mdb to hold the schema so you just bring this prog and schema file and compare it at your customer. if you like it please give me a credit!

Open a password protected MDB using DAO or Data control or OLE automation

Well This is my First App and my First Submit to PSC. Please take a look. I wanted to make an DataBase. To start simpel i made an Address book. I know there are a lot if this books here. But this one is diferent :). It has the function with Last File Opend, File Asosiation, (with open and print function) printing an DataReport and some other stuff. Im just an beginner with VB6. So comments and stuff are welcome. if ya wana Vote do so if not do not :). Greetz Black-Dextra

I used this class for well over 2 years. It is easy. It comes with a simple program that show you how to use it. I am sure that once you will know how it is working that you will adopt it.

It is a Good example for those who want to connect the Database with ado, Visual basic Suggestion and Comments are Welcome

Need Part 11 compliance then you will need multi-level password security with passwords that expire. This sample application will show you how to this to your applications. All you need to do is copy 2 forms, a class module and a module to your application (see below) and you are ready to go. It was written to use an Access database (ADO). You set up the access rights, add users, and assign these rights to the users. New users, by default, are assigned the password of password, which they must change the first time they try to log-in. A user can change their password anytime they choose as long as they know what their assigned password is. The security file (security.pwd) can be renamed to anything you like and is password protected. You can assign a unique application ID to insure that the security file can only be used with that application. If you are connected to a network, the application will display your network log-in ID automatically in the Log-in ID text box. The passwords can be set to expire after a user-defined number of days.

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

I have noticed recently, how many people have been going into the discussion forums and asking how to use databases. well, this is a very simple example of how to manipulate data within databases Functions include add, edit, and delete records, and a search by surname. this code is fully commented. please comment on this upload, as i would like to know what you think, and if you think there is a better way of doing certain things, argue it out all you like! daz

This is an app to organize and keep track of the different recruiters that I have been dealing with looking for a new job. It stores all of your contacts in an access database, allows you to search on all fields, sort on Company Name or Contact. Allows you to send email or go to the recruiters website. This is my first submission to PSC. I would appreciate as much feedback as possible (Good or Bad),and some votes if you like my code.

Converts your code ISBN to Code Bar. Convierte tu codigo ISBN a Codigo de Barras.

Copy the table structures and records from one database to another. In my case, I use this code to copy from an ODBC SQL Server database to a local Access to allow users access to a copy of the data when they are not connected to the network.

Full Movie Tutorial: This is part one in a serious of video tutorials that explain visual basic Database programming, This tutorial shows you how to create a database browser without one line of source code

CreateMDB will analyze and dump the sturture of an Access database into a BAS-module, you can include in your own project. From your own project you can now create an access database on the fly. This project is using ADO/ADOX v2.5 but will also work on v2.1. Updates in v1.0.13 : Minor bug regarding Nullable columns fixed. Updates in v1.0.12 : Minor bug regarding table description fixed, and found a solution regarding Nullable/Allow Zero lengh. Updates in v1.0.11 : More tableproperties added and a MRU list added to menu. Updates in v1.0.10 : Password dialog added, and some minor code updates. Updates in v1.0.9 : Support for Queries aka Views and Procedures and improved Errorhandling.

This application discovers all about ADO Connection builder to help you Creating ADO Connection String to any databases or maybe use the codes to your project in simple way as 123.... Don't forget to vote me.....

PlanetSource code is a life for VB programmers. I have learned many thing from this website so I felt I will give this code to all the programmers who are willing to learn the database concepts. I tried for this kind of code but all in vain. Dont worry. This is the best and the ultimate code for all the Database programmers who have been waiting for ages. The whole world is looking for a control of this sort. I as a enterprise solution provider found it very difficult to debug the recordset and find the exact match in the recordset by pressing F8 .. F8 .. F8. Dont you think doing this way wastes your time and money... The main purpose of this code is to print the contents of the recordset of ADO,DAO,RDO. Within a fly we can see the contents of the recordset. This will save a lot of time. The main purpose of this code is to pin point the exact location of the data that we need. We use filters to check the data and reduce the recordset to find the exact match. But this control by clicking on the tab sort the contents of the recordset and display to us. You can change the order of the recordset fields by dragging.

Creates an UDL-File (Universal Data Link) from an existing ADO-ConnectionString. Unfortunately the DataLinks-Object in the "Microsoft OLE DB Service Component 1.0 Type Library" provides some prompting dialogs to choose an ADO-Connection, but a save method to get an UDL-file is missing. So I coded this. Note that this wasn't as easy as it looks now, cause an UDL-file is no normal INI-file, although it seems to be one. The first thing is, that it must be saved in unicode. The second and very astonishing thing is, that the second line, which seems to be a missable comment, is very important and must be exactly as it is. Otherwise the UDL-file wont work! Comments and votes are welcome.

This project was developed to help those just starting or wanting to start usind ADO and MYSQL Database. Contains a module that creates a MYSQL database on the fly. Hopefully this will help some of the new people get off the ground with ADO and MYSQL quickly and learn the full capabilites of using this combination. Please read the Program and Module notes before running.

To handle multi-users / concurrency of a MDB using eith DAO or ADO in the VB 6.0

This will show you how to code in Linux using g++.

Good database program to learn from. I suggest getting it. It was one of my first database programs, and this makes it easy and stuff. Has add, delete, edit and search feature. Also uses SysGarbage.ocx for system tray access. It is cool. Please rate.