Open (Execute) Access Database in LotusScript

HCL Domino Domino Forum
1

Hi,

I have MS Access database on the C drive. i want to open the Access database through lotus notes script.

@Command( [Execute] ; “C:/mydatabase.mdb”)

is working fine in formula language, but i need in LotusScript.

Any sample code or clue.

Thanks in advance.

Imtiaz

2

Subject: Open (Execute) Access Database in LotusScript

Did you even look in the help?At the bottom of the page for @command([execute]) you find

Language cross-reference

Shell function of LotusScript language

3

Subject: Open (Execute) Access Database in LotusScript

Dim result As VariantDim PathName As String

Dim FileName As String

PathName$ = “C:\Program Files\Access Folder\xxxxx.exe”

FileName$ = Dir$(PathName$, 0)

If FileName$ <> “” Then

result = Shell (cmtPathName$ , 6 )

Print “The application is starting.”

Sleep 5 'Give the app time to load before continuing

Else

'Something went wrong, stop the execution of this subroutine.

			Msgbox "Application could not be started.  Confirm the install path is C:\Program Files\xxx\"

Exit Sub

End If