Connecting to an Access Database

L

labedz

New Member
We have a new project coming up that requires us to READ data from an Access Database and then overwrite the same data in the Progress Database, as well as READ data from the Progress Database and overwrite the data in the Access Database.

Our client uses Access to keep track and update their product information.

We would like to be able to allow them to upload their .mdb file, and update the Progress Database.

Any ideas on how to use both databases? ODBC, VB?

Thanks
 
It sounds like an application for a DataServer, but I don't know if the ODBC DataServer supports Access.
 
Hi

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
 
You must log in or register to reply here.
Back
Top