ADO Access 2003 -> SQL Server

[stanl]

for ADO I generally use

cn.Open ="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=user;Password=password;Initial Catalog=database;Data Source=dbsource"

and I find it more efficient to use a server cursor. .02 Stan