Updating a Microsoft Access database

[r_challenor]

Hello,

I am trying to update a Microsoft Access database through Progress 9.1 but I keep getting the following error message:

The Automation server for Access.Application.8 is not registered properly.

This only occurs when the update is attempted using Windows 2000 and Microsoft Access 2000.

The coding I am using is as follows

def var hAccess as com-handle no-undo.
def input param pch_database as c no-undo.
def input param pch_table as c no-undo.
def input param pch_file as c no-undo.

create "Access.Application.8" hAccess connect to pch_database.

hAccess:Application:docmd:TransferText(0,,pch_table,pch_file,true,).

release object hAccess.

Any suggestions?

Thanks,

Richard

 

[Cabral]

Hello,

You can see at the Protools - Com Object Viewer, all functions of Microsoft Products, Open .OLB File of MS Access.

I have many samples with Progress 91b / MS Excel.

If you need send a mail.

Regards,

Cabral.
jobs@foreach.com.br
www.foreach.com.br