Discussion:
Automation with DAO
(too old to reply)
dennis
2003-12-17 02:38:59 UTC
Permalink
I want to 'automate' an Access 97 database using DAO (Jet DAO) and I am
having trouble. Has anyone had any success with this?

I am importing the DAO_tlb, mentioning it in my uses clause, adding comobj
to my uses clause and then I don't know what to use in the createoleobject
procedure for a clsid string. (Usually it is easy like 'application.access'
, etc).

Can anyone point me in the right direction?

Thanks,

Dennis
Mike Shkolnik
2003-12-17 10:42:54 UTC
Permalink
I use the DAO automation
See small sample:
**********************************************
Delphi tip#111: create table in MS Access with DAO
http://www.scalabium.com/faq/dct0111.htm
**********************************************

PS: CreateOLEObject doesn't require imported type library
--
With best regards, Mike Shkolnik
EMail: ***@scalabium.com
http://www.scalabium.com
Post by dennis
I want to 'automate' an Access 97 database using DAO (Jet DAO) and I am
having trouble. Has anyone had any success with this?
I am importing the DAO_tlb, mentioning it in my uses clause, adding comobj
to my uses clause and then I don't know what to use in the createoleobject
procedure for a clsid string. (Usually it is easy like
'application.access'
Post by dennis
, etc).
Can anyone point me in the right direction?
Thanks,
Dennis
dennis
2003-12-17 21:48:55 UTC
Permalink
Thanks, Mike - you guys are great!

I don't quite fully understand the code, but I will figure it out. What I
really needed is the 'CLSID' of 'DAO.DBEngine.35'.
How does a person normally figure this out?
Post by Mike Shkolnik
I use the DAO automation
**********************************************
Delphi tip#111: create table in MS Access with DAO
http://www.scalabium.com/faq/dct0111.htm
**********************************************
PS: CreateOLEObject doesn't require imported type library
--
With best regards, Mike Shkolnik
http://www.scalabium.com
Post by dennis
I want to 'automate' an Access 97 database using DAO (Jet DAO) and I am
having trouble. Has anyone had any success with this?
I am importing the DAO_tlb, mentioning it in my uses clause, adding comobj
to my uses clause and then I don't know what to use in the
createoleobject
Post by Mike Shkolnik
Post by dennis
procedure for a clsid string. (Usually it is easy like
'application.access'
Post by dennis
, etc).
Can anyone point me in the right direction?
Thanks,
Dennis
Loading...