FE / BE or Hyperlink?

[boxsox]

I've currently got 3 databases (Access 2003) - 2 are used to import data and
perform different types of update, the third contains reports, user input, &
output stuff, all 3 share tables (i.e. the 2 updates pull "master" data, and
the reporting database pulls results). Since the updates only need to be
performed once a quarter, I'm trying to decide if I want to include
hyperlinks on the reporting database, to open the other two, or try and
combine everything & split it to Front End / Back End.
I'm not sure which method (splitting or linking) is more efficient. Any
suggestions / advice would be greatly appreciated. I'd also like to see an
example of code that closes down the current database & opens a different
one. (I'm a novice coder, but have some practice lately!)

Thanks for the help!

 

[Fred]

I noticed that nobody answered.

You described your reasons for your current structure, and a couple of ways
that you are thinking about using for your new task. But you never really
told us what you have or what you are trying to do. But a couple of
general notes.

I think that you are talking about "splits" in two "dimensions:"

Front end vs. back end split: The purists will say "always." I would say
yes, if you have 3 or more users.

Splitting / combining data tables between databases. In Access
terminology, a database is the big container (e.g. .mdb file). In general,
if the tables relate to each other in some way, it's best to put them into
the same container(database) unless you have a real reason for separating
them.