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

This code is used to store, track, research and share recipes. I got the application about 8 months ago from PSC from a posting by Bob Davis from Tallahassee Florida. I loved the concept and some of the recipes were cool too. I really liked what Bob did but since I'm a database programmer I had some challenges that I was interested in tackling with regards to his initial design (plus I was board) so this is the result with a few added plus's that my wife dreamt up. There is one thing that is bothering me about this application though and maybe you fellow coders can help me out. For some reason I cannot distribute this to any family members or friends without installing VB6 on their computers. They are using 95B and 98? I have traced it down to the Data Access pieces for the errors (particularly the compact and repair commands). I have installed the MDAC on their PC's and it does not work until I install my copy of VB (Pssst, Please Don't Tell Bill). If you have any advice or critisisem, go ahead and let me know because there is always a better way, a different perspective or something that everyone did not think of. Pardon some of the not so neat code. ;-) Best Regards, Tom Williams

Save binary objects to a DAO database, eg: pictures, exe files, dll's etz. Its a generic class module that allows saving/extracting from any access database. Also gets additional fileds if required for example a persons name if it was stored in the same table

the engine i am providing is an asp code generator that i am currently using on my website (www.intratelligent.com) to allow asp developers to upload access databases online and build simple asp interfaces to interact with their data. (insert / update / delete and reporting functionality).

Give you an idea of how to store your friends information.Please rate me after downloading my work. Thank you! *version 1.1 is out

This utility allows you to easily update the structure of one .mdb file from another. It analyzes the source and creates the changes to the destination. It is a good tool for quick updates to multiple files. Please keep in mind that this was kinda 'thrown' together to serve my own purposes and is by no means a finished work.. it has helped me and I thought it might help someone else... :-)

This copies, renames or deletes stored procedures on an SQL server. Also the ability to copy procedures cross database, or even cross server. This thingy is way easier and faster then the import/export wizard.

This code connects to a given SQL server and database and returns field info from a specified table. Handy if you need a quick printout of a table definition and you don't have time or patience to wait until EM has launched and connected to the server.

A report wizard which allows users to create their own simple reports and outputs them to a word doc. Includes sorting and criteria. I have modified this from Oracle to Access for demo purposes. I am also still working on it so any positive feedback would be appreciated. There are a few more things I would like to do like sort the Criteria operators according to datatype with, add totals. Feel free to use and modify. If you come up with anything good send it on!! This is the first app i have uploaded so I hope it works!!!!! Please read the attached readme file as there is a few things to do before the app works. i.e. add a query to a database.

It lets the user compact any database including password protected ones. And it also over writes the old one. Uses no controls only API.

** Release 3 ** New cTREEVIEW features: Flat border; IsChildNode; CopyNode with cancel option; Cut Icon state. ADO example supporting: Load on demand; Find First/ Next/ Previous; Label Edit; Drag'n'Drop; Node & TreeView context menus; node specific Open/Closed/Drag icons. ADO Example now supports: New Nodes/Records can be added; copy treeview node(s); Cut/Copy/Paste through right-click context menu; and functions are now benchmarked with results displayed. ** Release 2 ** cTREEVIEW class features: Scroll treeview Up/ Down/ PageUp/ PageDown/ Home/ End using code; Dragging with auto-scrolling (not supported by Microsoft in the TreeView control); NodeFirstViewable; & NodeLastViewable. ADO Example fixes: Find Next/Previous didn't work if branches already loaded. cTREEVIEW class fixes: correct node drag icon displayed. cTreeview features include: fast clear a treeview; extended Add/Rename/Delete nodes; copy & move nodes through code &/or Drag'n'Drop including parent nodes onto child nodes (not normally possible!); find node using text and (optionally) key properties; check if a node is a parent of another; checks if a node is a root node; a safe get parent node text; right-click context menu (before/after click event); collapse/expand all nodes; collape/expand all child nodes; enable/disable redraw. This example shows how to:- work with multiple tables of data and load data on demand. As a bonus, I've included cDB class that encapsulates working with an Access Database using ADO. All code is heavily commented. If there are any routines that you feel are missing or code/bug-fixes that you wish to contribute, then please let me know and I'll add them in. *** Latest version can be found here:- http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=37553&lngWId=1 ***

Use UDL files for your dataconnections instead of DSN.

Read from and write to a database on a web site via simple ASP pages from within a VB program, if you do not count DIM statements then this is all done with just 4 lines of VB code (+ 25 or so in the ASP scripts). Uses ADO & XML. REQUIREMENTS: CLIENT PC: MS Internet Explorer 5.0 /5.5 (IE4 will not do) ADO 2.5+ XML (3.0 preferred) SERVER: IIS4+ or PWS ADO 2.5+ XML 3.0

This project demonstrates a number of important ADO Data Base - VB methods and utilities. 1. Paramount of these utilites, from my perspective, is how to get the totals from a database field as well as how to multiply the items in two DB Fields and then create another field to show the answer. In addition a running total is kept, showing the Sum of the multiplied fields. This is a feature that any inventory data base requires. 2. Make an ADO Connection without using the ADO Data Control. When a program uses the ADO Data Control(s) it hard connects the data base to a given directory ("C:\My Documents\MyDataBase.mdb"), or worse yet the directory that the program is design / built in; (C:\Program Files\Microsoft Visual Studio\VB98\MyDataBaseProgram\etc"). This connection causes havoc when the product is installed to a client's computer. Of course a work around for this is to make a DSN Connection, but this requires the inclusion of numerous files in your setup/install program. When the connection is made through the use of code as opposed to using the ADO Data Control the Database file is located / installed in the program's deployed directory and is easily connected to. 3. Deploy and show all of the data using the MS DataGrid Control. Program shows how to fill and set the Data Grid. This demo allows adding and deleting of records directly on the Data Grid (Although this method is not recommended due to lack of ease, the better method is to use the programs Text Boxes). 4. Program sets up a TextBox and recordset movement procedure that emulates the familiar data control methods, i.e., The user can move through the records - movement is apparent in both the Data Grid and the Text Boxes, and the Current Record and Number of Records are continously displayed and updated when records are added or deleted. 5. Program makes use of the MS Report Designer in lieu of Crystal Reports. I have used Crystal Reports in the past and had numerous problems. I now use the MS Data Report exclusively. If you have any questions/problems with this demo it will be in this area. Study the DataEnviornment and DataReport Designers Structure

I wanted a way to send messages to the users who are in an access database. This code opens and reads the ldb file for the database (that you specify on the form), reads the user names and sends a message....all without API calls. You can do a lot more with this obviously (I trimmed it down a lot for this forum). You will need one text box for the source of the ldb file (named txtLocation), one command button, and one text box for your message (named txtMsg).

I work with Access databases, and occasionally will need to update the front end on the server. With access, you can tell when all users are out when the ldb file is missing. Therefore I created this app that checks for that ldb file. When the file is missing it uploads a specified file to the specified directory. This works excellent for me so that I can update files when all users are out. Hope this is helpful to you. Feel free to add/change or make suggestions.

This document explains how you can write Oracle stored procedures, that will return ADO recordsets to your VB or ASP application.

Generates Insert, Update, Delete and Select stored procedures for SQL databases

Class object that can be compiled or copied and pasted into your application that will dynamically create ODBC DSN's for you.

I had a datagrid which I needed to output/print, rather than go through the whole printing process I decided to try export it. This code takes values in a datagrid - populated from an access bound datacontrol, and exports the datagrid to a csv file for input into excel.

This project demonstrates some code concepts such as use of classes, functions, passing variables, and registry control for setting SYSTEM DSN's under ODBC.