Read remotely via Front-End or via Back-End?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mscertified - 26 May 2007 00:32 GMT

When reading a split Access DB via an OLEDB connection, does it make any
difference whether I read from the front-end or the back-end database. I
really need to read from the front-end as I have to read queries which are in
the front-end. But is it better to read from the back-end directly and
duplicate my queries there?

Thanks for any advice.

Reply to this Message

Klatuu - 26 May 2007 22:11 GMT

What are you reading it from?

Signature

Dave Hargis, Microsoft Access MVP

> When reading a split Access DB via an OLEDB connection, does it make any
> difference whether I read from the front-end or the back-end database. I
[quoted text clipped - 3 lines]
>
> Thanks for any advice.

Reply to this Message

mscertified - 30 May 2007 20:41 GMT

I need to do this for 2 different applications, so I have 2 answers:
(1) From a web page residing on a web server. Database is on a shared
network drive. Yes I know its slow but its reading only.
(2) From a shared network drive linked to a back-end on a web server. This
one needs to do reads and updates.

> What are you reading it from?
>
[quoted text clipped - 5 lines]
> >
> > Thanks for any advice.

Reply to this Message

david@epsomdotcomdotau - 28 May 2007 23:16 GMT

When reading, does it make any difference if you open
two files or three? Does it make any difference if you
check permissions on one file or two? (actually, not
very much)

You get better seek performance if you open a table
in the BE instead of a query or link. Are you doing
that? (no because you are using a query).

If you are the only user, you get better performance
if you open the file in exclusive mode. Can you do
that with OLEDB?

How complex are your queries? Do you want to
link to the queries instead of linking to tables? (The
table link wizard won't do that for you - you have
to use your own code)

Reply to this Message