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

Document your Access database structures with ease.

myAnalyzer is a simple query analyzer that allows users to run SQL Statements to their mySQL database. This program does not use ADO but rather connects directly to mySQL through the DLL file included with mySQL (this through the help of some code borrowed from an individual mentioned inside the code). myAnalyzer also allows the user to save the sql query as well as print the query or it's results. The program has full search capabilities and can run multiple queries in one window or multiple queries through several databases in an MDI environment. I hope this benefits others out there as I wrote it to help me debug my SQL queries for my apps. You can connect to your mySQL server through a logon screen, or pass the information through to the exe from another application or command line.

Opens MSAccess 97 and 2000, works with databases with passwords. it allows the user to add, edit, delete modify RECORDS from any access database, also added defrag database function. Please Vote. :D

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

Easy way to create a backup job and schedule it into SQL Server. Pretty small and restricted but allows you to specify backup schedule such as Daily, Monthly etc. You can backup your database and restore it.

This is designed as a wrapper to the MySQL API, it is a windows dll and just needs compiling and registering before adding a reference to your projects, it provides a means of accessing a MySQL database as you would using ADO. This is the second and final version and has been compiled and tested with both VB6 and VB.NET and works very well with both. Please give feedback on this as it will help me to improve on it. Also please feel free to suggest anything that you would like to see in future version of this dll.

It's not true you can't use Seek with ADO in Access.

This is the first wizard I made and uploaded to PSC. I never saw the one like this on this site. So I made it. This program/wizard will help you and save a lot of your time to build an ADO Code Project. You can build your ADO Code Project by entering and selecting data/tables/fields based on Database or DSN or parameter you entered/selected to connect to your database. Everything is available in this wizard, included if the .mdb file was password protected. This you can't find in VB Data Form Wizard. So you don't have to build your project from beginning by adding controls on your forms, write the code, adding the components and references, etc. The wizard will automatically add those to your new project. You can also add the find, filter, sort, and bookmark procedure/form to this new project. I made this wizard because I often make ADO Code Database project in my office, and this is really really save a lot of my time. You can learn how to make wizard from this program. I got the template of this wizard from Visual Basic, and I modified as I want to, and I added a Help file that you can call from the wizard. As a matter of fact, this wizard is rather similiar to VB Data Form Wizard in Visual Basic, but I had modified the wizard by adding a lot of enhancements. Please download and prove it now. Any comments, feedback, and votes would be truly appreciated.

Well.. for those who where happy about the previous version, heres a little update with scripting for Views, StoredProcs and missing tables. Works like a tierelier (Dutch ;-)). For those who don't know about the previous version, it compares 2 SQL-server databases. Also if somebody doesn't know how to implement a splitter, here's a idea how to do that :-).

This control will take care of you when you do database application, it serves as your recordset for your form, it will LOCK objects for you, do the BACKCOLORING of objects and Clear Values of objects. Just add the object to its control collection and bind data on it. The nice part of it is that you can save IMAGES to your database without calling or adding codes that will handle chunks. It can also search the database up to 3 columnar search, for more precise record retreiving. It has also a good error handles to avoid error when user encode a wrong value to the database. I hope you find this code useful and your vote would gladly appreciated. THANX.

***UPDATED 02/19/2003*** This is a quick and simple documentor for SQL Server. It returns a list of registered Servers in your EM. You choose the one to connect to, then you choose the database - once connected it will return a list of Databases - then you choose what you want to document and how you want it returned in an Excel Spreadsheet. It's well documented code so you should be able to make changes without much pokin around.

This is a Password Program. does what the Windows 98/95 Password screen does. But the program cover's the whole screen. It shows how to use Database... And find the computer's Username...

I had problems using the datagrid attached to an ADOdc control. Here is what I found.

Any true application uses a database, however after deployment, some times you add or modify some fields, and it becomes tiring to adjust the changes manually at clients sites. this is a stripped down version of the application ( there may be some errors due to the stripping down of unneeded funstions ) . Enjoy it without reservations. Vote if you feel like this is something beneficial for you.

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.

