The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access training london in - Error message

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

access training london in - Error message

Resolved · Low Priority · Version Standard

ReplyTue 16 Jan 2007, 15:08Delegate Amy said...

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

For upcoming training course dates see: Pricing & availability

ReplyThu 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

ReplyThu 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

Access articles

· Cheating With Access Templates
· Get More Out of MS Access Courses
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Access Database Optimization: First Normal Form
· Don't Do It By The Book, Access Your Important Contacts In An Easy To Use Database

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

How would i link my information form worksheet to worksheet and formulate it to work together in calucation

» Forum post: Multiple work sheets

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions