I'm trying to audit a database that's stored in Access 2000. First problem is that I have to review it as is. Second problem is that the database throws up error after error, but only on my machine. A coworker opens it without any issues. From what I'm seeing, it appears to be some sort of compatibility issue with the Access 2000 file. I'm on a machine that was set up just 4 months ago, so I wouldn't be surprised if I don't have the same backward compatibility issues as users on older machines with prior versions installed would have.
Here are the issues that are coming up:
1 - the form that loads on open shows plenty of "#error" values, and the vast majority of queries won't load due to problems down the line.
2 - the same form has vba code that tries to bump to an error handler, but the error library can't be found.
3 - in a couple of situations, I've gotten an error that "snapview.ocx" can't be found.
4 - Common functions like Right() and Format() throw up "undefined function" errors (I have the MS Access 12.0 library reference enabled)
Hopefully some of you have experienced this... and found out how to fix it. Any chance this all points to a single problem with a simple solution?
Thanks,
Tyler
Here are the issues that are coming up:
1 - the form that loads on open shows plenty of "#error" values, and the vast majority of queries won't load due to problems down the line.
2 - the same form has vba code that tries to bump to an error handler, but the error library can't be found.
3 - in a couple of situations, I've gotten an error that "snapview.ocx" can't be found.
4 - Common functions like Right() and Format() throw up "undefined function" errors (I have the MS Access 12.0 library reference enabled)
Hopefully some of you have experienced this... and found out how to fix it. Any chance this all points to a single problem with a simple solution?
Thanks,
Tyler
