Create a Read-Only Database Connection (MS Excel)

Note: This process will create a Read-only data source connection via Microsoft Query in MS Excel to gain access and query data from the FlexiBake Database.

1. Open the Microsoft Query wizard.
   
            
2. Create a new data source. 
   
                     
3. Give the data source a name.
4. Select the Microsoft Access Driver (*.mdb) from the drop down..
5. Select the Connect button
     
                  
6. Click on the Select button.
   
                      
7. Browse to your FlexiBake database and select it, then select the OK button.
                                                                                                     
8. Select the Advanced... button.
                                                                              
9. Fill in both the Login name and Password with FBROUser
                                                                                                  
10.  Select the System Database button.
                                                                            
11. Browse to the C:\program files\flexibake2 folder and select the FlexiBake.MDW file. 
                                                                                                                  
12. Click OK to all windows to get back to the New Data Source window.
13. Select the Save my User ID… checkbox.
                                                                                                         
14. Select OK to the pop up warning.

Please Note: FlexiBake support can assist with the creation of the read only connection, anything beyond that is out of scope of support and assistance will not be provided. This includes and is not limited to writing SQL queries, describing table, relationship and data structures, third party query applications and programming languages.