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

In development of dynamic website using ASP, recordset paging is one of the very useful feature. This code "Dynamic Paging in ASP" makes the recordset paging a child's play. You just have to modify three parameters in the paging.asp file and voila, you can use this code anywhere in you website. Just gives the name of database file, name of table and no. of records to display. That's it ! I am sure it will be a very handy code for any serious ASP Developer.

Connect to any ODBC compliant db using RDO. by the way MySQL, Oracle, FoxPro, Excel, Access, Sybase are all ODBC compatible. Use this code to connect to Unix databases, Linux databases, etc. Very simple (easy to follow) code. If you would like to see the same in ADO, or want me to add DB creation/editing capabilities let me know. Currently you can just add, update and delete records as well as run queries. Please Vote, I stayed up late working on this. Comments positive and negative welcome.

By default Access string fields contain NULL values unless a string value (including a blank string like "") has been assigned. When you read these fields using recordsets into VB string variables, you get a runtime type-mismatch error. here is a nice code to get rid of that

This shows you how to make an address book with databases.

This is a Contact Data Base with to organize our personal contacts or company contacts. This code have other features like Login User and Password, add contacts, delete contacts, edit contacts, search contacts, Print contacts, send email to our contacts without a external email program, a calendar and a digital clock.

I have used SQL queries for Add, Modify, Delete, Update and Search in the databases. Everything neatly coded and commented for each line. A very good example for beginners, who needs to know the coding standards for connecting to the database using ADO. Comments appreciated.

This module contains procedures for working with the Microsoft Jet User-Level Security model in terms of user, groups, passwords and permissions.

Allows user to connect to database(Access or SQL Server), view schema(tables, fields, databases). It's main feature is to allow the user to point and click their sql queries using an updatable text file containing sql constants and a treeview of the actual database. Please let me know what you think.

SQL Server Viewer-Updated: Connect to SQL Server, Select Database, Tables, Views, Procedures, Parameters, Datatypes, execute queries, save queries, open queries. Very useful for working on MSDE Servers! Feel Free To Contact Me With Questions/Comments.

This code demonstrates a simple way to save Images (or any binary data for that matter) into a database... I would like to receive all kinds of comments and suggestions so, please give the same...

As a lot of other people's reasons for posting source I post this because I couldn't find any help with the MS Data Environment. So after playing around with it I finally got it to do what I wanted it to. This Example is composed of basic ways to manipulate the Data environment. Add, Edit, Delete, Search, and pull report information. Use of ADO Transactions is also covered. Hope you enjoy it and learn something. The example uses the basic contact database concept. Please vote if this code is useful.

A complete database application. Sorry, but the program is in Portuguese(brazil), I'm uptade to English soon. It is Intermediate because the code is not commented. Please vote for me or leave a feedback!

This code will import textfiles into a MS Access database using different kind of seperators. A MUST SEE CODE! It works great and can be used for a lot of things!

Reportgenerator similar to crystal reports or list and label. at the moment, it´s documented in german. it uses dao to print reports out of access-databases (either with or without print-preview). it should be no problem to migrate to ado to get access to any type of databases.

A simply utility to search US postal database. You can search by city, state, areacode, zipcode, or county.

I have worked out all the bugs in this realse, I changed the UI a little but it's still the great looking employee database. PLEASE RATE IT IF YOU LIKE IT . Any comments are welcome. The User Name and Password is "admin"

This is an excellent database program the screen shot speaks for itself has a lot off features. Basicly for storing and keeping track of employees. "PLEASE RATE IT IF YOU LIKE IT" it also has a custom CD Player built in. I will be uploading version 2.0 in 1 week so keep an eye out for it cause if you like this you'll love version 2.0. Still a littly buggy but it's still in its beta stage. Thanks PSC

To generate Payslips

Automatically generate a function to create an Access 2000 Database With ADO. I catalogue this program like a utility. This utility generates a function that you can use inside your apps to create an Access 2000 Database With ADO Reviewed Verion 1.1.0!

I catalogue this program like an utilitiy this utility generate a function that you can use inside your apps to create an Access 2000 Database With ADO Reviewed Version 1.1.0! Vote Please! Just copy and paste the code generated to new VB project and two references Microsoft ActiveX Data Objects 2.5 Library Microsoft ADO Ext. 2.5 for DDL an Security