I am using VFP 6 to call an Access function and can't get it to work. The command object and the connection object get created okay, and I set the commandtype to 4 (also tried to 1 and 8). ActiveConnection is the connection object and CommandText is the function name (tried it with and without trailing parans). After executing the command I get an error message that says it can't find the table or query "MakeNewHeader", which is the function name. In the case of CommandTypes 1&8, the error says it is an invalid SQL statement.

Any sugestions?