Link to home
Start Free TrialLog in
Avatar of schuitkds
schuitkds

asked on

Access 2007 subform not showing for other users

Hello
I have developed a form in Access 2007 that has a subform to display records for the client selected in the main form
it works fine for me, but the subform does not display data for anybody else using the access form.
Any Ideas?
ASKER CERTIFIED SOLUTION
Avatar of Helen Feddema
Helen Feddema
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
this makes me wonder where your data is.  
is your database a split database?
if so the backend needs to be in a public folder.
also if it is a split database the front end for each user needs to be pointed to the back end.
Avatar of schuitkds
schuitkds

ASKER

this is a test system at this point and the database is not split
seems to be maybe a security issue but can not determine where this would be
As i stated I created this and it works for me but another user sees the main form but no records in the subform.
is it on a public folder? or on your computer?
it is on a public shared folder
If your database is using vb/macros and you've accepted the database to be in a trusted location on your PC, other users may have the vb code blocked when they run it.  Check macro security in the trust center.