Calling SQL Server 2k from Access97 through ADO using sqloledb.1

Views Sorting= No Parameters= Yes Updatable= Yes
Stored Proc Sorting= Yes Parameters= Yes Updatable= No
UDF Scalar Sorting= NA Parameters= Yes Updatable= No
UDF InlineTable Sorting= Yes Parameters= Yes Updatable= Yes
UDF MultiLine Sorting= Yes Parameters= Yes Updatable= No

If I want an updatable ADODB.Recordset in Access I must use either
Views or an InlineTable UDF. If I want the recordset sorted I should
use UDF. If I don't need sorting, calling a view is more efficient.

As you can tell, I am new to Sql Server. Any suggestions on working
with Sql Server 2k from within Access97 or AccessXP?

Thanks,
Brad