I have written an access 2000 application.
In this application i ve used right() function.

On my pc all it' s ok. but when i use this application on another pc, i get an error.

The strange thing is that if i open a new appliation in the second pc with a right function in the VBA code it is recognised.

What is the problem?

I ve registered my veb6.dll n the target pc and nothing happened

Thank you all in advance.

PS: if i don t solve this problem my project will fail and with it my possibility af having a career.

Open any procedure. On the menu, click Tools > References. A dialog box will appear showing you available references. On the computer where the RIGHT() works, see which references are checked. On the computer where it doesn't work, make sure the same references are checked as in the other computer.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Just because an error SEEMS to be related to a particular reference (such as VBA 6) doesn't mean that the actual error is THAT REFERENCE. ALL references must be correct for any of them to work correctly. I've seen this problem many times before. Curiouser and curiouser.

Rand

If there are different versions of ms access installed, this will happen. Even just different service release levels. Serrano is on the right path, you are having problems with a bad reference to a dll, a bad dll being referenced or a corrupt database. Either way it is dll hell.
I have seen this happen with no reason or rime in the past.



Sal

Thank you to all of you who answered.
References are the same.
So what can I do concretly for solving the problem?

Regards

Access should by default find the Utility.mda. As Sal said, sometimes when you have more than one version loaded on a pc, things get a little screwed up. On the pc where this doesn't work, open your references and browse out to create a new reference to the Utility.mda. Save changes and then run. See if this fixes the issue. (I am advising this only as a troubleshooting technique!)

Beth M