how do i open a batch file from access

[Stacy Anderson]

I need to run a batch file from Access. Any Ideas?

 

[missinglinq via AccessMonster.com]

Where C:\ is the path to your batch file; modify the path as needed:

Private Sub CallBatchFile_Click()
Shell("C:\YourBatchFileName.bat")
End Sub

 

[Daniel]

Two options comes to mind

1. Application.FollowHyperlink "FullPath\FilenName"

2. Shell "cmd.exe /C ""FullPath\FilenName"""