Running Report from another database

[Sudermatt]

I have a deployment with a Frontend Access database sitting on numerous
client machines and a BackEnd (server) database, where create all our queries
that are viewed in the FrontEnd. I'm trying to keep the FrontEnd client as
thin as possilble

Is it possible for the FrontEnd application to execute a report that resides
on the BAckend Databse?

I want to avoid having to "push" new reports to each client.

Thanks,
Matt

 

[fredg]

I have a deployment with a Frontend Access database sitting on numerous
client machines and a BackEnd (server) database, where create all our queries
that are viewed in the FrontEnd. I'm trying to keep the FrontEnd client as
thin as possilble

Is it possible for the FrontEnd application to execute a report that resides
on the BAckend Databse?

I want to avoid having to "push" new reports to each client.

Thanks,
Matt

Public Sub SetObjects()
Dim appAccess As Access.Application
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase "C:\PathToFolder\DatabaseName.mdb"
appAccess.DoCmd.OpenReport "YourReportName"
appAccess.Quit
Set appAccess = Nothing
End Sub

 

[Sudermatt]

Public Sub SetObjects()
Dim appAccess As Access.Application
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase "C:\PathToFolder\DatabaseName.mdb"
appAccess.DoCmd.OpenReport "YourReportName"
appAccess.Quit
Set appAccess = Nothing
End Sub

I looked at this post
http://www.microsoft.com/communitie...&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us

and it basically said to Pull in the BackEnd as a Reference in the Module of
the FrontEnd. Then you create a function to Send the report Name on the
FrontEnd and the BackEnd function receives that name and runs it.

Seems to work.

can you tell me any caveats to your way as opposed to the Functional
Reference Method?

Thanks,
Matt