This project shows you how a user login to program and access menu based on his/her level. Program will display every possibility fails message whenever user failed try to login. The chances for login are only 3 times. After that, user must try again from begining. I also made a form to manage user account, that can be accessed only by user with level 'Admin'. Password field was encrypted in database. 'Admin' can manage all user accounts (add, edit, update, delete, change password, decrypt password, view user activity that saved in database, convert/transfer user activity data to log text file, and view that log text file). User can change his/her password. If user level is 'Operator' or 'Manager', he/she can only change his/her own password, but 'Admin', he can change all password user, and his too, of course. And I made menu to compact, repair, and backup database to manage your database performances. I use database Access97 password protected. I also made setting menu to change program setting (run program at startup - this will be occured if you had made an .exe file named 'LOGIN.exe', display screen saver if program idles in for a certain time, protect screen saver with user password, and don't show tips at startup. There is a 'Tips of Day' which display its data from text file. You can learn how to make a tips form and display the tips form or hide it at startup. The user activities that saved in database can be transfered to text file, and this log text file can be displayed from this program, too. So, user activities data can be transfered to text file, and you can delete the records from database. This will reduce your database file size. I made a screen saver form with analog clock. I used Thaha Husain's code to make the needle clock movement (just like a clock in your wall). Thanks to Husain for this code. Screen saver cannot be interrupted by 'Ctrl-Alt-Del', 'Alt-F4', 'Ctrl-Break', etc. Only active/current user can quit form screen saver. If user quit from this program, there will be an offers from program whether your computer would be shut down directly by program or not. Well, that's all I think. Hope it's very useful for you. Any comments, feedback, and votes would be appreciated. Thank you.

TreeView control is one of the most overlooked controls by developers for use in database applications to display picklists. This is mainly due to the lack of data binding and time required to code. This wrapper does it for you! It simplifies the display of complex data relationships using ADO and the TreeView control. I've made it as generic and flexible as possible whilst significatly improving loading performance over manually coded methods. Features include:- --- Loading records on an "as-needed" basis when Nodes are expanded (includes optional control over the expanding of Nodes) - significatly reduces load time. --- Simple and complex data relationships with support for:- a). recursive record linking; b). many-2-one data relationships; c). one record can be displayed multiple times - each instance of the same record can be fully customised i.e. different images, colors, etc...; d). unlimited data relationships and nesting levels. --- "A pictures is worth a thousand words!" - color coded ranges; Images as warning indicators; color coded regions, etc... Built-in automatic support for customisation of *ALL* Node display properties on a "Per Record" basis - NO MANUAL CODING REQUIRED! (Does not use the .Tag property of each Node - does anyone want this property automatically filled?) --- User defined sorting - uses the SQL "ORDER BY" clause instead of each Node's .Sort property --- Custom filter criterias --- Persistance of data relationships (with associated icons). This gives several benefits: - a). the defined relationship is portable and can be stored in the registry, as a resource, record in the database, or to disk (in-built function); b). Bind your database to the treeview control with only 3 lines of code when using a persisted data relationship! c). Can copy any part (or all) of data relationships between different instances using the .Contents property; d). any modification to icons or filtering can be persisted allowing progmatic or user customisation between sessions &/or applications, users, etc... o ... Load-on-Demand (using its own wrapper class) is exposed for use with other non-ADO bound TreeView Controls within your application. It's very easy to Use the wrapper - Define a data relationship, point to the Database, and then the wrapper will do the rest. The zip file includes: all source codes, VBADOTree.Dll, Five (6) demonstration applications ranging from simple implementation of the Load-on-demand feature (non-ADO Demo) through to a complex inter-table relationship (9 tables) with recursive data structures, custom filter criterias, non-alphanumeric (custom user-defined) sorting, and conditional node properties. Both the Wrapper DLL and demonstration applications are fully commented. Demonstration applications also include very detailed comments and notes on how the data binding and automatic SQL building actually works. This should make implementation in your own projects very easy.

It is a great visual tutorial to learn about Databases in Visual Basic. This is the part I because i couldn't upload the zip file. Please download part II at http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=44042&lngWId=1. This is not a simple tutorial, it have steps by step and with every step have a photoscreen to guide you With it you can learn: - How to link an Access database to VB - How to view the database in labels - How to create, delete and edit the differents register - How to make a filter (search engine) of strings, number and Dates - How to resolve common problems with DB - How to show the database in a sheet like Excel (Datagrid control) - How you can manipulate the DB with the Ado Control invisible - How to specify a format for a type of data like "$ 23.80" or "23/sep/2003" - and much more... Also have a very good example divided in VB in three parts: 1- View, add and edit DB 2- Find in DB 3- Non visible Ado Control with Datagrid control I recomend it for beginner or newbies in DB and also for that who want to make better

Please download part I at http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=44040&lngWId=1. I'm sorry but i can't load the zip file in one. It is a great visual tutorial to learn about Databases in Visual Basic. This is not a simple tutorial, it have steps by step and with every step have a photoscreen to guide you With it you can learn: - How to link an Access database to VB - How to view the database in labels - How to create, delete and edit the differents register - How to make a filter (search engine) of strings, number and Dates - How to resolve common problems with DB - How to show the database in a sheet like Excel (Datagrid control) - How you can manipulate the DB with the Ado Control invisible - How to specify a format for a type of data like "$ 23.80" or "23/sep/2003" - and much more... Also have a very good example divided in VB in three parts: 1- View, add and edit DB 2- Find in DB 3- Non visible Ado Control with Datagrid control I recomend it for beginner or newbies in DB and also for that who want to make better

This project shows how we can print a very simple report to text file using RichTextBox control and to printer. The report contains simple information with quantity and sum of item per page, the sum of money per page, and total of sum of money in the end of report. User can select category to display the report. User also can change the number of record would be displayed in the screen/printer, and can change which printer will be used in combobox. The selected printer is the default installed printer in your computer. Including functions to adjust text-alignment in the report. This is very useful for you who want to print a simple report with many record to your screen and to your printer, without using the third party activex control. Any comments, feedback, and votes would be truly appriciated.