Creating a table in Access is typically using ADO to perform SQL statements to create a table. What is the field type in Access in the SQL statement? There is an article in MSDN to introduce very detailed:
Http://msdn.microsoft.com/office/understanding/access/codesamples/default.aspx?pull=/library/en-us/dnacc2k/html/acintsql.asp
Here is a SQL statement I wrote, perform success in delphi: Create Table Test Table (Text 255 VARCHAR NOT NULL, Text 20 VARCHAR (20) Not Null, Date Time DateTime, Number 1 Byte, Number 2 Smallint, Number 4 INTEGER, BUR BIT, Auto Number Counter (10, 5) Constraint PK_TVIPLEVEL26 PRIMARY KEY, Decons Numeric, Single Joint Real, Double Precision Float Default 0 Not Null, Remarks MEMO, Currency Currency, OLE Object Image) Inquiry Design in Access In the device, the statement cannot perform default 0; where: Counter (10, 5) indicates that the initial value starts from 10, each increment 5, if not (10, 5), starting from 1, each increment 1; numeric Represents a decimal, you can specify 2 decimal numbers with Numeric (18, 2); more information, please check the connection above.
