Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2004-08-04 : 18:09:13
|
| when I tried to compile an access 97 app, the error says it could not find files or libraries. The highlighted functions are like Mid(), or Left(). They are VBA functions. On the references, vba is checked, and I have verified that the vba332.dll is in the local c drive.Also, the object browser can see it. but why cannot access see it?Any Access guru has any idea?Thanks! |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-04 : 19:04:14
|
| Check your references in the VB designer window. Access has a habit of falling over on these functions when there's a missing reference. And it doesn't matter which dll is missing - it always craps itself on these minor functions.There is a handy tool for checking references at runtime - handy for tracking down errors on customer workstations. Do a google for Access Reference Checker and see what comes up. I know there is a KB article on it at microsoft.com |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2004-08-05 : 10:39:07
|
| Thank you Timmy.I fixed it. The error is misleading, and it is tricky to get in code module in design mode because Access always trys compile first.Here is the link I found later.http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html |
|
|
|
|
|
|
acc97 compile error