A2007 - "Delete Record" option greyed out

[Andrew Thorpe]

Using a database written in Access 2000. Simple form with datasheet subform. In the subform, right-click and try to choose "Delete Record", but the option is greyed out. Also the toolbar "Delete Record" button is greyed out. Have checked out the Trusted section and the "Allow Deletions" property. In all other respects, the whole database is running fine in Access 2007. Would appreciate any ideas. Thanks. Andrew.

 

[stopher]

Hi and welcome to the forum.

A couple of steps to try...

Open the subform without opening the main form. Can you delete then?

Next, open the source for the subform (the query or table). Are you able to delete the record from there?

The results of the above will at least tell you if the problem is with the subform or with the underlying data source.

Chris

 

[Andrew Thorpe]

Many thanks for your message and words of welcome. It's good to hear from you.

Yes, I'll try those ideas and it might well help to pinpoint the area of the problem. I wrote the db on my computer in Access 2000 and it's being run on another computer down the road on A07. I will get back there soonest and try out those ideas. I'm concerned about this because it has happened also on a different database on a different computer somewhere else. It is a Db which a lot of people are interested in, and I fear I'm going to have to write it all again in A07 - which means buying another computer and Access 07!!

If by chance you have both versions, you might be able to try running on A07 a db written in 2000, and see if there is any problems deleting from the subform.

Thanks again for your message - much appreciated. Andrew

Hi and welcome to the forum.

A couple of steps to try...

Open the subform without opening the main form. Can you delete then?

Next, open the source for the subform (the query or table). Are you able to delete the record from there?

The results of the above will at least tell you if the problem is with the subform or with the underlying data source.

Chris

 

[TastyWheat]

Has anyone solved this problem? I'm having the same problem with an AC2007 database. I created a brand new form using the Form Wizard and it still didn't work. I believe records could be deleted in form view though (using the record selector and cut).

 

[missinglinq]

Things to consider:

Is AllowDeletions Property for the form set to No?

If based on a Query, can you open the Query independently and delete a record?

Many Queries are Read-Only. Read Allen Browne's article to see the particulars as well as some workarounds.

http://allenbrowne.com/ser-61.html

If the effected form is being used as a subform, check the above things for the main form. The main form's state, vis a vis edits, additions and deletions, is reflected n the subforms because subforms are actually controls of the main form.

 

[TastyWheat]

I did a search around the internet and found the solution. This is such an oddball thing I'm guessing this is an AC2007 bug.

1. Open Access Options
2. Select Current Database
3. Uncheck "Enable Layout View for this database"

See, that makes no sense.

 

[Andrew Thorpe]

Many thanks for your message; it's great to receive so much help. By good fortune, the details of my problem - via a well placed source - reached the Microsoft development team. The answer was that "this is a known fault.......... but will not be fixed in the next Service Pack". I can't help wondering therefore just how long they have known about it. Unlike some bugs, this one is fairly visible. Anyway, in the meantime, I figured out that you can delete the record by simply hitting the Delete key on the keyboard. Not so neat, but it works! Thanks again for your support. All the best, Andrew.

 

[nicolasbeaubien]

I did a search around the internet and found the solution. This is such an oddball thing I'm guessing this is an AC2007 bug.

1. Open Access Options
2. Select Current Database
3. Uncheck "Enable Layout View for this database"

See, that makes no sense.

Resolved my problem! Thank you.

 

[Andrew Thorpe]

Fantastic! That works a treat. Many thanks. Andrew