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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.