Solved

Access 2007 subform not showing for other users

Posted on 2011-02-23
7
259 Views
Last Modified: 2012-05-11
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
Comment
Question by:schuitkds
7 Comments
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 500 total points
ID: 34963174
We might need to see the code.  Is there any security on the database?  Is there code referencing the user name?
0
 
LVL 10

Expert Comment

by:conagraman
ID: 34963183
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
 
LVL 10

Expert Comment

by:conagraman
ID: 34963193
also if it is a split database the front end for each user needs to be pointed to the back end.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:schuitkds
ID: 34963485
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
 
LVL 10

Expert Comment

by:conagraman
ID: 34963553
is it on a public folder? or on your computer?
0
 

Author Comment

by:schuitkds
ID: 34964080
it is on a public shared folder
0
 

Expert Comment

by:rayrod472
ID: 35825373
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question