conversion help

[gbanks]

Convert an 97 db to 2000. I imported everything in the 97 db into a new 2000 db. Everything went well but I got a few errors when i opened a couple of forms. It didn't like these 2lines of code. Any ideas on how to repair this? Thanks...

It falied on Database on this form..

Dim dbs As Database

And dbOpenSnapshot on this form..

Set RS = CurrentDb.OpenRecordset(sql, dbOpenSnapshot)

 

[KevinM]

Make sure DAO 3.6 is ticked in the vb references

 

[Pat Hartman]

I also recommend that you qualify all your DAO objects. It will prevent future problems.

Dim dbs As DAO.Database
Dim qd As DAO.Querydef
Dim td As DAO.Tabledef
Dim rs As DAO.Recordset
etc.

The full list is easy to see. When you type DAO. - it appears as if by magic.

 

[gbanks]

Thank you both. Your were both I big help. I really appreciate it..