Runing Query in another user

[izen]

I have developed the database in Admin account
When I went to present my database in another user (same computer)
Some queries that calculate the cost dont work
It shoe ###Error the same database I reopened in the Admin account It works
I attached the pic of my design view query Need you guys to help me find out what happened there. (the last field of query has got the problem that I have said {Ingredient Cost: Format([QuantityConvertion]*[Unit Cost],"$" & "0.0000"}

thank you guys

 

[ajetrumpet]

my first thought here is that you have VISTA. Second thought on this is that accounts have different desktops and folders. Are you sure you are opening the same file? Not different ones, that have been saved at different times after making changes and correcting errors to older versions or backups? are you on a network? if so, it shouldn't matter. if you are NOT on a network, what i mentioned above could be a problem.

 

[izen]

Vista !! u mean window operation ? no I dont use vista I use windowXP

I am pretty sure that its exactly the same file

Moreover, when I run on a handy drive, it works (on the Admin user).
the other hand, if i run database on a handy drive in different users (Not admin) it doesnt work.

thanks

 

[Dennisk]

it sound as though you have not granted the correct permissions to the user.

experiment, try giving the user full admin rights and see if that works, if so then the problem is a permissions problem only.