Subform

[Alberto]

I have a form with a subform where the user can insert data. The problem is
that in some computers the textbox or list of the subform doesn't appear and
in others (the most) it does and work fine. If the table of the subform has
rows, the controls appear but you only can read data. If you try to change
then, Access says that the recordset is in read only mode.

The version of Access is very old (97) but is the one who has my client.

Thank you very much.

 

[Allen Browne]

The controls in the subform will disappear if two conditions are met:
1) There are no matching records to show, and
2) No new records can be added.

The fact that your database says it is read-only satisfies condition 2.

Suggestions to find out why it is read-only:

1. Locate the file in My Computer. Right-click, and choose Properties.
Is the Read Only box checked?

2. Is there a computer on your network that is opening exclusively?
Tools | Options | Advanced | Default open mode

3. Network permissions. Do all computers have write-access to the server
share where the data file is?

4. Access security. If you used security, do users have write access?

5. Spurious ldb file. Get all users out of Access. If there is still an ldb
file in the folder where the data file resides, delete it. Reboot the
computer if the file cannot be deleted. (This file contains locking
information, and bad locking info left over after a crash can prevent users
editing data.)