[AccessD] Unable to enter Jee

Hi Dale,

Yeah did a compact and repair.

Also created new blank database and imported everything from the old one.

Chris 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale Kalsow
Sent: 13 January 2005 17:20
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Unable to enter Jee

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.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com