Invoking MSAccess Macro using LScript

HCL Domino Domino Forum
1

I want to invoke MS Access Macro using Lotus script, I am trying the following but no luck…

result = Shell(“C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE \server\MIS\eTime\Employee Time.mdb /Excl /X Proc_eTime_Report”, 1)

Any idea what I am missing or doing wrong? It opens Access but is not able to find the database, I’ve also tried using the drive mapping instead of the full path \server\MIS.… but that didn’t help either

thanks,

ash

2

Subject: Invoking MSAccess Macro using LScript

I am not sure what you did wrong, but you could build it up gradualy via a DOS-box. Then you will find out what error is given. Here you could try to issue a dir command for the file with the used syntax.

3

Subject: RE: Invoking MSAccess Macro using LScript

Thank You for your resonse Rob.

I am not sure how would that approach help? Can you please shed some light and perhaps if you have examples.

Thank You,

Ash

4

Subject: RE: Invoking MSAccess Macro using LScript

When you enter a filepath in a DOS-box in the DIR-command, you get an direct response, whether or not it is acceptable. This way you could find out what path to use and what syntax is expected.

5

Subject: RE: Invoking MSAccess Macro using LScript

Thank You Rob

6

Subject: RE: Invoking MSAccess Macro using LScript

I am executing a Batch file to accomplish this, I don’t think I can invoke MS Access database using the Shell command in Lotusscript. I can open MSAccess but can’t open the database and invoke any procedures or macros.

So either it’s using ODBC connection or executing a Batch file using the Shell command.

Thanks for your response and help.

Ash