FreeAxcess v1.02

FreeAxcess v1.02 … brought to you FREE from RedHeadedLefty.com!

If you enjoy using this program and would like to give a donation to the developer, please click the button below

**Note - .Net Framework is needed in oder to run the program. If you do not have this, go here

Download FreeAxcess v1.02 (330KB)

(MSI Installation Package)

Found a Bug? Need Help? Want to see something else in the program? Post It In The Forums!

Description

FreeAxcess is a program I created in VB.NET that lets you work with Microsoft Access (MDB) database files, without the need to have Access installed on your system. It is designed to work with existing databases, as currently in version 1.0, there is no option to create new tables or new databases. However, if you have an existing MDB file, and need to add records, view the data, or even export the data, then you can!

Features:

  • Ability to view all tables and queries
  • Ability to Add, Delete, and Modify records
  • Exporting tables to Comma Seperated Value (CSV) files for easy importing into other programs
  • Query Database function - Ability to easily create and save your own custom SQL queries for custom Reports or Data Views

Installing the Program

To install the program, simply double click the FreeAxcessSetup.msi file to run the installer. The only requirement to run the program is that the windows machine needs to have the .NET Framework installed, as well as Microsoft Data Access Components (MDAC), both of which are free downloads. MDAC is installed by default in Windows2000 and WindowsXP, so chances are you already have it. Try running the program, if you get errors when you click it, you most likely need the files. You can get the Framework here.

Documentation

Most buttons and controls in the program should show a tooltip that shows info of what the control does. Below is some extra explanations on some of the functions:

Query Database window- This window allows you to write your own SQL query and execute it on the database. If you know SQL, then you can easily create custom queries for the tables in the database.. You can save these queries if you choose, by clicking the save button and giving the query a name. This then saves the query for later retrieval, and should be shown in the “Saved Queries” box. **Note - the queries are not stored in the database, they are simply stored in the “queries.txt” file that is created upon first running FreeAxcess.

queries.txt - this is the file created upon running FreeAxcess for the first time. This stores the saved queries from the Query Database Window.

Export Button - this button is located on every table view, as well as at the bottom of the Query Database Window. Selecting this allows you to export the data in the window to a Comma Seperated Value (CSV) file, for easy importing into other programs.

Queries - “Queries”, listed on the Database View, are the queries that are present inside of the Access Database, and cannot be modified, nor can data be edited or modified when viewing them. These are not to be confused with the queries in the Query Database window. These queries are saved and stored outside of the database, in the “queries.txt” file that is located in the application folder, and are editable.

Release History

V1.02- 2/25/2006 - Update Checker, Donate Button, Bug Fixes
V1.01-10/31/2005 - 5 Bug fixes
V1.0 -10/30/2005 - Initial Version released.