有可能是用了name这类的默认名，把 你的SQL语句改成 select * from [表名] 可能就好了
一般是使用了adoquery它的sql没有写对。
把你的adotable属性里面的TableDirect改成True，我也遇到了同样的问题，就是这样搞定的。 关于TableDirect的说明如下：Set TableDirect to specify whether the table is accessed simply via its name or whether a background SQL statement is used. Not all providers support accessing a table by its name and require that this access be done with a SELECT statement. If TableDirect is true the data retrieval request uses a background SQL statement and all columns are simply returned. If it is false, the TADOTable component creates a SELECT statement to retrieve the table's data. The default value of TableDirect is false.我想是不是它自己创建的select语句有些不兼容造成的。（我也是菜鸟一个，^_^）
比如open了ADOQuery 而ADOQuery的SQLScript有错
你的SQL语句改成
select * from [表名]
可能就好了
关于TableDirect的说明如下：Set TableDirect to specify whether the table is accessed simply via its name or whether a background SQL statement is used. Not all providers support accessing a table by its name and require that this access be done with a SELECT statement. If TableDirect is true the data retrieval request uses a background SQL statement and all columns are simply returned. If it is false, the TADOTable component creates a SELECT statement to retrieve the table's data. The default value of TableDirect is false.我想是不是它自己创建的select语句有些不兼容造成的。（我也是菜鸟一个，^_^）
User ID=sa;PWD=''