opening access reports

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

Is it opened by your app or another shared user?

my app, thanks

You should be able to open the reports for displaying if you have Access installed. Can you post your code?

Code:

---

Dim AppAccess As Access.Application

Set AppAccess = New Access.Application
AppAccess.Visible = True

With AppAccess
.OpenCurrentDatabase "c:\database.mdb"
.RunCommand acCmdWindowHide
.RunCommand acCmdAppMaximize
.DoCmd.OpenReport "Manual", acViewPreview


End With

---

And thats giving you the error? What does it say?

hehe, it works, I really don't know why, I use to get permission denied message, saying it was already open by another user.

Could have been from debuggin, left an instance running or access.

its strange, because at uni it refuses to work, I have checked to see if acess was running via the task manager etc

but still get a a message saying the database is in use by another user, which should be me.