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

By default Access string fields contain NULL values unless a string value (including a blank string like "") has been assigned. When you read these fields using recordsets into VB string variables, you get a runtime type-mismatch error. here is a nice code to get rid of that

Define a connection in Excel, run a SQL query from excel and return the results into an Excel spreadsheet.

vbs script code , using recursion , collections , this code convert xml files into sql recordsets. Usefull for search purpose , news management etc...

Creates a database using a Random-access file. also shows how to use Multi-Interface Documents in your applications.

The purpose of this app is to show some basic operations on databases using DAO 3.51 . Very good for begginers.

For conversion of MS Access Databases between JET 3.X and JET 4.X (MS Access 97 and MS Access 2000) using DAO 3.6. This is my first contribution after years of visiting PSC. Not detail commented. (Please see the ChangeMDBVersion.exe.txt for more information.)

A Visual Basic application development framework for Microsoft Great Plains (Dynamics and EEnterprise) accounting software. This application runs completely independant to Great Plains. (If you require seamless integration consider using Dexterity and/or VBA). The initial version allows a user to login to the system, and select a company. The project has also been registered on www.sourceforge.net as open source (search for Great Plains). The idea is to build up a library of code and accelerate application development. Included is a sample program to copy security settings from one user to another. (Be sure to read the readme.txt before using this program!)

This code can be used as a template for creating master forms.

This shows you how to make an address book with databases.

Hi folks, The purpose of this code is to scan a database's table and then export them into a number of text files. Simplely change the name of the ODBC. Cheers

if u have SQL running on NT this code help you in connecting with SQL server by passing some parameters Like Provider,User,Password etc.After established a successfull connection u can choose tables from the combobox and automatically all records will be shown in datagrid from selected table.

I have used SQL queries for Add, Modify, Delete, Update and Search in the databases. Everything neatly coded and commented for each line. A very good example for beginners, who needs to know the coding standards for connecting to the database using ADO. Comments appreciated.

This database comparison tool can compare 2 databases for differences. It can give you missing Tables, a script to create it... Check 2 tables for missing cols... Right now this works with only MS Access Databases... planning to include SQL Server and Oracle too.... This uses ADO objects... so mdac 2.5 is required on your machine. This is available in Microsoft's Website.

*** A1 Database Copmarison Tool.... Can compare 2 databases for missing Tables.... Can compare 2 Tables for columns and report the missing one's... Generate the Create Table Script... Run the generated script on Target database.... lot more to come.... Uses ADO DB Objects... Can connect to MS Access NOW... SQL Server , Oracle , Foxpro etc ... later...

Allows user to connect to database(Access or SQL Server), view schema(tables, fields, databases). It's main feature is to allow the user to point and click their sql queries using an updatable text file containing sql constants and a treeview of the actual database. Please let me know what you think.

SQL Server Viewer-Updated: Connect to SQL Server, Select Database, Tables, Views, Procedures, Parameters, Datatypes, execute queries, save queries, open queries. Very useful for working on MSDE Servers! Feel Free To Contact Me With Questions/Comments.

This code demonstrates a simple way to save Images (or any binary data for that matter) into a database... I would like to receive all kinds of comments and suggestions so, please give the same...

We recently run into a problem working with a web farm and replication. We where getting a error that the tech people were say it was code and us the code people was saying it was Server related. Well, First we know it only happens 3 out of 10, So it must be happening only on one or two servers. If it was code It would happen on all servers, right??? Well, Lets find out which servers get the error, but how? ServerVariables only returns BROWSER header information and we need machine specific data. A Clustered farm generally uses the same IP info on a load balancer. so how do we get machine specific data. Well, use WSH of course. Three Lines. Hope you enjoy it. This will not work on XP, because the disabled WSH by default. you can turn it on though. check MS Knowledge bases for instructions.

Make MSHFlexGrid Editable without help of any textbox or other control

As a lot of other people's reasons for posting source I post this because I couldn't find any help with the MS Data Environment. So after playing around with it I finally got it to do what I wanted it to. This Example is composed of basic ways to manipulate the Data environment. Add, Edit, Delete, Search, and pull report information. Use of ADO Transactions is also covered. Hope you enjoy it and learn something. The example uses the basic contact database concept. Please vote if this code is useful.