Query in design view is not working

[browninaz]

I created a prototype database for my business with false records just to make sure that there were no bugs in the design. I then created a new .accdb file for my business and copied and pasted all of the objects I created from my prototype file, selecting to paste structure only, to the actual company file. The reason for this is so that all of my records would start with fresh autonumbers.

Now, one of the queries that I created no longer works, and when I try and create a new query in design view using any fields in any of my tables, the query will run one or two fields only. If I try and add more fields to the query, I get no results. I realized that I had to join my tables again and wondered if that had anything to do with the failure of my queries, but when I try and create a new query after the new joins, it still fails.

Did I copy and paste the objects wrong, or is there something wrong with my access program? Or, is there something wrong with my events?

I have a feeling that it was something that I did moving all of the objects to a new file, and is probably a simple fix for any developer.

Thanks a bunch in advance for any help with this issue.

FYI - I have until the end of the month to get this file up and going, and I'm almost there.

 

[John Big Booty]

Why not simply delete all the test data from your original DB, then do a compact and repair.

See this link for a number of methods of re-setting the Autonumber Field.

 

[browninaz]

Well, that would be all fine and dandy but for the fact that I have been editing all of my objects for two days now and would hate to lose all of my work. Thanks John Big Booty If I can't figure it out soon, I will have to revert to backtracking... It sucks being new to the database game!