Permanent link to table

[John Zelmer]

In a backend/frontend database configuration:
For performance benefits I've read that in a session it is good to have one table always open (for instance the control table in het main menu form). Is the same benefit applicable if it is not a table but a query in the control source of the main menu form?

Thanks in advance.
John

 

[moke123]

i think what you mean is a persistant connection.
take a look at Daniels article here...http://www.devhut.net/2012/09/29/ms-access-persistent-connection-in-a-split-database/

 

[John Zelmer]

Yes, that's what I mean but the article does not answer my particular question ;-)

 

[MrHans]

You can easily test this right? You will see a lockfile on the backend if the connection is established, so just try and see...

 

[John Zelmer]

Thanks MrHans. I didn't know that. I tested it and I can confirm that a query does the same job as a table in that respect.