_henry_ Posted November 20, 2008 Share Posted November 20, 2008 Hi all, I have a layout that has 10 numbers of field with hundred thousands of records. After I performed find records, it would show "?" in every single field. At first, I thought I need larger field's column larger, however, when I clicked inside the field, it would still show "?" Then, I tried to delete it and it was successfully deleted. I tried to perform the same find and it gave me that "?" for every single field again. Has anyone experience this before? Or is it a corruption' sign? Thank you in advance for the share and comments. :o Link to comment Share on other sites More sharing options...
mr_vodka Posted November 20, 2008 Share Posted November 20, 2008 Sounds like your file is corrupt. Try saving as compact. Link to comment Share on other sites More sharing options...
_henry_ Posted November 25, 2008 Author Share Posted November 25, 2008 Hi John, Thank you for your comment. I tried to save as a copy which will save only the structure not the contents. I will ask again if there's any bugs or errors again. Thank you once again. Link to comment Share on other sites More sharing options...
LaRetta Posted November 25, 2008 Share Posted November 25, 2008 I tried to save as a copy which will save only the structure not the contents. John suggested 'Save A Copy As' which will save in three ways: 1) copy of file (identical including structure and data unchanged), 2) compacted copy (smaller, including structure and data compacted) and 3) clone (no records but structure). Use option 2 which compacts the data. If that doesn't work, we will need to see your zipped file; we can only guess if we cannot see your situation. LaRetta :wink2: Link to comment Share on other sites More sharing options...
_henry_ Posted November 27, 2008 Author Share Posted November 27, 2008 Hi Lareta, I think John mentioned ".. saving as compact." You mentioned option 2 (same idea as John). However, for my safe option, I chose the third option (save as clone). My guess regarding the corruption is from the data, not structure. However, if this still happens, I will let you know. For now, it's good and I will re-import those missing data. Thank you for your help. Link to comment Share on other sites More sharing options...
Jalz Posted December 3, 2008 Share Posted December 3, 2008 We had a very similar situation this week. We had one record with "?" in it, which we could delete, but it always came up if we did a find. What we did was export all the data out of the file in CSV format, save the corrupt file as a clone, and then reimport the csv data back in. This seems to have solved the problem for now. - no idea what had caused it. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5647 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now