by 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.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!