Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

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?
0
schuitkds
Asked:
schuitkds
1 Solution
 
Helen FeddemaCommented:
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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now