calling stored procedure from MS access

[neerajarora]

Can anybody help me in calling a function written in
MS access backend through Visual Basic.If u can think
of some other method exept OLE that will be helpful.
I am also looking to know i can u call access macros
from visual basic.

 

[Psychpt]

it's alot more efficient to just copy the function to your vb and run it from there.

 

[scking]

You could build a dll in Visual Basic which contains the Access functions. Just realize you may have some modifications necessary to make the code work.

Don't even consider calling Access macros from Visual Basic. First, macros suffer from the fatal problem of not being able to trap errors and handle them. Then you are very limited in the commands you can use. There is a wizard that will translate macros to vba. You could do this and then include the code in the dll.

Steve King

 

[ninfan]

Did you get an answer to your stored procedure question? I have some info if you still need it.