Results for "Category: Databases/ Data Access/ DAO/ ADO"
This code will let you repair and compact an Access 97 or 2000 (haven't tested on other versions yet) database. Using JRO, when you call the CompactDatabase function, it automatically repairs the database first. You must have a reference to Microsoft Jet And Replication Objects x.x Library in your project. Also, where I have a DoEvents in the code, there really should be some routine that checks to see when the file is actually deleted. I've tested this on databases that are about 5 megs in size with no problem. If anyone has any ideas (maybe a routine that checks to see when the file is unlocked or deleted), let me now. Thanks and enjoy!!
Ok, and now that you have finished your Super Multiuser Access application ,would you like to know who is logged on??? well, here is the answer and the code to do it. don´t forget to rate if you like it.
This code/tutorial is a beginners guide to connecting to your own SQL Server database.
A complete Database application. Based on ADO Database.It has some new mathematical features. I used here FLEX GRID. Moreover coold design. For more code Please Contact with GENERAL CORPORATION BANGLADESH didar911@yahoo.com tahmina911@yahoo.com
A Simple Love Calculator.. Just Fun.... For more code Please Contact with GENERAL CORPORATION BANGLADESH didar911@yahoo.com tahmina911@yahoo.com
zwo routines for easily retrieving Table- and Fieldnames of MS-Access-Databases
Provides a wrapper around ADO future proofing your code and making accessing your database much easier. Ensures all your code is standard and uses the best data base access techniques. Also provides functions to convert a recordset to HTML or CSV format - handy for web pages as well as client/server applications. WOULD love your feedback, feel free to contact me directly or submit comments.
VERY VERY SIMPLE CRYSTAl REPORTS VIEWER - View Any Crystal Report with ease..lets you add reports to a list that you use all the time. Also allows for changing the parameter values. Very easy to understand code -- example report included. Hope you enjoy.
Since MS-Access doesn't support accent insensitive queries by itself (MS SQL Server does as far as I know), I had to create a function that would fix the problem. With this function, it is possible to turn any SQL query into an accent insensitive query. With a few little modifications, it works great with ASP too!
To show how to ADD / EDIT / DELETE information from an access Database. Fully Functional - Ready to be used in your programs!!!
How do you avoid the "Invalid use of null" error when reading null values from a database?If you try to retrieve a null value (empty field) from a database, you will get the error: "Invalid use of Null". Here is one way to get around this problem: ..
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.
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!!!!!!!!!!!!!!!!!!!!!!
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!!!!!!!!!!!!!!!!!!!!!!
Create an MS Access Style Combo or ADO DataCombo using a class and a single property
THIS IS AN EXAMPLE OF HOW YOU CAN DO A SIMPLE TABLE WITH DATA, SO YOU CAN NOT USE THE FREEFILE() , YOU CAN MAKE MSFLEX GRID, TEXT BOX,COMBO BOX ETC WITH THIS CODE, AND IS SO EASY, TRY IT, PLEASE DONT FORGET TO VOTE FOR ME THANKS.....
Creates a database using a Random-access file. also shows how to use Multi-Interface Documents in your applications.
This nifty little program interrogates Microsoft SQL Stored Procedures and generates VB code to interface with them. The concept was Adapted for VB from David R. K. DeLoveh's work for Active Server Pages found at : http://www.15seconds.com/issue/010718.htm the article make for a very good read so do so if you can! I converted it to run under VB and spruced it up a bit. While programs like LockWoodTech's PROCEDURE BLASTER do the same thing they cost $$$ and this is free. If you like it remember to give a vote. And again thanks goes out to David R. K. DeLoveh's for his original work. With this code in hand it would be easy to modify it to be MTS/COM+ compatiable. For more extensive developers tools like this one check out www.LockWoodTech.com.
select any access database then select the table you want then select and insert any fields to a richtextbox then preform a mail merge like MSWord. you can then browse through the database while viewing the merged data.
Enables any user that can login to a database to monitor sybase activities. You can monitor your SQL transactions, functionalityy accdate, audflags,dbname,fullname,language,name,password,pwdate,resultlimit,spacelimit,srvname,status,suid,timelimit,totcpu,totio,affinity,blocked,cmd,cpu,dbid and much much more