Re database available to a number of users

#21

Hi Phil,

Yes of course you can. If you wish, and it might be easier, you could
send a .SQL file with the MySQL table designs and a copy of the FE you
are working with (I have A2003). I can pull the FE apart a little and
re-build a query or two. In order to do this I need to really have a
working copy of the table structure you are working with. I cant convert
the whole thing for you as I am studying a german language course at the
moment that eats half my time, but I can at least give you good start. I
would be happy to give it a crack for you.

I suspect that there are many ways to solve your current query based
performance concerns, and with a little luck I can deliver back to you a
few hopefully a few reliable and elegant solutions for you to work with.

I seem to recall some time ago I meant to write a comparison between
MySQL and other BE databases when working with an Access FE. I never got
around to doing that. My thinking now is that perhaps a more useful
thing to do is to provide a tutorial on working with Access as an FE and
MySQL as a BE. Its a fair chunk of work to put something like that
together, but perhaps it could function as a type of knowledge base that
can be added to over time. I have a web / domain that is sitting around
doing nothing and this might be a good use for it.
--
Cheers

The Frog

#22

"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in
news:j1v03c$8i2$1 (AT) speranza (DOT) aioe.org:

Quote:

On 10/08/2011 20:54:57, The Frog wrote:
On 10/08/2011 9:39 PM, David-W-Fenton wrote:
You're loading data before your user can actually do anything
with it. That violates the key principle behind a proper
client/server design, i.e., don't retrieve any more data than
necessary for the task at hand.

Amen to that. The less that travels down the wire the better. The
fastest code is the code you dont run..... (I am sure there are
plenty more of these)

So as I understand it, the pass-through query is held in MySQL,
but it appears as a linked table in the FE Access Db.

Passthrough queries are a red herring here.

You described a form that had a bunch of subforms and combo boxes,
all of which are populated when the form opens. Passthrough queries
play little or no role in solving that problem -- instead, you need
to load the form without the data preloaded, and then load it on
demand, when it is displayed to the user.

This will be more efficient because you're not pulling the data
across the wire, not because it's being executed on the server.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#23

"Access Developer" <accdevel (AT) gmail (DOT) com> wrote in
news:9alajpFefkU1 (AT) mid (DOT) individual.net:

Quote:

That would especially not mean Access queries that included VBA
code (e.g., "IIF") -- VBA code is not part of Access' SQL dialect;
it is an addition the developers could conveniently make available
that can be imbedded in Access SQL because the Jet database engine
runs on the same machine as the Access software used by the user.

Actually, that's not entirely true, Larry. IIf() and IsNull() and a
number of functions are part of what the Jet/ACE expression service
can interpret and they aren't the VBA versions. You can see this
because you can use them via ODBC, which can't call VBA functions.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#24

On 13/08/2011 13:04:48, The Frog wrote:

Quote:

Hi Phil,

Yes of course you can. If you wish, and it might be easier, you could
send a .SQL file with the MySQL table designs and a copy of the FE you
are working with (I have A2003). I can pull the FE apart a little and
re-build a query or two. In order to do this I need to really have a
working copy of the table structure you are working with. I cant convert
the whole thing for you as I am studying a german language course at the
moment that eats half my time, but I can at least give you good start. I
would be happy to give it a crack for you.

I suspect that there are many ways to solve your current query based
performance concerns, and with a little luck I can deliver back to you a
few hopefully a few reliable and elegant solutions for you to work with.

I seem to recall some time ago I meant to write a comparison between
MySQL and other BE databases when working with an Access FE. I never got
around to doing that. My thinking now is that perhaps a more useful
thing to do is to provide a tutorial on working with Access as an FE and
MySQL as a BE. Its a fair chunk of work to put something like that
together, but perhaps it could function as a type of knowledge base that
can be added to over time. I have a web / domain that is sitting around
doing nothing and this might be a good use for it.

Hi Mr Frog

Did you get my Email OK as I didn't get a reply?

Phil

#25

Hi Phil,

No, I havent received it as yet. Did you send it to the email address I
use for this group? mr.frog.to.you (AT) googlemail (DOT) com

If that is the one you sent it to then send me another email with a
private address I can contact you at and I will likewise send you a
private address of mine to use. An alternative would be to zip the
file(s) and dump them temporarily at rapidshare or another file hosting
service while I download them. Once downloaded they can be deleted off
the service again.
--
Cheers

The Frog

#26

On 16/08/2011 16:01:55, The Frog wrote:

Quote:

Hi Phil,

No, I havent received it as yet. Did you send it to the email address I
use for this group? mr.frog.to.you (AT) googlemail (DOT) com

If that is the one you sent it to then send me another email with a
private address I can contact you at and I will likewise send you a
private address of mine to use. An alternative would be to zip the
file(s) and dump them temporarily at rapidshare or another file hosting
service while I download them. Once downloaded they can be deleted off
the service again.

Hi

Yes sent it to mr.frog.to.you (AT) googlemail (DOT) com.
If that's not your correct email, can you email me at
phil (AT) stantonfamily (DOT) co.uk.

I guess that's why I never got a reply when I sent you a Db concerning
progress bars

Thanks

#27

sounds to me like you'd have a MUCH simpler time of it.. if you used SQL Server express and Access Data Projects.

SQL passthroughs are a pain to deal with, I'd never reccomend anyone use SPT or Linked Tables for any reason.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re database available to a number of users

comp.databases.ms-access comp.databases.ms-access

Re: Re database available to a number of users - 08-13-2011 , 07:04 AM

Re: Re database available to a number of users - 08-13-2011 , 04:31 PM

Re: Re database available to a number of users - 08-13-2011 , 04:32 PM

Re: Re database available to a number of users - 08-16-2011 , 03:46 AM

Re: Re database available to a number of users - 08-16-2011 , 10:01 AM

Re: Re database available to a number of users - 08-16-2011 , 10:28 AM

Re: Re database available to a number of users - 09-02-2011 , 05:44 PM