opening access reports

[-=Sniper=-]

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

[RobDog888]

Is it opened by your app or another shared user?

[-=Sniper=-]

my app, thanks

[RobDog888]

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

[-=Sniper=-]

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

[RobDog888]

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

[-=Sniper=-]

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

[RobDog888]

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

[-=Sniper=-]

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.