schuitkds
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
also if it is a split database the front end for each user needs to be pointed to the back end.
ASKER
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.
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.
is it on a public folder? or on your computer?
ASKER
it is on a public shared folder
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.
is your database a split database?
if so the backend needs to be in a public folder.