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?
schuitkdsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Helen FeddemaConnect With a Mentor Commented:
We might need to see the code.  Is there any security on the database?  Is there code referencing the user name?
0
 
conagramanCommented:
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.
0
 
conagramanCommented:
also if it is a split database the front end for each user needs to be pointed to the back end.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
schuitkdsAuthor Commented:
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.
0
 
conagramanCommented:
is it on a public folder? or on your computer?
0
 
schuitkdsAuthor Commented:
it is on a public shared folder
0
 
rayrod472Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.