Microsoft Access

[gasomma]

Hello,

it's possibile to connect Access DBF table to OE (v. 9.1d and v 10.2b)?

Many Thanks.

JCA

 

[mrobles]

Hi again

1.- In control panel -> Administrative tools -> Data sources(ODBC)
create a new Data Source Name (DSN)
select Microsoft Access Driver.
give it a name (suposse abc) and select the physical access database

2.- Create a progress database (to be used as schema holder)
Connect to this progress database.

3.- In progress select
Tools -> Data administration -> Dataserver -> ODBC Utilities -> Create database schema
In Logical database name give it a name (suposse abc)
In the ODBC Data Source Name field put the DSN name (suposse abc)

4.- Put userid and password (of the access database) or blanks and OK

5.- In Preselection I use the defaults

6.- Select the access tables you want to see

7.- You are connected !!!

If you change the structure in access then you must update the schema holder in progress
Tools -> Data administration -> Dataserver -> ODBC Utilities -> update/add tables

Mario Robles

 

[gasomma]

Hello Mario,

thanky for your help.

JCA