Solved

Access 2007 subform not showing for other users

Posted on 2011-02-23
7
280 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 

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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Suggested Courses

630 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