By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

large mdb file

P: n/a
Hi all,

On an access application there is a huge (110 meg) external mdb file that
is linked.

If that file is use only once in a while, would that
help the network if we link that file on demand and then close the link
when not needed?

What is the load of that file on the network, is there a load at opening
only
or a constant load or is there a load only when someone access it?

Best regards

Pierre

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
As far as I know, there is no need to remove the link when not used.

If you link to an external file and then delete that file afterwards, your
Access application wil not notice anything, as long as you do not open
tabels in placed in that file.

Thomas Zimmermann
"Pierre" <pf@arobas.net> skrev i en meddelelse
news:jk*******************@wagner.videotron.net...
Hi all,

On an access application there is a huge (110 meg) external mdb file that
is linked.

If that file is use only once in a while, would that
help the network if we link that file on demand and then close the link
when not needed?

What is the load of that file on the network, is there a load at opening
only
or a constant load or is there a load only when someone access it?

Best regards

Pierre

Nov 13 '05 #2

P: n/a
Pierre,
110MB isn't huge anymore. In general I prefer writing code that uses
unbound forms which only reach out and touch the database as needed. That
way I can run more clients on a shared .mdb since not every client is in the
database all the time.
--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS"

"Pierre" <pf@arobas.net> wrote in message
news:jk*******************@wagner.videotron.net...
Hi all,

On an access application there is a huge (110 meg) external mdb file that
is linked.

If that file is use only once in a while, would that
help the network if we link that file on demand and then close the link
when not needed?

What is the load of that file on the network, is there a load at opening
only
or a constant load or is there a load only when someone access it?

Best regards

Pierre

Nov 13 '05 #3

P: n/a
Hi,

actually i put a 20 minutes timer on the main form of the program

after 20 minutes the program cycle in the allforms and allreports
object and close every one open.

By doing that am i putting extra load on network or is it ok?

thanks for the answer

pierre

"Alan Webb" <kn*****@hotmail.com> wrote in message
news:Hr********************@comcast.com...
Pierre,
110MB isn't huge anymore. In general I prefer writing code that uses
unbound forms which only reach out and touch the database as needed. That
way I can run more clients on a shared .mdb since not every client is in the database all the time.
--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS"

"Pierre" <pf@arobas.net> wrote in message
news:jk*******************@wagner.videotron.net...
Hi all,

On an access application there is a huge (110 meg) external mdb file that is linked.

If that file is use only once in a while, would that
help the network if we link that file on demand and then close the link
when not needed?

What is the load of that file on the network, is there a load at opening
only
or a constant load or is there a load only when someone access it?

Best regards

Pierre


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.