Persistent Connection to SQL tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top