Persistent Connection to SQL tables

[cvegas]

We have been using a Access 2K for our application on a LAN. We want to
convert from using the tables in the mdb file to tables on a sql server.

Is there code, that anyone can recommed, that will automatically log the
user into the sql server and keep a persistent connection.

Thanks in advance for any direction you may be able to give me.

 

[Pieter Wijnen]

My method is to create a passthrough query & open a recordset against it in
the same way you'd do with a Jet BE

Pieter