We are in the process of upsizing our Access 2000 databases to SQL
Server 7.0.  I was using the DAO object to open the Access Database but
now that the database has been upsized, I know I can't use the Jet
engine.  I have been trying to open the SQL database (*.adp) by means
of the OpenConnection method.  For some reason, the recordsets no
longer seem to want to open using the OpenRecordset method.  I keep
getting an error which states that the Object variable is not set.
What am I doing wrong?  Can someone please show me how to set up the
OpenConnection method so the Recordsets open properly for adding,
updating and deleting?

* Sent from RemarQ http://www.*-*-*.com/ The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!