M
Microsoft
Hi!
I've created a MS project and link my .mdb tables to our SQL server. When
we add records via a form, we cannot go back to that record and make
changes - the error states that there is a write conflict with another user
(only one user in the database).
The only way I can find to fix this is to copy the table in the .adp, delete
the original table and rename the copy. Then relink the table in the .mdb.
Then we can update that record.
I'm thinking this has something to do with yes/no fields but cannot be sure.
Has anyone else run into this problem? Any ideas?
TIA.
Craig
I've created a MS project and link my .mdb tables to our SQL server. When
we add records via a form, we cannot go back to that record and make
changes - the error states that there is a write conflict with another user
(only one user in the database).
The only way I can find to fix this is to copy the table in the .adp, delete
the original table and rename the copy. Then relink the table in the .mdb.
Then we can update that record.
I'm thinking this has something to do with yes/no fields but cannot be sure.
Has anyone else run into this problem? Any ideas?
TIA.
Craig