Back End Reports

[PC User]

Is there a way to store reports on the backend of a split database and
still use them on the frontend? I also need to read from the
MSysObjects that is on the backend without linking to it.

Thanks,
PC

 

[Graham R Seach]

If it's a backend database, I fail to see why you'd want to run queries on
it. You can always run the queries against the tlinked tables.

In any case, you can use distributed queries:
SELECT * FROM [pathtodatabase.mdb].MSysObjects

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Graham R Seach]

Oh, I forgot about the reports.

The only way to run reports on a remote database is to automate to it. Place
the following code into either a class or form module.
Private WithEvents rpt As Access.Report
Private acc As Access.Application

Public Sub h()
Set acc = New Access.Application

acc.OpenCurrentDatabase ("path_to_database.mdb")
acc.DoCmd.OpenReport "rptMyReport", acViewPreview
End Sub

Private Sub rpt_Close()
'The report was closed
acc.CloseCurrentDatabase
acc.Quit acQuitSaveNone
Set acc = Nothing
End Sub

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Pieter Wijnen]

but reports shouldn't be left in the BE
a BE should only be used for storing data

Pieter

 

[Graham R Seach]

In principle I absolutely agree Pieter, but you have to remember that what
constitutes a "backend" is a matter of perspective. What is (in one
application) a backend file, is a frontend in another application. I don't
believe this is the case in PC's scenario, so your comment is true. I
provided the information on a just-in-case basis only.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia