Re: Suddenly CAN'T DELETE / EDIT Records ???

1. Close Access.

2. In the Windows Explorer (My Computer), open the folder containing your
MDB.
See if there is an LDB file there with the same name.
If so, delete the LDB. (It will be a very small file.)
The LDB contains locking information for the MDB. Normally Access deletes it
on exit, but after a crash you can be left with spurious locking info in
that file.

3. Still in Windows Explorer, right-click the MDB, and make sure the Read
Only box is not checked. Also make sure you have write-access to this
folder. (You may not have if you are not logged in as a local computer
administrator, or if the file is on a network.)

4. Open the database, and repair it:
Tools | Database Utilities | Compact/Repair

5. If that doesn't work, did you do anything with Access security?
Or with replication?

6. Still stuck? Create a new MDB, and import everything from the failed one.
Steps in the first symptom of:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"kev100 via AccessMonster.com" <u16246@uwe> wrote in message
news:63b303793e0e5@xxxxxx
This is driving me CRAZY !

I'm doing some weekend work here.....

Have done some editing on an existing Access App.

Earlier...I had NO PROBLEMS editing / deleteting records......

I've been adding various features....but have NOT changed any edit
settings
Anywhere (that I know of)....everywhere that I know to check in
properties,
etc all have a 'YES" in the fields relating to allowing editing.

But now...it seems as if there is some sort of "MASTER" read-only switch
that
has been turned on somewhere.

I can't edit / delete a field/record from anywhere (not from any of the
queries, forms, tables...nothing)....it justs gives that irritating little
chime and says "read-only" at the bottom when I try.

I can open up a copy of the app Before I started adding various
items....and
edit/deleting still works fine there.

The only thing I can think that it MIGHT be related to is a Custom Menu
that
I created.....but I've since Completely DELETED that and am using the
original defualt one....but still...nothing!

Does anyone where/what I could have possibly changed that would be causing
this?

Thanks very much.


.

Relevant Pages

  • Re: All users must be admins?
    ... As far as my experiance is concerned, an LDB is created eveytime an MDB is ... That folder can be placed ... it is not usual to grant admin permissions to users. ...
    (microsoft.public.access.security)
  • Re: Running an Access macro from a VB.NETprogram
    ... An ldb file is an Access locking file (located in the same folder as your ... If your Access mdb is ... I'm not sure if an ldb would be created against the original file if you use ... My program opens Access to try to do this.. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Keine Berechtigung auf Objekte
    ... Leider ist weder eine "LDB" noch hat der Neustart der Maschine etwas gebracht. ... Gerd Weiss ... dass die MDB nicht irgendwie auf ... Ist ja für Programmierer und Access Spezialisten ...
    (microsoft.public.de.access)
  • Re: Networking unsecure database
    ... >> delete the LDB file if they're the last user to leave the database. ... > (with Full Control permissions) can delete it before compacting. ... > protect against accidental or malicious deletion of the mdb would be to ... > provide RWXD permissions to the folder but RWX permissions to the mdb - ...
    (microsoft.public.access.security)
  • Re: File Already In Use
    ... It sounds as though she might not have the correct permissions on the folder ... opens the MDB, Access can create a locking file (LDB) in the same folder. ... >I have a user who logs into an Access97 database that resides on a Novell ...
    (microsoft.public.access.setupconfig)