Thanks Scott, that worked fine for me._____________________ Ok, this is a little reverse really. You want to setup the connection first, and make sure it is connected before you set it in the ADOTable, and open the table afterwards, so something more like:
ADOConnection1.ConnectionString := 'Blah'; ADOConnection1.Connected := True; ADOTable1.Connection := ADOConnection1; ADOTable1.Active := True; However, on making the table active it will try to make the underlying Connection Connected anyway, so you might not necessarily need that Connected line, but I prefer to have it myself. :) ------------------------------ _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db