I Have written a Code using ADO Recordset which is Linked to a Access 2000
Table.I create a Create Table Query as follows
QuestionNumber INTEGER CONSTRAINT QuestionNumber PRIMARY KEY,Question
TEXT(50), Opt1 TEXT,Opt2 TEXT,Opt3 TEXT,Opt4 TEXT,Marks BYTE,Correct INTEGER
The Query Executes correctly, the tables are Created but the DataTypes for
Opt1,Opt2,Opt3 and Opt4 are shown as 'Memo' type.What could be the Problem?