• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MS Access sub forms firing help

S

skakermn

Junior Member
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?
 
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?
 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top