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?

[Webinar] Streamline your web hosting managementRegister Today

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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work 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
All Courses

From novice to tech pro — start learning today.