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

• • Reply

  12 years ago

  by DinShiva

  Dinesh Kumar Sharma

  Rajasthan, India

  Joined 14 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.
  Report abuse