Reports and VB6

Hi,

I need to run access reports from vb (no other way around at the moment!) I have been using the following code but I keep getting runtime error 2486 : Unable to peform as some other event is preventing it...try later

I have tried using doevents before it but it doesn't help

Does anyone have any ideas?

:code:

Dim appAccess As Access.Application
Set appAccess = New Access.Application

appAccess.DoCmd.OpenReport "reportname", acViewNormal
appAccess.Quit

Set appAccess = Nothing

any help greatfully appreciated

:confused: H.

Are you getting the error on the Quit command or the OpenReport command?

OpenReport command

How have you opened the database.

There is the

Code:

---

appAccess.OpenCurrentDatabase

---

method.

Thanks for your help