large mdb file

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

re: large mdb file

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:jkt7e.19745$db3.73068@wagner.videotron.net...[color=blue]
> 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
>
>
>[/color]

re: large mdb file

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
knoNOgeek@SPAMhotmail.com
"It's not IT, it's IS"

"Pierre" <pf@arobas.net> wrote in message
news:jkt7e.19745$db3.73068@wagner.videotron.net...[color=blue]
> 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
>
>
>[/color]

re: large mdb file

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" <knogeek@hotmail.com> wrote in message
news:HrKdnWJ-zb8IFsPfRVn-oA@comcast.com...[color=blue]
> 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[/color]
the[color=blue]
> database all the time.
> --
> Alan Webb
> knoNOgeek@SPAMhotmail.com
> "It's not IT, it's IS"
>
> "Pierre" <pf@arobas.net> wrote in message
> news:jkt7e.19745$db3.73068@wagner.videotron.net...[color=green]
> > Hi all,
> >
> > On an access application there is a huge (110 meg) external mdb file[/color][/color]
that[color=blue][color=green]
> > 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
> >
> >
> >[/color]
>
>[/color]