MS Access sub forms firing help

[skakermn]

I have inherited a old access 2000 DB for one of our departments, had two users and I am trying to add a third. Standard DB where it opens a form on opening. The two existing user open it up and get blank main form and sub forms. Sub forms contain look-ups to the parent form to get data. The form open command states open blank sub forms.

So why is it when new third users opens DB all the sub queries fire and errors out. I put a break in the open form command and they fire even before it gets to the open form command.

Any help appreciated, wasted to many hours going over every bit of the code.

What am I missing?

 

[EagleKeeper]

Sounds like the third user is not properly configured in advance.

 

[KB]

Is there any code that was inserted to explicitly limit the number of users to 2? Are you opening the DB as an admin in exclusive mode, which would lock out all other users?

 

[Tweak155]

Is the Access program just the front end and the tables are hosted on SQL server or something similar? Could be access rights to the tables.