98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » access training london in - Error message
access training london in - Error message
Resolved · Low Priority · Version Standard
Tue 16 Jan 2007, 15:08Delegate Amy said...
Amy has attended:
Access Advanced course
Error message
When I try to add and save new data to a form I get the message:
'the object is locked, any changes you make will be discarded when the form is closed. Click save as on the file menu and save under a different name'.
I've checked the form properties and all the 'Allow' properties are set to yes, data entry to No (as I want the form to display the data from the table as well as have new data entered) and record set type = dynaset, record locks = No.
I've tried different settings but keep getting the message?
Amy
Thu 18 Jan 2007, 10:24Trainer David said...
RE: Error message
Hi Amy
I hope you enjoyed you Access Advanced course.
I think from what you have described it sounds like the actual file, is locked i.e. the file is read only.
To change this you will need to locate the file and right click it. Click the general tab and towards the bottom the are two attribute, one of which is the read only attribute, all you need to do is make sure that the check box is not check.
If this does not help please get back to me.
David
Thu 18 Jan 2007, 11:10Delegate Amy said...
RE: Error message
Hi David,
I've had a look at whether it's read only and it wasn't but thank you for the suggestion.
I now think it might have been something to do with the Name AutoCorrect option, I did a net search and found this article: http://allenbrowne.com/bug-03.html
I opened a new blank database and unchecked the name autocorrect option then imported my tables, form etc into this and the problem seems to have gone, for now at least!
Thanks again
Amy
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Using the Quick Access Toolbar in Access 2010The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |
