Dale Kalsow
dkalsow at yahoo.com
Thu Jan 13 11:20:12 CST 2005
Did you try compacting and repairing the database? Sometimes that helps. Dale Chris Swann <dc8 at btinternet.com> wrote: All, I was aked to look at a database today because it was geberating an error and have come away completely baffled. The initial entry was made as Lee, but the person realised they had mistyped and tried to change it to Jee. This is where the fun began. This change caused a "No current record" error to appear. I checked all through the code, nothing obvious. I deleted the record and its associated data in another table and we tried again. Same error. I then wnet off and tried to enter the data directly into the main table as before. I entered Lee and all was OK. I tried to change it to Jee and got the "No current record" error. I can change the name to any value I want within the table apart from Jee. J works, Je works but no Jee. Can anyone think of any reason for this or seen anything similar. Chris Swann -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------- Do you Yahoo!? Yahoo! Mail - You care about security. So do we.