Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Beginner - Brio Explorer - MS Access

Status
Not open for further replies.

kinselas

IS-IT--Management
Aug 4, 2002
60
AU
I am totally new to brio. I would like to connect to an MS ACCESS Database . I no how to run ODBC. Could someone PLEASE tell me how do I connect to my Database on the d:drive. PLEASE HELP
 
Step1 :
Firstly configure the data source@as a system DSN within the opertating system, (Control Panel - Administrative Tools - ODBC Datasource administration)

Step2 :
Start Brio(You are using Brio.Explorer I presume
Start a new document.
Select: A New database connection file / this will bring up the database connection wizard.

USING the wizard ..
For a registered mdb datasource, select ODBC for both connection software and database type.
Click Next

Select the database(You created the name in step 1 within ODBC Datasource administration)
Enter any passwords if required
Click Next

THATS it!
Click Finish ..
It will promt you if you wish to save the oce file.

Happy Querying ..

Once you get into it, I think you will find Brio an excellent tool. ------------------------------
Gary T
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top