ok, having problems with open reports

I am creating a loans system for dvd/cd etc

I have a table called items and have a ItemsAdaptor, ItemsConnection and ItemsDataSet

when the program is run, the database is already open, I can't open the access report since the database is already in use.

how do I get around it?

I can't run Crystal Reports, at uni, so can't use them.

thanks