Software

Ask something
Discussion Locked

Access 2000 Report too complicated

0 helpful
3 replies

by debbie

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Every night I take a copy of my database and use it the next day to work on. When I have new forms, reports and queries ready I import them into the live version of the database. Is that the best way to do things? Anyway yesterday I made a report that was running fine... when I moved it to the live version now it won't run... it's too complicated. I went back to the original and it runs fine... so I made a new copy of the live version of the be and linked my test copy to it and now the test onewon't run either. The only difference in the be is that the live one had some actual data in some of the fields that yesterdays copy did not. Any ideas???
Thanks
Debbie

3 replies

by yatst

Part 1. Yes this is the safest way. Sometimes interrupting a query (like when your testing) and other changes can corrupt an access db. It's happend to me.

Part 2. CHeck and make sure the query it is running off of has all the correct fields and that the fields in the report and the query are the same. If thats not it get back to me.

This discussion is closed to new replies.