Performance question?

[alex]

Hello All,

Using Access ’03…

I have a question about db speed/performance.

I have a FrontEnd db and BackEnd db.

My tables in the FE are of course linked to the BE. I have few
tables, however, also linked to the BE which are then linked to the
FE.

So, e.g.; FrontEnd.mde > BackEnd.mdb > BackEnd2.mdb.

Instead of linking tables in the BackEnd2.mdb to the BackEnd.mdb and
then to the FrontEnd.mde, should I directly link the tables in
BackEnd2.mdb to the FE.

Is there a performance issue one way or the other?

Have I confused anyone?

-alex

 

[Roger Carlson]

You can't link through a middle-tier in Access.

If you have table linked in Backend.mdb from Backend2.mdb, it won't even be
visible in the list when you try to use File>Get External Data>Link Tables.
You can Import it (File>Get External Data>Import), but that will just create
a *link* back to Backend2.mdb.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L



Hello All,

Using Access ’03…

I have a question about db speed/performance.

I have a FrontEnd db and BackEnd db.

My tables in the FE are of course linked to the BE. I have few
tables, however, also linked to the BE which are then linked to the
FE.

So, e.g.; FrontEnd.mde > BackEnd.mdb > BackEnd2.mdb.

Instead of linking tables in the BackEnd2.mdb to the BackEnd.mdb and
then to the FrontEnd.mde, should I directly link the tables in
BackEnd2.mdb to the FE.

Is there a performance issue one way or the other?

Have I confused anyone?

-alex

 

[alex]

You can't link through a middle-tier in Access.

If you have table linked in Backend.mdb from Backend2.mdb, it won't even be
visible in the list when you try to use File>Get External Data>Link Tables.
You can Import it (File>Get External Data>Import), but that will just create
a *link* back to Backend2.mdb.

--
--Roger Carlson
  MS Access MVP
  Access Database Samples:www.rogersaccesslibrary.com
  Want answers to your Access questions in your Email?
  Free subscription:
 http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


Hello All,

Using Access ’03…

I have a question about db speed/performance.

I have a FrontEnd db and BackEnd db.

My tables in the FE are of course linked to the BE.  I have few
tables, however, also linked to the BE which are then linked to the
FE.

So, e.g.; FrontEnd.mde > BackEnd.mdb > BackEnd2.mdb.

Instead of linking tables in the BackEnd2.mdb to the BackEnd.mdb and
then to the FrontEnd.mde, should I directly link the tables in
BackEnd2.mdb to the FE.

Is there a performance issue one way or the other?

Have I confused anyone?

-alex

Thanks Roger for your help.
The tables in the main BE must reside there and are linked to the
second BE.
That answers my question; thanks.
alex

 

[(PeteCresswell)]

Per alex:

Instead of linking tables in the BackEnd2.mdb to the BackEnd.mdb and
then to the FrontEnd.mde, should I directly link the tables in
BackEnd2.mdb to the FE.

Is there a performance issue one way or the other?

Have I confused anyone?

I don't know enough to comment on performance - except that I
can't conceive that direct links could be slower.

But there's also the issue of simplicity.

Seems more upfront and less confusing to just have the direct
links. And if you wind up refreshing links in VBA code, the
direct links would enable you to do them all.