Issues Migration Access 97 to Access 2003

[Mone]

Did anyone find this weird issue, You can't break into the code of
reports, even if you write STOP in 2003, other issues I found is for
example some recordset will return recordcount of -1 when there is in
fact some records? anyone with similar issues?

 

[Guest]

Hi Mone,

A break point will be ignored if you have the option "Use Access Special
Keys" unchecked, under Tools > Startup. If you find this option disabled,
re-enable it. Then close Access and re-open the database. Try your break
points now.

How are you attempting to get your recordcount? If you are using something
like this:
?CurrentDb.TableDefs("TableName").Recordcount

you should know that it will always return -1 for linked tables.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________