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
>

servers

Hi,
i have several questions, because i'm quite new to SQL-Server and Access
Projects. Till now i only worked with Access.MDB's
i created a new access project and have my database on SQL-Server. I see all
tables in my access-project and can work with them.
Now i need data from 1 excel file and data from an interbase database.
As far as i understand the SQL-Server documentation, this can be done with
linked servers. So i tried to create a new Linked Server for my excel file.
Somehow i must have been doing well because when i tried a query from Query
analyzer i saw the excel data.
When right clicking the linked Server e.g. "XLSSVR" i receive an error: 823,
which i don't understand.
My questions are:
How can i use this linked server from my access project? In other words how
can i access the data from this server?
Do i have to build something on the SQL-Server first, which i could then see
as a view or table in my project or how does that has to be done?
Many thanks for any help!
Regards
ChristophWhy not consider using DTS to import your Excel data to SQL Server?
Steve
"Christoph Schmitt" <CS.Schmitt@.t-online.de> wrote in message
news:c6u81b$rpj$01$1@.news.t-online.com...
> Hi,
> i have several questions, because i'm quite new to SQL-Server and Access
> Projects. Till now i only worked with Access.MDB's
> i created a new access project and have my database on SQL-Server. I see
all
> tables in my access-project and can work with them.
> Now i need data from 1 excel file and data from an interbase database.
> As far as i understand the SQL-Server documentation, this can be done with
> linked servers. So i tried to create a new Linked Server for my excel
file.
> Somehow i must have been doing well because when i tried a query from
Query
> analyzer i saw the excel data.
> When right clicking the linked Server e.g. "XLSSVR" i receive an error:
823,
> which i don't understand.
> My questions are:
> How can i use this linked server from my access project? In other words
how
> can i access the data from this server?
> Do i have to build something on the SQL-Server first, which i could then
see
> as a view or table in my project or how does that has to be done?
> Many thanks for any help!
> Regards
> Christoph
>