MS Access Error Code 2104 issue

[a80420]

Hi,

I have a form, which has a button.
The button, when pressed, displays a query within the form.
Fairly straight forward, nothing too complicated.

However... here's where it gets funky.
A few of us we would logon to the Access database, we'll press that button... and the query will display... that's great, cuz it's what we want.

But certain other users would try and do the same thing, but it will return a 2104 Error code.

Where I am, we use an MDW file for security... however, every user that is dealing with this issue all have the same security level. So we're fairly certain that it's not a permissions issue.

I know i'm kinda vague in explaining this so far, but does anyone have the sightest clue as to why this is happening?

thanks,

 

[CaptainD]

By "query Will display" do you mean the result set of data the query gets shows up in the form?

If you're working with an *.mdb file, on one of the machines that is giving you the error, try stepping through your code on that machine under the login for the person having the problem.

Otherwise, post your connection and retrieval code.