By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,867 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Can I link to reports in another database?

P: n/a
Bob
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?

May 10 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
You cant link to reports. you can only pull in data, not forms, reports
or other application objects. application objects live in the
application :(

your best option is to keep your reports in the front end, but create a
small login app which checks for version updates and downloads the
newest version if needed. That way you can update reports in master
front end on the network and simply increment the version number. when
people log in via the log in app it will pull down the new version with
the report updates. lemon squeezy! There's a lot available on how to do
this, so I wont repeat it all here.

May 10 '06 #2

P: n/a
"Bob" <bs*****@merema.nl> 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
May 10 '06 #3

P: n/a
Bob wrote:
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?


See if this link helps
http://groups.google.com/groups?as_q...=2006&safe=off
May 11 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.