Re: once upon a time... : linked tables

Michiel Rapati-Kekkonen wrote:
hi,

once upon a time I read that the communication with the back end
would be faster if one table there was kept open.
For that purpose you were supposed to make an otherwise useless table
in the back end, link to it and open it when opening the front end,
keeping it open until you close the front end.
Is this a indeed viable and useful?

thanks voor your thoughts and experience

Michiel

Yes. Most of the benefit is that the LDB file has to be created (or modified)
when you open the back end file and there is a slight delay while that happens.
If you keep a persistent connection then that delay happens only once.
Otherwise that delay is incurred over and over each time you connect to the file
when there are no other existing connections.

You don't really have to create a "useless table" to do this though. Just open
a bound form or a VBA Recordset in code at startup and leave it open. It
doesn't really matter what table is used.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: once upon a time... : linked tables
    ... do you know of more of such somewhat unexpected ways of improving ... If you keep a persistent connection then that delay ... You don't really have to create a "useless table" to do this though. ...
    (comp.databases.ms-access)
  • Re: once upon a time... : linked tables
    ... do you know of more of such somewhat unexpected ways of improving ... If you keep a persistent connection then that delay ... You don't really have to create a "useless table" to do this though. ...
    (comp.databases.ms-access)
  • Re: Confused about synchronous communications
    ... For your i2c communication it seems like you don't you any interrupts or ... If the communication is interrupted by a task switch, ... 'polling' does not apply here, as you can change the clock, and then ... The routines have a delay that you can set, ...
    (sci.electronics.design)
  • Re: Help speed up RS-232 communications!
    ... communication to a custom PCB. ... I set the connection settings such that the input buffer is not ... delay is coming from would be extremely helpful. ...
    (comp.soft-sys.matlab)
  • Re: Access STIMER(M) from COBOL program?
    ... This function (and CEEDLYM for delay in milliseconds) are available ... message is not the intended recipient or an authorized representative of the ... communication is strictly prohibited. ... attachments from your system. ...
    (bit.listserv.ibm-main)
Loading