Problem in Link Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have one application developed in MS Access as front end and SQL Server is
used as back end database. For database connectivity i have used link tables
through ODBC.
This application was working properly since one year but now facing one
problem while updating/editing some records not on all the records and i am
unable to identify for which criteria it is not validating. Below is the
message which apperars in updation of some records (Please note this message
doesn't appear for all the records, new records are being saved properly,
editing of some records creats problem)
********** Error Message Starts Below****************
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.
Coping the changes to the clipboard will let you look at the values the
other user entered, and then paste you changes back in if you decide to make
changes.
********** Error Message Ends Here *****************
*** Following options/buttons are available ***
Save Record | Copy to Clipboard | Drop Changes

Problem in this option is with "Save Record" which remains disable.


Any one who can help me in this regard.


Best Regards,
NR
 
Are there other users on the system that may be working with the same record?
This is possible in a multi-user environment.
 
Yes its a multi user application but we have ensured that time no other one
is updating that particular record and those particular records are not being
updated any time. I mean this problem does occur with some particular
records. Once a message is appeared for any record that is going to be ever
like this.

Please guide me what can be done in this record.
I doubt for any version compatability of MS-Access... But cannot say any
thing because we are always upgrading from prior to latest version.. :(
 
I don't think I can really help any further. I remeber having seen some
posts on this, but I can't recall what the resolutions were.
 
Back
Top