Link Tables NR 01.03.2006 10:40:03 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

Re: Link Tables "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 01.03.2006 11:41:49 Are you sure there isn't another user updating the tables? (Note that you could, in fact, be that other user if you have two copies of the data open in your application) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "NR" <NR[ at ]discussions.microsoft.com> wrote in message news:62BAD4D9-2D2A-425F-8648-2BF93F2D88E8[ at ]microsoft.com... [Quoted Text] > 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

Re: Link Tables NR 01.03.2006 14:11:31 Yes.. I am sure that time no other is updating that record.. Even i have tried it with single instance of that application too but problem is same for those particular records. When i make those changes directly in SQL Server that doesn't creat any problem so SQL Server is not playing any roll in validation failuer.. Please help in this regard. "Douglas J. Steele" wrote: [Quoted Text] > Are you sure there isn't another user updating the tables? (Note that you > could, in fact, be that other user if you have two copies of the data open > in your application) > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "NR" <NR[ at ]discussions.microsoft.com> wrote in message > news:62BAD4D9-2D2A-425F-8648-2BF93F2D88E8[ at ]microsoft.com... > > 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 > > >

RE: Link Tables Hal Totten 22.04.2006 13:38:01 I have seen this when updating smalldatetime fields. Are you using Access 2003? This is the only version I have seen the problem with? If the DB is Access 2000 format, try using Access 2000 to duplicate. "NR" wrote: [Quoted Text] > 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

RE: Link Tables NR 22.04.2006 14:53:01 Yeah It was developed on Access 2000 format and now is being used on both 2000 & 2003 versions.. I hope you have guessed right, problem could be with smalldateandtime fields. As since its been long i had not got resolution so i have already shifted back end database to MS Access. Thanks for the help. It will really be a key point in further application. NR "Hal Totten" wrote: [Quoted Text] > I have seen this when updating smalldatetime fields. Are you using Access > 2003? This is the only version I have seen the problem with? If the DB is > Access 2000 format, try using Access 2000 to duplicate. > > > "NR" wrote: > > > 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