Re: Can I link to reports in another database?

"Bob" <bsmedes@xxxxxxxxx> wrote in news:1147259863.339323.98880
@j33g2000cwa.googlegroups.com:

For maintenance reasons I would like to split my DB in an Frontend and
a Backend. The frontend is an MDE. The backend contains all the tables.
Nothing special. But I will also have my reports in the backend or even
in a second backend database. I that case I can easily spread new
reportslayouts to my customers, without rolling out an update of my
frontend database.

But: is that possible in MSACCESS 2003 and how? Ca it be done with a
reference to another DB?

Probably you can if you set a reference to the database containing the
reports and expose them by modifying their manifestation as text.
This is not trivial (and may be impossible). To learn how, you could serach
this group for Terry Kreft and VB Attribute; this thread addresses the
exposure issue:
http://groups.google.ca/group/comp.databases.ms-
access/browse_frm/thread/52b6f6c65f84b0cb/855dfeb0f00bd7fa

It !!!MAY!!! be easier to reference the database and to create a public sub
in a standard module (in that database) that opens the report, and to call
that from from your main db.

--
Lyle Fairfield
.

Relevant Pages

  • Re: Split Database Security Problem
    ... Both frontend and backend ... > permissions, but as in all good stories there is a catch. ... The newAdmin for the 'object database' has the ...
    (comp.databases.ms-access)
  • Re: Split Database Security Problem
    ... Both frontend and backend ... > permissions, but as in all good stories there is a catch. ... The newAdmin for the 'object database' has the ...
    (comp.databases.ms-access)
  • RE: Form on front end loading slowly
    ... I gather the user has a frontend that uses a backend database on a server ... > have a database backend with a table that lists employees, ...
    (microsoft.public.access.formscoding)
  • Re: Multi users Logon Security questions
    ... > The next thing I need to do is split the database so others can work ... and navigate to the mdb - copy the mdb. ... You can use your desktop shortcut (which will open your frontend). ... Ctrl-O and open the backend mdb. ...
    (microsoft.public.access.security)
  • Split Database Security Problem
    ... I have managed to secure a split database. ... Both frontend and backend ... permissions, but as in all good stories there is a catch. ...
    (comp.databases.ms-access)