SQL Linked Table Problem- Access 2003

Hi all,

I set up three tables (pastoral, referral, confidential) all at the exact same time on our sql server, all have the exact same permissions and i am the owner of all three. Ecah have a primary key in the form of an autonumber.

When i link to these tables in access i can delete from both the pastoral and confidential tables but cant delete from the referral table (the smallest of the three with only 6 fields) and i get this message:

"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time"

Ive tried:

Compacting and repairing
Recreating the table on the sql server
decompiling and recompiling with a compact and repair
redoing the table links
trying the table in a different database

and none of these things have solved my issue.

Its bizarre:

on the sql server i can add, edit, delete
in access i can add but cant edit or delete as i get a write conflict error message:

"This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made...."

Yet the overwrite option is greyed out and i only have the choice of copying to clipboard or dropping changes.

HELP!!!

im at a total loss as to what is going on, ive tried all the fixes i know and have come back to trying to fix the problem instead of starting it again due to the fact that recreating the table gives me the same problems.

Any ideas? all service packs are up to date and so is the jet engine...

cheers

greg







The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time