ODBC Help

vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

Smart Access
The Magazine that Access Developers loved to read and write for is back
Article Index Here or Read More

See 2010 Specials

RSS & Newsletter
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

The Workbench Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile, shutdown database Read and Download

Access >>> SQL
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Toolbox
Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..

SharePoint
For our company file sharing and task management, we use
SharePointHosting

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool. Read More

DryToast
Backup and query your BaseCampŽ projects
Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

Like FMS Products?
Purchase them from us and get a free Workbench or Toolbox More

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
vb123.com.au

ODBC Set Up Explained .. Š GR-FX P/L

These pages show how to configure an Access Database as an ODBC data source using Windows95 32bit ODBC. Use of the data source thus defined is demonstrated by attaching to it in Excel and returning data into a spreadsheet.

Click hereto Test ODBC using Microsoft Excel

Step 1: Locate the Windows95 Start button and click on it.

Step 2: From the Start Menu revealed, choose Settings, and then Control Panel.

Step 3: After clicking on the Control Panel menu, the Control Panel itself will appear. Find the Icon labelled 32bit ODBC, as illustrated

Step 4: Click on the 32bit ODBC Icon, which will produce the Data Sources dialog box. Select the MS Access 7.0 Database (Microsoft Access Driver) item. If this does not appear, you will need to ensure that Access has been installed with full data access options enabled.

Step 5: Once you have highlighted the MS Access 7.0 Database (Microsoft Access Driver) item, press the Add... button. This will reveal the Add Data Source dialog box.

Step 6: Highlight the Microsoft Access Driver(*.MDB) item in the the Add Data Source dialog box. Press the OK button. This will reveal the ODBC Microsoft Access 7.0 Setup dialog box. Fill in the Data Source Name with the name you want to appear in pick lists in the system when you later want to select this data source. This example uses the name "KG1 Data". Describe the data source in the Description field. This example uses the description "Data from the KG1 database". Then press the Select... button in the Database box.

Step 7: This will produce the Select Database Dialog box within which you can use the usual Windows95 browsing techniques to locate the relevant .MDB (Microsoft Access database file) you wish to configure as an ODBC data source. This example uses the kg1_data.mdb database.

Step 8: When you have located your database file, press the OK button. This will return you to the Data Sources dialog box. Step 8: ODBC by GR-FX

Step 9: ODBC by GR-FX

Step 9: If you are using an Access database and use a System.MDW or system.MDA password file, make sure that you JOIN that system file.

Step 10: Press the Close button. At this point you have set up the ODBC data source for your Microsoft Access database (.MDB file). The example that follows shows how you would attach to this database from within Excel ad return data from it to a spreadsheet.

Step 2 Click here for how to check ODBC using Microsoft Excel

Part 2 of ODBC help