access training london in - Error message

Resolved · Low Priority · Version Standard

Tue 16 Jan 2007, 15:08 Delegate 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:24 Trainer 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:10 Delegate 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips