Creating Access Tables from VB - TechRepublic
General discussion
July 5, 2001 at 06:16 AM
jkra

Creating Access Tables from VB

by jkra . Updated 24 years, 9 months ago

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.

This discussion is locked

All Comments