I have a table linked through ODBC. Each record has a primary key ID; my ODBC refresh interval is set at one second.
Whether in the table itself, or in a form linked to that table...every time I update a record and then move to a different record, every field in the record I just updated turns into "#Deleted".
If I back out and then go back in, the information from the record is still there, but the primary key ID is now different. From trying to figure this out, the primary key IDs in my database are now 13, 20 and 22. Those are the only three records I've ever tried to enter.
This "#Deleted" error is only happening to me. Other users are able to use the database without this happening. I've found some information about the "#Deleted" error online (see http://support.microsoft.com/kb/128809), but nothing that would explain why others would be able to successfully use the database that isn't working for me.
Does anyone have any idea what is going wrong?
Thanks in advance!
Whether in the table itself, or in a form linked to that table...every time I update a record and then move to a different record, every field in the record I just updated turns into "#Deleted".
If I back out and then go back in, the information from the record is still there, but the primary key ID is now different. From trying to figure this out, the primary key IDs in my database are now 13, 20 and 22. Those are the only three records I've ever tried to enter.
This "#Deleted" error is only happening to me. Other users are able to use the database without this happening. I've found some information about the "#Deleted" error online (see http://support.microsoft.com/kb/128809), but nothing that would explain why others would be able to successfully use the database that isn't working for me.
Does anyone have any idea what is going wrong?
Thanks in advance!
