i'm using ms access as my frontend and mysql server as a backend. how can i call a script from mysql using ms access? what are the needed objects/format/syntax in dealing with this problem....

Can you describe what you mean by "call a script" in a bit more detail? If you mean how can you execute a SQL command, that's pretty much the same as with any ODBC engine. If you mean that you want a script on the server to run, you'll need telnet or something like it on both the server and the client. If you mean something completely different, can you give us a hint ?!?!

-PatP