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

[Guest]

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.

 

[Guest]

What are you reading it from?

 

[Guest]

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)

 

[Guest]

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.