Access 2000 with SQL server backend 1

[WP]

I have to backend an existing system with SQL server 7.0.

I understand the SP calls as I have done quite a bit of VB6.0 to SQL7.0 but I'm a bit unsure of bound forms. Is it normal practice to attache the tables via an ODBC DSN and then bind the table to the form ? Or shoulld I load a temporary table using a SP recordset ?
Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[DBAchick]

I have had much success linking the table via ODBC. It seems to run faster (maybe just in my environment) and I do not receive all the errors I did when trying to use an ado.recordset.

DBAChick