Check Box Error

[cheryl]

I have an Access form for entering a new order. There are 4 options for the
turnaround of the order. This is a form we have been using for at least 4
years without problems. The user selects one of the turnaround options using
the check box options. Yesterday, mysteriously, when the user opens the form,
ALL 4 check boxes are checked and the user cannot uncheck the box. We have 10
users of this Access application but only 2 users are experiencing this
problem. We tried to load new versions of the applications for the 2 users,
loading older versions of the application for the 2 users - but the problem
still exists for them. We also tried to uninstall and reinstall Office
completely on the systems but the problem still exists. Does anyone have any
ideas why this would suddenly happen in this form but only for a select group
of users of the application?

Thank you.

 

[Ken Snell \(MVP\)]

Make sure that those two users have full read/write/create/delete privileges
for the folder where the ACCESS database (or the backend database, if you're
using a split database, which you should be because you have multiple
users!) is located.

 

[cheryl]

Installing this hotfix fixes the problem.

http://support.microsoft.com/kb/945674

 

[Ken Snell \(MVP\)]

I assume that you are linking to an SQL Server table?