ENVIRONMENT:
Windows XP professional SP1
MS Access 2000
Access 2000 database.
As far as I can see, there is no Workgroup Aministrated security setup for this database. (I may be wrong, but EU does not need to login when Access is launched)
DATABASE:
Master table (1)
Frontend (1)
Both on a share drive in different folders.
One user is getting NO DATA but no error message.
She opens the database and uses a menu to get to a Form.
The form has several tabs with subforms. Then the User uses the control buttons to find a record, (those assigned to her) by a NAME field, then clicks on a tab to reveal a subform, the records are shown in datasheet format.
Some columns are linked to other tables as Combo boxes.
PROBLEM: When she hits the dropdown on a column, it is empty. The field headers show, but that is it, NO DATA. Remember, she chose this record based on the name on the NAME field.
When she chooses a record NOT ASSIGNED to her and goes to the same place, the dropdown will show all the data and lets her choose a value.
User goes to another PC and does the same thing. This time there is no problem.
She is logging in with Local admin rights on both PCs.
Another Access tech looked at it and said there are internal MS Access rights preventing her from opening up that table on net, but it is weird that she can open up records that are for other users, just not hers.
She has all filters turned OFF.
Where can I start to check?
