Fabulous
asked on
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
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
ASKER
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?
Here is the macro, I saved it in VB code:
DoCmd.TransferText acImportFixed, "Order Import Specification", "CLIENTS_ORDER", "E:\Consulting\orders.txt"
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I hoped I could have done something with the macro but... Thank you.
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