We have a record called a CCR with only five fields in it. You can have many CCR's to one parent. One of the fields in the CCR record is a MEMO field called TOPIC. The user can hit Shift-F2 and the ZOOM Dialog Box comes up and they enter text. Everything's great so far. But every so often a CCR is created that kicks the user completely out of the database. No messages, directly from the ZOOM Dialog Box to completely out of the database. And it does NOT save that record when it occurs.
Here's the specific example where we can duplicate the error: The record has 279 characters in it and ends with the word "access"; if the user puts a period at the end of that sentence and hit's the OK in the ZOOM Dialog Box, it kicks you out of the database. Any single character, a period, an "x", any character in the 280th position you get kicked out and it doesn't save the record.
Now if you put 2 characters; two periods, two "xx", another complete sentence everything is fine and the ZOOM Dialog Box closes and the record is updated. But if you back space to the 279th character, and put in that single 280th character, you're kicked out of the database. You can put more character or take away characters, but if the TOPIC field for that particular CCR ends at 280 characters you get kicked out.
I've tried compact and repair on the database (it's a split database), I've tried to stop the code in an EVENT but it never seems to go BACK to an event, it just kicks you out of the databases from the OK button on the Zoom Dialog Box. I've checked for special characters as well and there are none.
We're running Windows 7 / Office 2010 on our laptops, but both the Front-end and Back-end of the database are ACCESS 2003.
Has anyone seen something like this before? Any hints on a google search I might do, or a Microsoft link would greatly be appreciated.
Shawn...
Here's the specific example where we can duplicate the error: The record has 279 characters in it and ends with the word "access"; if the user puts a period at the end of that sentence and hit's the OK in the ZOOM Dialog Box, it kicks you out of the database. Any single character, a period, an "x", any character in the 280th position you get kicked out and it doesn't save the record.
Now if you put 2 characters; two periods, two "xx", another complete sentence everything is fine and the ZOOM Dialog Box closes and the record is updated. But if you back space to the 279th character, and put in that single 280th character, you're kicked out of the database. You can put more character or take away characters, but if the TOPIC field for that particular CCR ends at 280 characters you get kicked out.
I've tried compact and repair on the database (it's a split database), I've tried to stop the code in an EVENT but it never seems to go BACK to an event, it just kicks you out of the databases from the OK button on the Zoom Dialog Box. I've checked for special characters as well and there are none.
We're running Windows 7 / Office 2010 on our laptops, but both the Front-end and Back-end of the database are ACCESS 2003.
Has anyone seen something like this before? Any hints on a google search I might do, or a Microsoft link would greatly be appreciated.
Shawn...