I am attempting to create tables dynamical out of a VB program running SQL. The problem I am having I keep getting a SQL syntax error for my numeric columns. The syntax I have been using is “field_1 number(6,0), field_2 number(18,2), field_3 number (5,4)”.
I know “field_1 number” works but I need to specific several fields with different decimal precision. What is the correct format to use in ACCESS.
