Re: Linking MS Access DB into Oracle

Do u mean to link from access to an Oracle Database then here it is

You can import or link data from ODBC databases such as Microsoft SQL Server, as well as other programs that provide drivers compliant with ODBC Level 1 to access their data files.

Note If you chose the Typical option when you installed Microsoft Access, the SQL Server driver and ODBC support files will not be installed, and you will not be able to import or link from any ODBC machine data source. In this case, rerun Setup to install the SQL Server driver. Additionally, for each ODBC machine data source that you want to use, you must have the appropriate ODBC driver installed on your computer before you can import or link this database. For more information on installing and configuring ODBC drivers, click .

1 Open a database, or switch to the Database window for the open database.
2 To import tables, on the File menu, point to Get External Data, and then click Import.

Show me

To link tables, on the File menu, point to Get External Data, and then click Link Tables.

        Show me

3 In the Import (or Link) dialog box, in the Files Of Type box, select ODBC Databases.
4 In the Select Data Source dialog box, click the Machine Data Source tab to see a list of all ODBC machine data sources currently defined for the ODBC drivers installed on your computer. This list might include drivers that have not been tested and verified for use with Microsoft Access. Contact the driver vendor for verification.

If you want to use a file data source, click the File Data Source tab and enter or browse for a file name. A file data source is useful for sharing ODBC driver connection information between different computers and does not require a Registry entry. For more information on file data sources, click or see the ODBC 3.0 Programmer's Reference Manual.

If you want to define a new data source for any installed driver, click New, double-click the name of the ODBC driver, enter the data source definition (this will vary depending on the requirements of the ODBC driver), and then click OK.

5 In the Select Data Source dialog box, double-click the ODBC machine data source that contains the data you want to import or link. 6 If the ODBC data source that you selected requires you to log on, enter your logon ID and password (additional information might also be required), and then click OK.

Microsoft Access connects to the ODBC data source and displays the list of tables that you can import or link.

7 If you're linking a table, select the Save The Login ID And Password check box if you want to save this information for the table in the current database and not require users to enter this information. If you leave the check box cleared, all users must enter the logon ID and password every time they open the table in each new session with Microsoft Access. Your SQL database administrator can also choose to disable this check box, requiring all users to enter the logon ID and password each time they connect to the SQL database. For information on how to disable the Save The Login ID And Password check box, click .

8 Click each table you want to import or link, and then click OK. If you're linking a table and it doesn't have an index that uniquely identifies each record, Microsoft Access displays a list of the fields in the linked table. Click a field or a combination of fields that will uniquely identify each record, and then click OK.

Notes

· After importing or linking an SQL database table, you can set field properties for the table. If you import a table, you might want to set a primary key for the table. For more information, click . · If you encounter an error while importing, linking, or using an SQL database table, there might be a problem with your account on the SQL database server or with the database itself. If you can't access an SQL database table, contact the SQL database administrator.

· To edit a linked SQL database table, usually the table must contain a unique index on the server. If you want to edit a table that doesn't have a unique index or you want to edit an SQL view, you can create an index within Microsoft Access that the SQL database isn't aware of. You do that by creating a data-definition query, using the Create Index statement. Be aware, however, that the index must be created on a field or combination of fields in which each value is unique. If the field contains any duplicate values, all updates to the table will fail. To delete the index, use another data-definition query. For more information on creating such a data-definition query, click .

· If the structure of an SQL database table changes after you link it, use the Linked Table Manager to refresh the link. For more information, click .

In article <8luo8m$1ia5$2_at_news.okay.net>,   "Mika" <Michael.Kurz_at_c-plan.com> wrote:
> Hello
>
> How can I Link Tables from an MS Access (*.MDB) into an Oracle User.
>
> Or isn't that possible at all ?
>
> Thanx
> Micha
>
>

--
Ender Wiggin


Sent via Deja.com http://www.deja.com/
Before you buy.