In advance, I hope you will forgive my ignorance as I am a novice.
Using Microsoft Access 2007, I have begun creating a database and this database currently has three tables. The Contacts table is the one I'm having an issue with.

I have a user that was able to edit, add, delete, etc. anything he needed to do, as recently as last week. Now when he wants to change anything on the Contacts table he gets the error message "This recordset is not updatable".
He has the ability to change anything he needs to on the other tables within the exact same database. I am able to make any changes I want from my user on my computer or his computer, but not his user on his or my computer.
Is there a security setting I don't know about within each table that might have gotten changed somehow? The database has not been split. It resides on his network drive and he is the only one who currently uses it.

I'm certain this has something to do with his computer completely freaking out earlier. When I was working on his computer earlier (Vista), I double clicked on the database to open it and immediately 10 copies of the database were open and it was flickering all over the place. As I was closing each one down I noticed an error message but was to stupid to write it down. It mentioned something about his computer name and administrator and restricting access. (I know it would make everyone’s job ALOT easier if I had written this down, sorry.) But at the time the computer was also opening his Computer window and reopening it every time I tried to close it. Eventually when I went to restart the computer it shut itself down .

I don't understand how it's locking him out of only one of the tables.
Please help.

Thanks so much in advance for any ideas.
Dave K

First, is the database located in a location that he has full permissions to? Though if that were the problem, he would have the same problem with all other tables, but I don't want to overlook those details.

Another thing may be that it's in a corrupted state. A traditional solution is to create a new blank database, turn off Auto-Correct, then import in all objects from original database. The import process cleans out the crud that may have accumulated and started to interfere with the file's working.

Try either and see how it gets you.

This is a prime example of not using split databases even for single user apps. One thing you have not mentioned which might be relevant. Is the user using a wireless connection or has done in the past. Any nano drops in connection can lead to corruption. Have you tried recreating the mdb or moving it locally to their machine and testing there.

David

Never mind! I figured it out. It was a permissions issue with the folder this Contact table was linked to. Thanks anyway.

Dave K