Form Opens Blank/Appears as if Filter Applied

  • Thread starter Thread starter joneboy
  • Start date Start date
J

joneboy

Hi,

I have an access app in v2007, deployed via the runtime. I have initially
installed on 2 machines, both running xp with all sp's/updates applied, and
both running office 2003. On one machine, everything works fine, on the other
all forms open correctly bar one. When one particular form opens(it is made
up of a main & continuous forms subform), the form appears blank; only the
field labels appear in the header of the main form. The result is what you
would expect if you applied a form filter which returned no records, the sub
form does not display at all. On the other machine however, the form displays
correctly and the user is able to input data.

Data Entry is not set to true, additions/deletions/edits/filters all set to
true. Once the working machine add a main record, the non working machine can
now see that record, but the subform is not available (as if Filter Empty
Master is set, but it's not).

Both machines look to the same backend data on a file server, and both
frontends are identical, deployed from the same msi package.

I have also tested it on a machine running a full version of 2007, and it
works fine.

Any help/suggestions would be greatly appreciated.

Jon.
 
The symptoms definitely appear to be one where a filter has been applied,
then saved. The reasons it doesn't work don't matter if you can fix it, and
it doesn't keep happening, so I would simply replace the front-end on the
bad machine, with a copy of the front-end from the good machine. Do not
reinstall, or change anything, simply copy the file from the good machine
and replace the bad one.
 
Thanks for the response Arvin. I've tried this, and it doesn't work. Further
investigation has revealed that the DB on the bad machine seems to be in a
read only state (it's not set as read only). Prepopulated tables (library
type info), and their corresponding forms display data, but cannot be edited
or added to.

I've used the P & D wizard to install in the local user app data directory
as I may have vista clients where I believe Program files is readonly.

The local user has admin rights on his machine, and the file is definately
not set as readonly. I moved the entire app directory to his MyDocuments
folder, to which he obviously has full acces, to test the read only issue.
When opened from here the app reports a 'unsafe content' warning, press ok &
it opens but the same symptoms prevail.

The backend DB is on a file server, in a single directory to which all users
have full rights. I am now going to attemt stripping rights & reapplying on
that directory. Will let you know how I get on.

Thanks again,

Jon.
 
Arvin,

Removed share permissions on the server & recreated the share & it now is
working as it should. Thanks again for your reply.
 
joneboy said:
Hi,

I have an access app in v2007, deployed via the runtime. I have initially
installed on 2 machines, both running xp with all sp's/updates applied, and
both running office 2003. On one machine, everything works fine, on the other
all forms open correctly bar one. When one particular form opens(it is made
up of a main & continuous forms subform), the form appears blank; only the
field labels appear in the header of the main form. The result is what you
would expect if you applied a form filter which returned no records, the sub
form does not display at all. On the other machine however, the form displays
correctly and the user is able to input data.

Data Entry is not set to true, additions/deletions/edits/filters all set to
true. Once the working machine add a main record, the non working machine can
now see that record, but the subform is not available (as if Filter Empty
Master is set, but it's not).

Both machines look to the same backend data on a file server, and both
frontends are identical, deployed from the same msi package.

I have also tested it on a machine running a full version of 2007, and it
works fine.

Any help/suggestions would be greatly appreciated.

Jon.
Click to expand...
 
Back
Top