Rob,
I am only guessing, but access uses LDB files to manage multiple
users on the server, there is a very good chance that with all the opening
and closing of the connections, that this file is being created, delayed and
created again and again. Try writing a small app that holds an open
connection to the database and running it on the server. This will force
the LDB file creation and maintain it. If that cures the problem, then
the LDB is the source of the delays. A long term solution escapes me, but
at least this will identify if the problem is in fact related to the LDB
file.
You also need to be aware, that using MDB files in this manner causes
entire tables to be sent back and forth over the network for each query that
is executed. Perhaps what you are seeing is a combination of factors
related to caching of data locally and refreshing over the network.
While I have been a long time supporter of the MDB97 file format, I would
suggest that you look at MSDE for this task, it will reduce network
traffic, and should not experience any governor issues as the DB is not
being hit constantly.
Matt
----- Original Message -----
From: "crombierob" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Saturday, April 16, 2005 5:56 PM
Subject: [vbhelp] MDB on Server Goes to Sleep after a few minutes
>
>
> Hi,
>
> All my previous DBs were Access 97 on single user pcs.
> The pgm I am developing at the moment is multi user.
> Each user has a copy of my VB6 pgm on their pc, and they all access a
> single Access(97) db on a central Server(Windows Server 2003).
> In my stand-alone pc pgms, I have always noticed that the first
> opening of an Access db takes a fair while, and for the rest of that
> Windows session you never get that delay again. (W98 and XP were both
> the same).
> I figure that Windows has a trick of loading some stuff into memory
> (or whatever), so that any subsequent calls to the DB are faster.
>
> With my new setup the users are noticing similar delays, any time they
> allow my pgm to be inactive for a few minutes. We have tested and
> noticed that the delay is not in the pgm itself, as it can still
> immediately react to a Form show etc. If they then do someting that
> requires a DB lookup, then the 'kick to wake up delay' is noticed.
> My conclusion is that their Windows cannot do it's little trick with
> the DB, as they have no control over what is happening on the server.
> My question is, is it possible to get the server to maintain the DB in
> whatever state(place in memory ? ?) it occupies when the user is
> interacting frequently ?
> If user keeps accessing the DB frequently, it somehow remains 'quick'.
> If they stop for say 4 minutes, then the next interaction is
> noticeably slower. Then it will be fast again as long as they keep
> kicking it every minute.
> I know (very)little about Servers, so no doubt the solution, is not
> the one I have 'pulled out of thin air'. EG Caching, having the db
> always in the Server's swap file, etc.
>
> Thanks for any help,
> Rob Crombie
>
> --- In [email protected], "Unicorn.PC.Support"
> <[EMAIL PROTECTED]> wrote:
> > Chris, SQL Server, or any other RDMS is not a magical pill that
> when you
> > drop them into your project Database problems solve themselves.
>
>
>
>
>
>
> '// =======================================================
> Rules : http://ReliableAnswers.com/List/Rules.asp
> Home : http://groups.yahoo.com/group/vbHelp/
> =======================================================
> Post : [email protected]
> Join : [EMAIL PROTECTED]
> Leave : [EMAIL PROTECTED]
> '// =======================================================
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.9.11 - Release Date: 14-Apr-2005
>
>
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
