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

H.