Calling an access Macro from a VB.NET application - Very Urgent

[Sen K via .NET 247]

(Type your message here)
Hi,

Any help is appreciated.

I have a situation wherein i need to compact access db after somebusiness logic through VB.NET.I've written a function in VBA tocompact the database and i am calling that function in AccessMacro, and if i run that access macro in the backend, itsworking fine.But when i tried to call that access macro fromVB.NET code,i'm not getting any errors, but that macro is notworking. I'm calling that access macro likeaccess.docmd.runmacro "MACRONAME". How to call an access macroor a VBA function in VB.NET code?.

Thanks in advance.

 

[Cor Ligthert]

Hi Sen,

Did you already look here?

http://support.microsoft.com/default.aspx?scid=kb;en-us;306287

I think when this goes this is much easier.

I hope this helps?

Cor