Oracle Forms connection to MSACCESS

Hi,

 In This Post we would Look into how to Connect Oracle Forms to MSACESS and combining the feature of Oracle forms and MSACCESS.

Steps

1. Create a MDB file with a username and password

     I think everyone knbows to open access and create an MDB file.

2. Run the following scripts

     \Forms_home\OCA60\SQL\ACCESS  --> *ACCDMBLD.SQL* (Used to create EMP and DEPT table)

       \Forms_home\OCA60\SQL                    --> *DEMODATA.SQL* (Insert demo data into the tables)

3. Create a ODBC data source in the data sources management tab in windows

    1. Open the Data source managment tab

        Control Panel --> Administrative tools ---> Data Sources (ODBC) 

        

     

    2.  Click the Add button,*Create new datasource* screen opens

       

         

    3. Select Microsoft Access Driver(*.mdb) and click Finish.

     

    4. ODBC Microsoft access screen opens, give a name for the data source

        and click the OK button

            

      

    

    5.  Click  the selet button and select the corresponding MDB file

         and click the OK button

          

    6. The datasource would have been created and check the initial screen

      

        

4. Open the Forms Builder and Connect to MSACCESS     

    In connect field type  username/password@ODBC:DATA_SOURCE_NAME

5. Create a Database Block using the database lock wizard and set the primary property of the EMPNO    column to       'Yes' before running the form.You would be able to do all the insert, update, Delete , Query     Operation from         that form.