Rob, Check out the OPLOCKS information on the Microsoft site. It might not fix your problems, but it sure could save you some.
Matt ----- Original Message ----- From: "Rob Crombie" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Saturday, April 16, 2005 7:46 PM Subject: Re: [vbhelp] Re: MDB on Server Goes to Sleep after a few minutes > > Hi, > > The main hurdle to changing to another DB type is me. > I am still developing portions of the app, and it is taking a looooong time. > Thus any learning curve for me(aka much extra time), would be a very bad > choice. > > They have only just setup the Server, and the person doing it is kind of new > to that. > Is it not possible that there is some setting that is not yet made, or some > setting that could be made ? > > Rob, > [EMAIL PROTECTED] > > ----- Original Message ----- > From: "Adelle Hartley" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Sunday, April 17, 2005 1:01 PM > Subject: RE: [vbhelp] Re: MDB on Server Goes to Sleep after a few minutes > > > > Hi, > > > The data, I believe, is far too dynamic for any local 'storing'. > > The DB possibly will never exceed 10 MB, and proably will be > > much less. > > Could the whole DB be cached ? > > If your database is only 10MB and file caching were already working, then > the whole file should already be cached (or at least there is no reason why > any of it would drop out of the cache once loaded). > > > At the moment it is really annoying the boss (who is my > > design user), so I am sure that cost for extra memory on the > > server would not be a hurdle. > > I would consider using MSDE. It is a good solution for <10 users and if it > solves your problem, then your boss will be more inclined to invest in a > full blown SQL Server license should the number of users grow. > > I would be inclined to investigate the cost of a "development license" for > SQL Server - the SQL Server tools will make developing and maintaining an > MSDE database a lot easier (and for your employer, cheaper) and you can > deploy the finished product using MSDE (which will cost nothing, since it is > covered by your VB6 license [1]). > > > PS My design philosophy is - > > - Don't hold connections, just connect and read the data, and > > disconnect immediately. > > If the user has made changes to the Form, then I connect, > > update, and disconnect. > > Not such a bad strategy with Jet/Access. Unnecessary if you upgrade to > MSDE. > > In the short term, I would try experimenting with continuous connections - > but only if your updates are already wrappend in transactions (which should > eliminate or at least reduce the risk of any corruption). > > Adelle. > [1] Nothing in this e-mail should be construed as legal advice. I am not a > lawyer. > > > > > ---------- > > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.9.9 - Release Date: 13/04/2005 > > > [Non-text portions of this message have been removed] > > > > > '// ======================================================= > 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/
