trySELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "msys*") AND ((MSysObjects.Type)=1));
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "msys*") AND ((MSysObjects.Type)=1));
他是ACCESS的专家:)
ADOConnection.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.mdb;Persist Security Info=False';
tableList := TStringList.Create ;
ADOConnection.Open();
ADOConnection.GetTableNames( tableList );
MyStringList := TStringList.Create;
try
Session.GetTableNames('c:\test.mdb', '*.mdb',False, False, MyStringList);
{ Add the table names to a list box }
ListBox1.Items = MyStringList;
finally
MyStringList.Free;
end;
mytables:tstringlist;
begin
mytables:=tstringlist.Create ;
adoconnect.GetTableNames(mytables);
if not (mytables.IndexOf(findtablename)=-1) then
showmessage('find');