Solved

Access 2007 subform not showing for other users

Posted on 2011-02-23
7
239 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
Comment Utility
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
Comment Utility
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
Comment Utility
also if it is a split database the front end for each user needs to be pointed to the back end.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:schuitkds
Comment Utility
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
Comment Utility
is it on a public folder? or on your computer?
0
 

Author Comment

by:schuitkds
Comment Utility
it is on a public shared folder
0
 

Expert Comment

by:rayrod472
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

763 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now