Linked tables question

Hi all,
I'm wondering if it is possible to have a regular Access mdb, but have
exactly one table which stores images in an MSDE database. Is it possible
to keep all my forms and reports and queries but just have the one image
table stored in MSDE. It appears, from my tests that MSDE doesn't suffer
from the image bloat problem that access does.
"Yair Sageev" <geekyheeb-news@.yahoo.com> wrote:
>I'm wondering if it is possible to have a regular Access mdb, but have
>exactly one table which stores images in an MSDE database. Is it possible
>to keep all my forms and reports and queries but just have the one image
>table stored in MSDE. It appears, from my tests that MSDE doesn't suffer
>from the image bloat problem that access does.
Certainly. That's exactly what linked tables are for. You can have tables
linked to any number of external sources.
- Tim Roberts, timr@.probo.com
Providenza & Boekelheide, Inc
|||To add to Tim's post, yes, it's possible, but beware of heterogeneous
joins. When executing queries that join your MSDE table to Jet tables
(or tables from any other database). Access needs to fetch *all* of
the data from your MSDE table to perform the join locally *before* it
can execute a WHERE clause. In the case of large images, this could
have serious performance implications.
--Mary
On Wed, 4 Aug 2004 12:51:56 -0400, "Yair Sageev"
<geekyheeb-news@.yahoo.com> wrote:

>Hi all,
>I'm wondering if it is possible to have a regular Access mdb, but have
>exactly one table which stores images in an MSDE database. Is it possible
>to keep all my forms and reports and queries but just have the one image
>table stored in MSDE. It appears, from my tests that MSDE doesn't suffer
>from the image bloat problem that access does.
>
|||Thanks for both of your repsonses.
I succeeded in moving all my jet tables to MSDE in the hope that the way
data is stored is improved and that images don't bloat the database. Not
sure if this will work. The application is working fine. I'm not doing any
heterogeneous joins.
I would love to migrate to an ADP file but all my queries break in that
case. I don't know how to reference forms in queries within an ADP.
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:tc37h01h37suaqlk9a92ed583o8mjgafac@.4ax.com... [vbcol=seagreen]
> To add to Tim's post, yes, it's possible, but beware of heterogeneous
> joins. When executing queries that join your MSDE table to Jet tables
> (or tables from any other database). Access needs to fetch *all* of
> the data from your MSDE table to perform the join locally *before* it
> can execute a WHERE clause. In the case of large images, this could
> have serious performance implications.
> --Mary
> On Wed, 4 Aug 2004 12:51:56 -0400, "Yair Sageev"
> <geekyheeb-news@.yahoo.com> wrote:
possible
>
|||It's not a matter of knowing how -- you can't reference forms in
queries in an ADP because they are processed by the SQL Server engine,
which doesn't know anything about Access forms. You'd need to re-write
all your saved Access queries in T-SQL as views or stored procedures.
FWIW, you gain nothing and lose a lot of flexibility when you use an
ADP over an MDB, not just the query processor. You're better off with
an mdb front-end to your SQL Server back-end, which is even what the
Access team is recommending these days. They're definitely moving away
from recommending ADPs for new development.
--Mary
On Sat, 7 Aug 2004 20:11:54 -0400, "Yair Sageev"
<geekyheeb-news@.yahoo.com> wrote:

>Thanks for both of your repsonses.
>I succeeded in moving all my jet tables to MSDE in the hope that the way
>data is stored is improved and that images don't bloat the database. Not
>sure if this will work. The application is working fine. I'm not doing any
>heterogeneous joins.
>I would love to migrate to an ADP file but all my queries break in that
>case. I don't know how to reference forms in queries within an ADP.
>
>"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
>news:tc37h01h37suaqlk9a92ed583o8mjgafac@.4ax.com.. .
>possible
>