Hi!
Try to make a table with one record and one dummy field, then use query like "SELECT MakeNewHeader() From Dummy"
I do not know if this will work in MS Access, just a suggestion.
>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?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.