Reply to thread

Message: [QUOTE="BruceM, post: 2572370"] Perhaps you have tried every suggestion, but there is no way for anybody else to know that unless you mention it. I was thinking specifically about the suggestion to try creating a *new* table with all text fields plus an autonumber field. Even though your table may be exactly that, something seems to have changed, so starting over could help. Also, what was the result of checking the Indexed property? Can you create a query using the data (this was also asked)? I don't follow the suggestion to test with an empty string as the criteria, but back when the question was asked it would have helped if you had said "Yes, I can create a query, but what do you mean by testing each field?" Or maybe "No, I can't create a query." Any luck with exporting as text, then importing? It may help to create a new, blank database. From there, click File > Get External Data > Import. Navigate to your current database, and select everything you need from every tab. It should be clear enough when you get to that dialog box. I have been wondering from the start of this thread about the purpose and structure of your database. In particular I am curious about your wish (as I understand it) to combine several smaller tables into one big table. I can say that if you append one table to another you will be adding new records, not adding fields to existing records. I'm mentioning this as a comment only. I do not understand your situation well enough to know if it applies in your case. [/QUOTE]

Verification