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

This source code compares two database structures and wrote report or copy differences into second database. It uses DAO control and works with MDB database.

This is a small application that uses ADODC control to connect to Access, Excel etc. ODBC data sources and execute SQL statement on them. The DataGrid control are used to display returned data. The application has it's own simple SQL code keyword formatter, logging and other features. Small, efficient and robust. Could be a good example of how to use ADO object to connect to DB, execute SQL queries against data in DB and handle the returned data.

SQL Server Documenter can display, print and export to Excel a complete overview of all fields and indexes in a table. This started as a "hello world" type of thing for SQL-DMO and this is the result. It's great for debugging or documenting your databases (that's why I wrote it ;-)). Try it and any suggestions are always welcome.

ADO Recordset Paging in VISUAL BASIC !!! There are many code samples that making recordset paging available in ASP ( Web based ). This example of ADO Paging through a recordset is written in Visual Basic !!!

This is the only one ADO Boolean Search on Planet Source Code !!! [ AND / OR / NOT / AND NOT ]

This code will demonstrate opening, reading, editing, moving within, adding and deleting records within an Microsoft Access database. Updated with some error handling and other stuff :)

This is a Bible concordance that you can use to store bible related topics and scriptures. So like you could create a topic entiled "Abortion", with scriptures against it, and come back at a later time and view it. It uses an elaborate database of text files to store all info. Next version im going use MS Database. If you add anything cool to it, please let me know. Thanks.

Este codigo facilita las conexiones mediante el ODBC creando un DSN segun el driver (class) que se este usando (Access, Dbase, Paradox y MySQL 3.51 en esta versión). Estupenda herramienta para los programadores de aplicaciones que usan bases de datos tales como Paradox o Dbase. Duda o sugerencia favor de ponerse en cotacto conmigo. With this code, u can connect to many databases formats using ODBC, like Paradox, Access, Dbase or MySQL, with a short numbers of lines and easy. Try it :-)

This code is a great help for those people without Microsoft Access and want to administer their Databases easily. Includes full source code. Shows all records at a glance, allows editing, adding and removing. If you like this please support me.

Internet Cafe System .. to calculate time and the cost for each PC in the cafe .. There is a DB to save user accounts and information about them

This program convert Access Database to the MySQL database. It has many functions like Copy Full Database, Create Only Structure, Create And Copy Database, Create Table Structure, Create And Coppy Table, Coppy Only Row etc ... I made some examples with it and although i used an access db with 100 000 records it did not gives any error.

Browse to your database. This MDI program opens the database, seeks for tables and puts the fields into new documents. When double clicking a field from a table, the relation between other tables will be shown. Simple Code ..

Have you ever needed to switch the file extension of a large set of files from .htm to .asp but you were worried about other web sites linking to the .htm files? You could create a new redirector .htm file for every file you switch to .asp. Or, you can just download and set up this solution! Just drop this file somewhere on the web server (remember the URL), and then configure the Custom Errors settings in IIS (by default pointing to 404b.htm) to point to this file's URL. That's it!

I have searched psc for a way to put images on a access database and all that i could find was complicated code so i decided to do it myself and a few minutes later i have come to this...a simple way to store any file on a database field. Note that im not using BLOB field here.... Its simple and it works two most important things to me... hope you enjoy.

If your scripts are running too slow, it may be that you have a function that's taking too long to run or that gets called too often. This function profiler watches the all of the function calls and records how much time is spent in each function. All of the documentation is included at the top of the source code.

This is a Visual Basic Code Guide to keep track of all your Basic Code.. This is fra from Complete, so Suggest any thing yuo would like to be seen on it. And yes I know there are plenty of these on PSC.I wrote this foir my self and for others to learn not to just get votes.

This sample program is just used to show you how to load the entire Database into MSFlexGrid using ADO and SQL command.You can view and search all country Code by just a click.

Compact Access Databases with one line of Code! "One line of Code", like this: ;-) CompactDB Database, ShowResume, Password or this example: CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" Private Sub CompactDB_Click() If DB Is Nothing Then 'the database is Closed CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" 'compact Else 'the database is open DB.Close 'close CompactDB App.Path & "\Datos.mdb", True, "Joselo.11·#" 'compact [Call your Routine to load database] 'Open database End If End Sub Works fine with Access 2000 and XP Actual Revision - Jan/20/2004 Jan/20/2004 · some Form changes. · fixed some variables declarations. (Variants in place of Strings). · added Compact Password protected databases. · added some Comments. · added some Code examples. · added a compress level indicator. Jul/25/2003 · Initial Release

A simple example on how to add/Delete a DSN to the ODBC of a Windows Operating system. Completely commented.

Application to access Adaptive Server Anywhere databases. Uses CMAX OCX (http://www.compiled.org/files/115/259/cmax20.ocx). Uses RDO for data access. All other components are standard VB components. Help File not included because of licensing restrictions. Sub Main is in sqltool.bas. SQLAny.bas has data logic in it, and could be modified for other databases.