I?ve just used the upsizing tool of access 2000 to upsize my database from 
access to SQL server 7.0. I now have an access project with a back-end sql 
database.

My database has now stopped working I?m getting errors on the following 
code

Run Time error ?91?
Object variable or with block variable not set

This error occurs on the following code:

    Dim dblocal As Database
    Dim recCompanyInfo As Recordset
    Set dblocal = CurrentDb()

    Set recCompanyInfo = dblocal.OpenRecordset("tblCompanyInfo", 
dbOpenDynaset)

 
Can anyone suggest how I get around this.

Regards H

Access projects don't support DAO VBA. You will need to use ADO to
interogate your database. You will need to dim your recordset as
ADODB.recordset. I would suggest searching the web for ADO Access help.