Bound controls on subforms won't accept keyboard input

[cstewart75]

I've developed a project in Access 2000 file format using Office XP. On machines running Office XP the project works great. However on machines running Office 2000 bound controls on subforms will not accept input form the keyboard (I know it sound strange but bear with me). When a user tries to enter data via the keyboard into bound contols whether it be a combo box or text box there is no response. If the control happens to be a combo box the user can edit the data by selecting an item from the list but cannot type in the field.

I've installed the fixes (SP-3) for Access 2000 and SQL Server 2000 compatability on the users machines. Users have full read write access to the database.

Please help!!!

Thanks in advance.

 

[cmmrfrds]

When you say it runs on XP, were these different logons that you tried? Are you using NT authentication or sql server authentication for the users. Where you using the database owner logon id on the XP PC's? It could be that the logon id on the Window 2000 PC has select permissions but not update permissions. If you are the database owner, will the Forms work under your logon id? Explain how you have the permissions setup on the database.

 

[cstewart75]

I'm using Windows authentication. The forms work on XP machines under any login and don't work on 2000 machines regardless of the login. I'm setup as the database owner and the other users are db_datawriter and db_datareader. Ordinary users (i.e. db_datawriter/readers) are able to edit the data on XP machines.

 

[cmmrfrds]

When you go into the data tab on the Form/SubForm is the recordset type updateable on both platforms? Is the unique table set?

 

[cstewart75]

I'm afraid so on both counts. The users are able to edit the record as long as they can use the mouse for input (i.e. combo/list boxes or checkboxes) they just can't input data via the keyboard.

 

[cstewart75]

I installed Access XP runtime and that seems to have fixed the problem. Thanks for your time and effort cmmrfrds.