Results for "Category: Databases/ Data Access/ DAO/ ADO"
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.
To handle multi-users / concurrency of a MDB using eith DAO or ADO in the VB 6.0
Some SQL Server actions: - create database - delete database - execute SQL command - execute SQL script
Here are two functions that will allow you to read and write a Large Binary Object (BLOB) to and from a database. This could be used to store and retrieve images, documents, etc inside the database it self. This is great for those of use that have a lot of Binary files around that we want to keep in a central place that can be backed up and protected with the same security that a database offers. This code will work with *ANY* database that ADO can connect to.
VBRSGen is a handy VB 6.0 Add-In that creates formatted ADO/DAO recordset and SQL code from Access database tables and queries. Generates variables, sets objects, etc. Also includes a simple "Where" clause creator tool and a results preview grid. Code is ready to paste from the Clipboard or Notepad. Some SQL statements aren't parsed properly, but these can be easily edited; this still saves a lot of time in repetitive ADO/DAO database coding. I'm making this available elsewhere as shareware for $20, but because the PSC community has provided so much invaluable support and helpful code, feel free to download the open source code here for your own personal use at no charge! This was originally posted in early April 2002 and received amazing feedback and dozens of "5-Globe" votes, until the PSC database had some problems. So please vote and leave feedback to let me know what you think!
Take the advantage of learning ADODB and the datagrid control in a MdiForm with the capability of doing; addnew, delete, edit and search... Thanks for using ...
Thanks to Collin McAllister for the 7/13/1999 submission this is based on!! A visual adhoc query form that allows multiple criteria selections and simple joins. A simple (limited) somewhat user friendly way to create simple queries.
VB module to read and store ANY kind of picture file pictureboxes support into a database, it's easy and it's pretty fast... please, rate it, any comments are wellcome
My code is a way to password protect a cd, so that only a certain user can access the setup program, it also allows the user to choose which one of the cd drives its in.
PLEASE FIND A BUG!!!!!!!!!!!!!!!!!!!!!!! I DARE YA! I fixed the one that was found when you type somthign in the main interface when you have an empty dat file then click in the search list box. See if u can find more. By the way PLEASE VOTE!!!! thanx ;-) Well finally after heaps of emails complaining about the source safe protection HERE you go!! a non protected version, as you will see the code is a shocka, it really needs arrays. It reads everything off a text file to save HD Space. I am going to make an Access version prolly in about a month or so, well maybe longer coz i am doing my HSC. Anyway, this prog 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! I DARE YA TO FIND A BUG!!!!!!!!!!!!!!!!!!!!!!
This was a piece of software i did for my HSC major assesment, 93% cheerin! Anyway, i have put a fair bit of work into it, it still has bugs, coz i only finished it the other day i haven't had a chance to fully de-bug it. There are also some changes I would like to make in the near future, but it is basically finish, so please enjoy, let me know what u think, and PLEASE vote high, i would love to win this months comp :-) The Admin Password and Teacher password are both "Gilroy"
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!
With this application you can see how DAO works. You can completely control the database with this code, you learn how to read, insert and delete things from a database with no data controls or whatever :-) And also a great deal of the ListView control is used for this app. And it is completely documented and explained!!
Helps to maintain credit customers, with the details of bills and outstanding balance, etc. Useful for small companies, total solution. No need to purchase big software which has got too much unwanted functions for which you don't need to pay for. The code has got very useful stuff like managing ADO DB, creating reports, etc... hope you like the code and most of all the application. Most of the reported bugs are fixed (which were a few ui bugs). Check out now the update.
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
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.
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 (DAO); I have also written an ADO version, which I will post later. 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.
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