K
Kerry in KCMO
I have an access DB with a linked table to SQL Server.
I have a form that is based off that table.
(The form was already created by someone who no longer works here.)
There are combo controls on the form that are populated from different tables.
I added a yes/no field to the SQL table.
If I go back to my form and edit/create records, everything is fine and dandy.
If, on the other hand, I update the linked tables (to include the new
field), edit/create receives the write conflict error.
***********************************************************
This record has been changed by another user since you started editing it.
If you save the changes, you will overwrite the changes the other user made.
Copying the changes to the clipboard will let you look at the values the
other user entered, and then paste your changes back in if you decide to make
changes.
************************************************************
There are supposed to be 3 buttons on this window: Save Changes, Copy to
Clipboard, and Discard Changes.
The Save Changes button is disabled.
I KNOW there are no users in either the Access DB or the SQL DB because I
have the Access DB on a local, non-shared drive and the SQL DB is locked down
to just me.
What do I do??
I have a form that is based off that table.
(The form was already created by someone who no longer works here.)
There are combo controls on the form that are populated from different tables.
I added a yes/no field to the SQL table.
If I go back to my form and edit/create records, everything is fine and dandy.
If, on the other hand, I update the linked tables (to include the new
field), edit/create receives the write conflict error.
***********************************************************
This record has been changed by another user since you started editing it.
If you save the changes, you will overwrite the changes the other user made.
Copying the changes to the clipboard will let you look at the values the
other user entered, and then paste your changes back in if you decide to make
changes.
************************************************************
There are supposed to be 3 buttons on this window: Save Changes, Copy to
Clipboard, and Discard Changes.
The Save Changes button is disabled.
I KNOW there are no users in either the Access DB or the SQL DB because I
have the Access DB on a local, non-shared drive and the SQL DB is locked down
to just me.
What do I do??