Calling Access function from VB.NET

[sbasak]

Can anyone please tell me how to call an Access 2000 DAO Procedure/function from VB.NET front end?

Thanx

[pvbangera]

can u ellaborate pls. i am not getting u. what's the exact purpose??

[sbasak]

I have an Access 2000 database which has some module code (written in DAO). I want to develop a form of that database using VB.NET. I like to call the Access module codes from VB.NET. How can I do that?

Hope it is clear now :-)

[pvbangera]

add a reference of MS DAO 3.6 to ur project.

dim DBEng as New DAO.DBEngine
dim db as DAO.database
dim rs as DAO.recordset
 
db = DBEng.OpenDatabase("c:\Mydb.mdb")
rs = db.OpenRecordset("MyTable", DAO.RecordsetTypeEnum.dbOpenTable)

I hope this helps.

To call a access macro I think u need to add an access object and try the DoCmd method of it.

Regards