Community discussion forum

Need help to create table in access mdb

• • Reply

  8 months ago

  by DinShiva

  Dinesh Kumar Sharma

  Rajasthan, India

  Joined 3 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 was edited on 06/03/2009 11:54:32 Report abuse
• • Reply

  8 months ago

  by satyasahu

  satya narayana sahu

  , India

  Joined 2 years ago
  Boolean is not a valid datatype in MSAccess you have to use yesno instead as follows. conn.execute "CREATE TABLE Sale010309 (SALEID Char(8), SaleAMT Long, SalePaid yesno)"
  Report abuse