Access Compare Databases
(182 kb)
Access 97 Utility to compare Create/Modify dates of objects in two versions of the same mdb file. Created by Dave Rich and available at the Geotech Computer Systems web site.
Check out Dave's new, updated, Access 2000 version of Compare DBs application.
|
Access Equiv of App.Path
(2 kb)
DAO Code that reproduces the App.Path Method of VB in Microsoft Access 97.
|
Aggregate Rows
(27 kb)
Access 2000 mdb file with code to create a table, populate it with rows, and finally, aggregate (group) multiple rows into a single row per item.
|
ASP Client Error Log
(28 kb)
ASP pages and Access MDB for capturing client generated errors. Requires error logging routine in mdb client file.
|
Auto Download New Client
(437 kb)
Access Client and Data files with helper mdb file to perform automatic update of client mdb with the new version.
|
Auto Logout Users
(774 kb)
Access sample code that demonstrates how to include forms that will automatically log out users who have left their client open and attached to back end data.
|
Catalag SQL Scripts
(124 kb)
Access 97 database for parsing, storing and executing SQL Server scripts.
|
Combine Field Values
(3 kb)
Reply to Newsgroup Post about combining field values from multiple rows into single row.
|
Compile All Modules
(2 kb)
Code to Compile All Modules of an MDB file from VBA.
|
Cookie Renamer VB6
(9 kb)
VB code to rename cookies. (assuming that you want to clone them for a different user.)
|
Copy Wizard
(58 kb)
Microsoft Access 97 database application to compare the objects in 2 different mdb files. In addition to listing missing objects, such as tables, queries and forms, it allows the user to copy objects from the source mdb file to the target.
|
DataFast Utility A97 & A2K
(607 kb)
Microsoft Access addin that contains numerous tools to simplify conversion to SQL Server. It includes a Documentor, a Query Converter, Query Timer, SQL Formatter and other various other tools.
|
DataLink Shortcut
(1 kb)
Registry file (.reg) to put a reference to Data Link File on Desktop right-click New menu.
|
Delete Duplicates
(3 kb)
Access 97 VBA code to delete duplicate records in a table. Associated download link included.
|
DSN-Less ODBC
(60 kb)
Sample Access Form to explain how to create a DSN-Less connection to SQL Server. The form could serve as a login screen and has the ability to read login parameters from an ini file.
|
EMail From Access 97
(76 kb)
Sample Access applciation demonstrating E-Mail functionality in Access, using both DoCmd.SendObject (MAPI) and Microft Outlook.
View Outlook code script.
|
Employee Training DB
(698 kb)
Complete Access application (Front/Back End) for employee training management. The design provides for courses to have "modules" or sub-courses and includes a number of reports.
|
Enable JET ShowPlan
(1 kb)
Registry file (.reg) that will set required keys to cause Jet ShowPlan, query execution plan to be generated.
|
Enumerate Network Servers
(8 kb)
Code to Enumerate Servers on a Network.
|
Export To Excel
(32 kb)
Access 97 Database that takes a User and Task table and creates an Excel spreadsheet in a crosstab fashion.
|
Export/Import Form As File
(2 kb)
Code to export a Microsoft Access form as text file and then import form back into the mdb.
|
File Backup/Zipper VB6
(171 kb)
VB sample tool to simplify the process of backing up development files, such as Access databases. The utility ncludes the code necessary to ZIP the copied files using a 3rd party zip dll.
|
Format QBE SQL
(7 kb)
Code to reformat SQL taken from the Access QBE SQL window.
|
FTP From Access 97
(55 kb)
Access 97 database with FTP functionality provided by the Microsoft Inet control.
|
Get File Details VB6
(31 kb)
VB tool to determine DLL and OCX file versions ... and other information
|
Implement FTP VB6
(42 kb)
VB application with FTP functionality provided by the Microsoft Inet control.
|
Inbox Watcher
(203 kb)
VB 6 tool that alerts you to incoming messages without having to have Microsoft Outlook open.
|
JMail From Access 97
(177 kb)
Implement greater mail functionality by using free 3rd party COM object named Jmail.
|
KB Search
(261 kb)
Complete Access 97 Database designed to demonstrate how to perform "fuzzy" search on a variety of fields. Also demonstrates automatic linking to back end database.
|
List Relationships
(103 kb)
Access 97 and 2k Databases that demonstrate how to programatically list relatinships and their details.
|
MDB Crack Access 97
(35 kb)
VB source code for project that can be used to crack Microsoft Access 97 MDB file passwords.
|
Misc Stored Proc Scripts
(12 kb)
Zip file containing a collauge of scripts, created by various SQL gurus, taken from the swynk.com code library. (Each proc is unaltered and includes information about the author of the code)
|
MSDE Admin Utility VB6
(17 kb)
Utility using SQL DMO and SQL NS libraries that ship with SQL Server to provide an interface for distributed MSDE applications.
|
ODBC DSN Lister
(38 kb)
Sample Access Form to read ODBC DSNs from the Registry and place them in Rowsource of Combo Box. The form also shows how to open the Windows ODBC Administrator utility using the Shell() command.
|
Outlook Mail Example
(4 kb)
Code to automate MS Outlook from Access
|
Outlook/ASP Free Busy
(5 kb)
ASP Page that uses CDO to link to Exchange to display user's schedule free-busy times.
|
Progress Meter Code
(33 kb)
Access 97 form that shows how to use simple form controls to display active progress bar, without requiring an OCX control.
|
Registry Functions
(33 kb)
Access 97 database form that shows how to read and write values to the Window's registry.
|
Report Example Access 97
(66 kb)
Sample Access mdb that contains a report example where each page contains the same number of rows, regardless of the number of records printed.
|
Right-Click Reg DLLs
(1 kb)
Registry file (.reg) that creates registry keys necessary to put Register DLL and Unregister DLL on the right click menu.
|
Set Line Length
(4 kb)
VBA code to set line length (wrapping) for parsed string.
|
Sproc/VB Class Creator VB6
(327 kb)
Utility to reverse engineer SQL Server Stored Procs into VB COM class component code.
|
SQL Object Browser VB6
(6 kb)
Utility to facilitate the extraction of metadata and other information from SQL Server databases.
|
SQL Server PWD Tester
(37 kb)
Access 97 database tool that can scan the network for servers, domain controllers and SQL Servers. Once found and selected, a SQL Server is tested to see if the SA account password can easily be determined.
|
SQL SProcs Scripter VB6
(25 kb)
VB Code to automate the scripting of all Stored Procs for a SQL Server Database. The sample uses the SQLDMO and SQLNS libraries to extract Stored Proc info and includes code to zip script files with a 3rd party tool.
|
SQL Upsize Docs
(319 kb)
Miscellaneous collection of helpful documents for those considering an upsize from their Microsoft Access database to SQL Server.
|
Time Zone Stuff
(58 kb)
Access 97 Database that can be used to generate a table with Offset Bias from GMT in minutes for any time zone. The code behind the form could be adapted for generating time zone information on the fly.
|
Timeclock Example
(44 kb)
Implementation of KB Article about how to calculate daily hours on a Clock-In Clock-Out basis. View Article 237958
|
Undelete Access Table
(5 kb)
VBA code to recover deleted table in Access 97.
|
Update Control Tool Tips
(2 kb)
Access 97 VBA code to populate the Tool Tip text with Status Bar text. (The access Form Wizard will populate Status Bar text, but not Tool Tip text.)
|
VBS Get Quote
(15 kb)
VBScript code to extract random quote from Microsoft Access 97 database.
|
VBScript: Backup mdb
(3 kb)
VBScript to rename and backup a Microsoft Access MDB file to a network share.
|
VBScript: Compact an mdb
(3 kb)
VBScript to Backup and Compact a Microsoft Access MDB file to a network share.
|
VBScript: Create an ODBC DSN
(3 kb)
Windows Script to programmatically create an ODBC DSN.
|
VBScript: Create Contact
(3 kb)
Create and Save a NEW Microsoft Outlook Contact.
|
VBScript: Create Outlook Note
(2 kb)
Create and Save a NEW Microsoft Outlook Note.
|
VBScript: Create Public Appt
(3 kb)
Script to create a new Microsoft Outlook Appointment in a Public Folder.
|
VBScript: Create Task
(3 kb)
Create and Save a NEW Microsoft Outlook Task.
|
VBScript: Execute Query
(3 kb)
Script file to EXECTUE a Microsoft Acces query that can be automated as a nightly batch by executing it from Windows Scheduler.
|
VBScript: Export Table HTML
(4 kb)
This script invokes the DoCmd.OutputTo method of the Access Application model to create an HTML file based on a table.
|
VBScript: Find Contact
(4 kb)
Find ALL Microsoft Outlook Contacts matching a search string.
|
VBScript: Import File into Access
(3 kb)
Script to Import a comma delimited text file into a Microsoft Access Table
|
VBScript: Send Mail Msg
(3 kb)
Quickly Create and Send an Microsoft Outlook mail message.
|
VBScript: Send Mail w/Attach
(3 kb)
Quickly Create and Send an Microsoft Outlook mail message with file attached.
|
VBScript: Spell Checker
(3 kb)
This script allows you to spell check any text. It opens Microsoft Word, pastes the text and executes the spell checker user interface. When finished, user edits are returned in a msg box through VBScript.
|
VBScript: Today's Tasks
(3 kb)
Script to quickly view Today's Uncompleted Microsoft Outlook Tasks.
|
VBScript: View Unread Mail
(3 kb)
Script to quickly view Unread Microsoft Outlook mail items.
|
VBScript: Write Module to File
(3 kb)
Script to Open Access Module, extract code text of module and write it to a text file
|