Break point in Access 2000

[Mark Collins]

I'm having trouble setting a break point in Access 2000,
all the code will compile and I know it is a problem with
the references somewhere. The system was originally
converted from Access 97. This is really annoying please
help ?

 

[Wayne Morgan]

One of the most common problems with a conversion from 97 to 2000 or newer is DAO vs. ADO.
In a code window (Alt+F11) go to Tools|References. Check the version of your DAO
reference, it should be 3.6. If not, uncheck the one that is checked and scroll down the
list to check the one for v3.6.

Next, you need to explicitly DIM you DAO objects. For example, change "Dim rst As
Recordset" to "Dim rst As DAO.Recordset". You should be able to do this with the Replace
function (Ctrl+H) and get them all at once. For the Find What line use "As Recordset" and
in the Replace With line use "As DAO.Recordset" (without the quotes). You will need to do
this for your other DAO objects as well (i.e. Database, QueryDef, etc).