|
Home > Archive > MS Access data conversion > December 2005 > Split Database-HELP!!-1 form opens up blank
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Split Database-HELP!!-1 form opens up blank
|
|
| tiskal 2005-10-27, 8:31 am |
| I'm in the test stages of splitting an Access97 database (multi-user,
multi-facility environment) so that the front end can be opened with Access97
or Access2003 software. All queries, forms, etc. work fine after making the
split except for one New Record entry form that has a sub-form tied to it
(for automatically adding new customer names). The form opens fine when I log
in as the administrator but it opens as a blank screen when I log in as a
User in a group with more limited rights. Still, if I right click on the
blank form I can click on a sort button that comes up and the forms opens in
sort mode!
I've checked all my form properties; Allow additions, edits, deletions &
filters all = Yes; its source is the correct 'Customers' table; Recordset
Type = Dynaset; and Record Locks = No locks. The sub-form also opens up with
a blank screen when I don't log in as administrator. The subject group has
open/run rights to both forms.
Any insight on resolving this issue will be greatly appreciated! This is my
3rd posting on this. Thanks,
--
Tim
--
Tim
| |
| Joan Wild 2005-10-27, 8:31 am |
| The users also need appropriate permission on the recordsource for the form
i.e. the Customers table.
--
Joan Wild
Microsoft Access MVP
tiskal wrote:
> I'm in the test stages of splitting an Access97 database (multi-user,
> multi-facility environment) so that the front end can be opened with
> Access97 or Access2003 software. All queries, forms, etc. work fine
> after making the split except for one New Record entry form that has
> a sub-form tied to it (for automatically adding new customer names).
> The form opens fine when I log in as the administrator but it opens
> as a blank screen when I log in as a User in a group with more
> limited rights. Still, if I right click on the blank form I can click
> on a sort button that comes up and the forms opens in sort mode!
> I've checked all my form properties; Allow additions, edits,
> deletions & filters all = Yes; its source is the correct 'Customers'
> table; Recordset Type = Dynaset; and Record Locks = No locks. The
> sub-form also opens up with a blank screen when I don't log in as
> administrator. The subject group has open/run rights to both forms.
>
> Any insight on resolving this issue will be greatly appreciated! This
> is my 3rd posting on this. Thanks,
> --
> Tim
> --
> Tim
| |
| tiskal 2005-10-27, 8:31 am |
| HI Joan,
I updated the permissions on both the "Main Data" Table and the "Customers"
table and it solved the problem.
Thanks so much!
--
Tim
"Joan Wild" wrote:
> The users also need appropriate permission on the recordsource for the form
> i.e. the Customers table.
>
> --
> Joan Wild
> Microsoft Access MVP
>
> tiskal wrote:
>
>
>
| |
|
| g
"tiskal" <tiskal@discussions.microsoft.com> 写入消息新闻:D7C3BD6
E-D652-4296-8900- F943CBA56A74@microso
ft.com...
> I'm in the test stages of splitting an Access97 database (multi-user,
> multi-facility environment) so that the front end can be opened with
> Access97
> or Access2003 software. All queries, forms, etc. work fine after making
> the
> split except for one New Record entry form that has a sub-form tied to it
> (for automatically adding new customer names). The form opens fine when I
> log
> in as the administrator but it opens as a blank screen when I log in as a
> User in a group with more limited rights. Still, if I right click on the
> blank form I can click on a sort button that comes up and the forms opens
> in
> sort mode!
> I've checked all my form properties; Allow additions, edits, deletions &
> filters all = Yes; its source is the correct 'Customers' table; Recordset
> Type = Dynaset; and Record Locks = No locks. The sub-form also opens up
> with
> a blank screen when I don't log in as administrator. The subject group has
> open/run rights to both forms.
>
> Any insight on resolving this issue will be greatly appreciated! This is
> my
> 3rd posting on this. Thanks,
> --
> Tim
> --
> Tim
|
|
|
|
|