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

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.

A complete Medical Store Retail Management System. Sales & Inventory Control. Stock Monitoring with expiry dates etc...

This is a code that i just add some lines because the original code not create index, primary key, etc.

Version 1.5 of award winning Wolf DataGrid, fully working data grid now with many new features.

If you hate Microsoft DataGrid and you dont need, cant find or dont have $300 for other grid then you are gonna love this ;). This is an activex control made in vb to replace bug-plagued DataGrid that you got with vs6. It is pretty fast, supports many things that are left behind in MS DataGrid and it is open-source (though not for proper distribution for now). Have a look at screenshots if there are some (psc might not allow me to upload them). There are some examples included on how to use the grid. It does not matter what drivers are used since this grid uses t-sql for reading/writing data. For now it does not support built-in editors, but that is to be added in next version. Just download the example and experiment a bit. If you need any help on using the control post comment here and I will be glad to help. This is first version, so please post any bugs you may find.

It loads the present records to the inside with a Database in a ListView with ADO and through SQL it is possible to load the records, it includes also the ordering of the columns in ascending way or descending with the icon that it indicates the type of ordering. Finally the present records in the ListVIew are possible to print through 2 selections all or the records select to you through checkbox. Code is full commented! PLeaSe VoTe FoR Me!!!

MyVbQL is a Visual Basic API for accessing MySQL databases. This API was developed as an alternative to the MS ADO - MyODBC interface that VB developers must use for MySQL database connectivity. For more information, visit http://www.icarz.com/mysql/

Want to work with MSACCESS database? This code is for you. You can perform add, update, delete and searching operations on database. Best part is the searching.UPDATED WITH FULL HTML HELP ON 9th Oct. 2002.How to write to registry is also explained with full error handling.Please vote for me....

Cant remember the important things in your busy schedule? Then have this code (Using MS Access Database). This code reminds you on the date and time set by you by a popup window which will be on top of all running applications. Prpoerly commented. You can reschedule the reminders. Can mark them as pending a or done. At start up checks all the reminders which are not shown previously bcoz this application was not running at that time.when you close it (by X) then it will be in the system tray.Dont forget to vote for me.

This update includes the HTML help file. I have made this help with "helpMATIC Pro HTML". This is a very easy to use shareware tool to make html help files. Everything else is same as of the previous version of E - Minder.