Using Microsoft Access 2000 from Delphi to run a module

[newora]

Hi There,

I wonder if someone could please help me with a query that I have with using Dephi ( I think it is version 3 or above) to connect up to an Access 2000 database and run a module within in.

I have developed a routine in VB .NET that just references the Access 2000 type library (MSACC9.OLB) and then allows me to call the Access 2000 docmd method to execute the module.

A company I am working with are using Dephi and they also want to call the same module in Access 2000. It is years since I used Delphi (version 2!!) but I seem to remember reading somewhere once that in Delphi 3 and above you can import a type library and then access all of the methods and properties that the type library exposes to you.

Thus could someone please tell me if this is correct - also is it possible to maybe use late binding and create an instance of 'access.application', in which case I would not have to use the type library (I think).

Thanks in Advance, for any help / assistance.

 

[Oppenhiemer]

Hi newora -

I use Delphi 7, which offers Microsoft Access integration (via server components.) When you install, you have the options of installing components for Access 97 or Access 2000.

I think there is the facility (though I have never tried it) to execute VB code using these components (the Access Application component has a Run method to execute code I think).

Not sure what the options are now for ealier versions of Delphi (its been a while.)

Can you not re-write the code in question using Delphi; and perform the same operations using ADO to connect to the Database itself ?

Opp.

 

[newora]

Hi There - thanks for the reply - yes I suppose that I could develop the code in question using Delphi - it's been a while since I have done any develop work in Delphi, but that might be the way to go then. Will do some more investigation wokk when I know exactly which version of Delphi the third party is using.

Thanks again