I have front end Access and MySQL back end that I use for my website. I use the access to process much of the data tables and then use the Migration tool kit to convert and upload the tables to my site. It works well, but I would like to do some automation by using a migration script that is executed by a button in my access program. I have already created the migration script based on what the toolkit generates. I have listed below the code I am using to launch the script, but it gives me an error "error executing script:...scripts\transfer.lua...8: attempt to index global 'migration' <a nil value>



Code:
Function OpenGRTShell() As Boolean

        Dim stAppName As String

        stAppName = "c:\Program Files\MySQL\MySQL Tools for 5.0\grtsh.exe \r c:\Inetpub\wwwroot\SSFHL2008\Scripts\scrStatTransfer.lua"
        Call Shell(stAppName)

    End Function