BE limitations

[David]

Hello

I have been informed my domain host that they are limiting their mySql
timeout setting from 28800 seconds to 10 seconds. They are doing it to ensure
that people are only using their open hosting option for basic website
traffic and if any more than that is needed then they must use a new VPN
package.

I use this as a back-end for my access prog and now I will either need to
change domain host (far too much of a stressful alternative) or figure out a
way of controlling my dataflow with 10sec queries.

I only pull a maximum of 10-15 lines from a table at any given time, the BE
stays open simply because I don't know how to turn it off each time I query
for information.

Is that possible? to grab information one bit at a time and close the
connection in between programatically?

 

[Albert D. Kallal]

If you using bound forms, then Usually closing the form will release the
link. But, this can be hard to control...

I only pull a maximum of 10-15 lines from a table at any given time, the
BE
stays open simply because I don't know how to turn it off each time I
query
for information.

One thing access don't well is keep the connection closed...in fact it tries
to keep things open!!

Is that possible? to grab information one bit at a time and close the
connection in between programatically?

If you doing reports etc on this data, then you likely have to setup some
append quires and pull the data from the server side, and THEN launch the
report. Since while that report is open, it going to keep the connection
open to the linked table.

So, if you doing reporting,, you have to pull the data to a local (or better
to temp table in a linked mdb file that is local).

so, bound forms or reprots to that server side table going to be out of
question...

 

[David]

Darn.

One part of the program is a form where multiple simultaneous records are
changed by different users who need to see the changes other users are making.
This would probably require constant queries if updates cant be managed by
refreshing a bound form. Total rewrite.

Would there be a significant loss of performance? I do a lot of updates now
in the form of me.refresh but this would require setting up a connection each
time is that right?

David