Runnig a Access Macro in VB without Access on the client's computer

Hi,

  I need to execute an Access macro from my VB program but the client doesn't have Access installed on its computer. So I can't do:
"dim objAccess as new access.application".
 Is there an other way to run a macro or I really have to run it on a computer that has  MS Access?

thanx
FabulousAsked:
Who is Participating?
 
VoodoomanConnect With a Mentor Commented:
You cant run Access Macros modules from VB.

Microsoft say you cant so I guess you cant!

Write the import in VB using a data control setup as a text driver.

You then get a record set you can work with to do an import.


This works but you have to do some work!!

Voodooman!
0
 
calacucciaCommented:
Hi Fabulous,

That will depend on what the Macro is doing. First of all, you'll ahve to store the macro in another place. Secondary, if you have access specific commands in it, it will not work. If you post the important part of the code here, that would help in determining if it can work or not.

Calacuccia
0
 
FabulousAuthor Commented:
Calacuccia:

Here is the macro, I saved it in VB code:
DoCmd.TransferText acImportFixed, "Order Import Specification", "CLIENTS_ORDER", "E:\Consulting\orders.txt", False, ""

This macro is transfering a text file's information (Using specification) into a table (CLIENTS_ORDER).

Can I use this macro on a computer that doesn't have Access installed? If I create a MDE file with my db, will it work?
0
 
FabulousAuthor Commented:
I hoped I could have done something with the macro but... Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.