Using vb6 with ms access

[tonyo]

We are novices with vb6. We are building a project using vb6 as the front end and using ms access as the data base.

How do we use the macros that are built in access to run the vb6 program?

[lychew]

Why do you need to run the macro to execute your vb application?? Why don't you just use ADO in your vb application to access the database?? This is a more extensible solution.

[JHausmann]

There are things available in Access that are not available in VB, and vice versa. That being said, lychew is correct in pointing out that you should review your design. Tell us what you're trying to do and maybe we can offer a better way (well, different, anyway) of doing it.

[Vit]

Create a module in database file that contains function that runs a macro from within the mdb file. Then open MS Access as OLE Object and call to that function