When using ESS it's always best to develop on the same platform as production so that you don't have any issues like this.
Are your DSNs named exactly the same on your machine and production?
Yes DSNs name is exactly the same. The file opens and runs perfectly without any ODBC prompts it's just the specify table dialogue that has me concerned.
- test on another Windows environment.
- try an alternate mySql source. ( which I doubt is the issue.)