Call Access application with VB

[KB]

i've created an application in Access; i want to call this with VB; how will write a calling program in VB for this
appreciate help from somebody
thanks

[opiate]

You can use the Access library. Just add it to your references. Also, you can use the Help in Access to find what you want to do. Just look for the Help section for VB.

You may want to describe what you are wanting to call your application for?


Cheers!

[KB]

thanks
but i would have an icon on the desktop [an exe created in vb] so that user can click on it and access the ACCESS application
hope my intention is clear
appreciate ur opinion about it
thanks

[Daemon]

if I was you id used ADO,

for help and examples try
www.planet-source-code (http://www.planet-source-code)
and www.vbcode.com (http://www.vbcode.com)

[opiate]

Originally posted by KB:
<STRONG>thanks
but i would have an icon on the desktop [an exe created in vb] so that user can click on it and access the ACCESS application
hope my intention is clear
appreciate ur opinion about it
thanks</STRONG>

So, you want your Access application to be an executable file unlike the mdb format?

You can connect to a Access database thru ODBC. Most programming languages will allow you to programmically use an ODBC connection. VB, C++, Java.... I'm still not fully understanding what you are wanting to do.

[KB]

not an executable file; i understand in vb we can call an application object sort of thing;
so i just wanted to use vb to call my access application by writing some codes in that line; hope i made it clear
thanks

[pHattmAtt]

hi,

If I understand correctly this may help you:

Shell Execute (http://www.vb-world.net/misc/shellexecute/)

If you goto www.vbworld.net (http://www.vbworld.net) by the link above it will take you to an example of how to open a file with it's default program.

In your case the *.mdb file would be opened by access.

Hope this helps.

[KB]

thanks; i understood how to do it!
how to create menus with macros in MsAccess?
can u help me?