Results for "Category: Databases/ Data Access/ DAO/ ADO"
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
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.
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.
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.
This is an update to the fantastic work of Jeremy van Dijk on SQLScripter 2.0. I have added just a few minor enhancements by borrowing more great code from Royce D. Powers (SPGenerator). The main feature that I've added is the ability to generate INSERT scripts for a selected set of tables - definitely NOT difficult, but handy. I have also made the command line options more complete and added a few extra.
This program, show many statistic about your Data Base And it convert your data base to HTML and SQL format. Please, Vote for my source code...
The purpose of this class is make easy to generate ConnectionStrings to open ADO databases. Just setting some parameters you can easy open Access MDB with or without password, SQL server using username and password or Windows NT login, DBase III files, Excel Worksheets, Oracle and ODBC. Plus, with a minimum of modification you can easily add support to any other database. Of course that you always can hardcode your connections strings but this class will make this for you on a very friendly way. I'm updated with minor changed and translation of comments to english. Since it's my first submission to planet source code will be glad if I have some feedback positive or negative. I hope that this class can be so useful for you as it is for me. :)
This application can Extract the existing DAta structure of any SQL Server database and it can be saved in HTML table format.Tables structure of selective tables can be Printed.Table can be taken copy
This Application is used for quick access to an Oracle Database. The DataFetcher gives you power to Add, Remove, Search, View, Records at a click. DataFetcher also has it's own built in SQL*Net emulator in it! If you access an Oracle database frequently, then this is a must have Application. You must have Oracle Client installed on your machine to take advantage of the ORacle Object used in this code. Please Email for any questions or feedback. Thanks.
Address DataBase Shows VB and ADO
Backup and Compact a MS Access database file (*.mdb). Output a *.csv (Comma Delimited)File.
This shows how to two things, first how to pass variables to a stored procedure on a SQL server, second it shows how to handle multiple recordsets being returned from the stored procedure. This allows for a greater speed then trying to pass the entire SQL query to the server especially when you have several. Please Vote if you like it! :)