error 2950 in macro

[nawaray]

hi ..
i have this microsoft application thatworks fine on my pc ( i am the administrator), but wheni take this application to another pc i get this error
i did set this user on the other pc to anadministrator but i still get the error , but when i log on this pc to my username it works...
when i click on stop all macros i get
you can't open the "........mdb".It is already used by another user or you don't have the permission to open it.
but as i said i gave the other user a permission to be an administrator...


i don't know exactly where is the problem

ny suggestions please?

 

[HiTechCoach]

What version of Access are you using?

I have never had to set a user permissions as administrator on the workstation to get an Access database to work. In fact, you shousl avoid ever logging on as an administrator ecpect when neccecary.

My thought is that it is an Access security issue. Are you allowing all the VBA/macros to run when you open the database?

 

[nawaray]

i'm using access 2003
yes i am allowing macros to run

 

[HiTechCoach]

i'm using access 2003
yes i am allowing macros to run

Also check to make sure the you do not have any MISSING references. This can cause all the VBA to stop working.

* Open any code module, then select Tools | References from the menu bar. Examine all of the selected references.
* If any of the selected references have "MISSING:" in front of them, unselect them, and back out of the dialog. If you really need the reference(s) you just unselected (you can tell by doing a Compile All Modules), go back in and reselect them.
* If none have "MISSING:", select an additional reference at random, back out of the dialog, then go back in and unselect the reference you just added. If that doesn't solve the problem, try to unselect as many of the selected references as you can (Access may not let you unselect them all), back out of the dialog, then go back in and reselect the references you just unselected. (NOTE: write down what the references are before you delete them, because they'll be in a different order when you go back in)
* Just so you know: the problem will occur even if the library that contains the specific function that's failing doesn't have a problem.

 

[nawaray]

i checked i don't have anything missing in the references

 

[restymorales]

Hi, guys! I'm having the same problem with error 2950.

I'm using Access 2007 and I want to run a simple macro that would stamp the value of a Labor Fee field. It used to work before, but now it's dead giving me an error. The Table fields are as follows:

grosswt
tare
netwt - this field is set by a macro successfully
labor - this field is where the error occurs

the macro for NET WEIGHT (this works fine):
item: [netwt]
expression: [nz([grosswt]-[tare])

the macro for LABOR FEE (this one stops giving me error 2950):
item: [labor]
expression: [netwt] x 0.06

I've done the security center things, but still getting the same error.

Please help!

 

[dgodin]

I had an issue with a macro running in a report ON FORMAT event. (access 07) I removed the macro and replaced it with equivalent code in VBA as an event procedure. It worked. I understand the issue has to do with security and "sandbox" mode. According to the microsoft help, the only permanent fix is to change the registry.