>I am going to create a program where a user can create their own tables, but I want to make sure that they don't name their table something that won't work. Is there a list of characters that can't be used in the names of tables? I am not using a database container, so do the tablenames have to be ten characters or less?
>
>Thanks in advance

There's the CleanPath() and ValidPath() functions in Foxtools. From my Extended Foxtools Help file (available for download):

CleanPath()

Returns a corrected a file name where characters, which would be invalid in DOS, duplicate backslashes, spaces, etc., are removed. No guarantee is made that the filename is completely legal or that the file or directory exists. Extra characters beyond the 8 of the primary filename, and 3 of the extension are removed.

ValidPath() checks that a file or path name is syntactically legal. It does not check for the existence of the specified file or path. The function is not 100% accurate and can interpret a file or path as being valid when it is actually invalid. However, it will not reject a valid name. Note that the function will not work correctly with long file names.