Help Me! It is urgent please. vb Code for Table Create field types

visual basic , msaccess , table create India
  • 8 years ago
    Hi All, I am using the following code to create a table in Microsoft Access (.mdb) : Conn.Execute "CREATE TABLE Sale_010309 (SALE_ID Char(8), Sale_AMT Long)" In this code, I need to create a field of type boolean. But if I use the following code, the system does not accept it. Conn.Execute "CREATE TABLE Sale_010309 (SALE_ID Char(8), Sale_AMT Long, Sale_Paid Boolean)" Please let me know the actual code to create a logical field in the table using above code. It is urgent please.

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Computer Science is no more about computers than astronomy is about telescopes.” - E. W. Dijkstra