Text box not allowing text to be entered

[jbeets]

Hello - I have a database that has been working but recently stopped allowing input into the text boxes on the user form. There have been no updates to the form or database that I have been informed of. The creator of database is no longer with the company and so I have been asked to figure out what is happening. This database has been in use for several years without changes or issues.

The form is linked to a table as the record source and has 3 bound text boxes that require input. The text boxes are Enabled and not Locked. This database does not have any VBA that is filtering records or anything other than a SaveRecord macro and a close form button.

The tables are linked to a back end database which when I go into it give the message "Read Only - This database has been opened read only. You can only change data in linked table. To make design changes, save a copy of the database." I have not come across this is previous databases. Could this be part of the problem?

When the user clicks the Save button they receive a pop up box that says "The command or action 'SaveRecord' isn't available now."



Thank you for any help or advice you can provide!

[ranman256]

is the db locked as read only?
it the source query/table set as dynaset? (snapshot is read only)
is the form set dataentry = true?
is the source query joined to other tables? (can cause read onl)
is the form locked?

you may need to post a sanitized version of your database for us to examine.

[Gicu]

Check the user's permissions in the network folder that contains the back-end file, they need to be Full Control or at least Read/Write.

Cheers,

[Missinglinq]

I agree with Vlad...it sounds as if permission for the folder the Back End resides in is Read Only...not Read/Write! This is probably something that the IT department has inadvertently done...which goes along with nothing having been changed in the database itself.

Linq ;0)>