RE: [AccessDevelopers] Back End performance

[Kelly Williams-Schmaltz]

What is the OS of your network?   There are known issues with Novell and the Jet Engine that cause these kind of problems.   In Novell there is a setting for Max record locks allowed, have the network person raise this amount.    It is also helpful to raise the Max record locks in the jet engine also.    Here is the Knowledge base article on doing that:  http://support.microsoft.com/default.aspx?id=815281   Hope this helps. Thanks   Kelly Williams-Schmaltz Marcia Brenner Associates 608-836-4000 x805 800-258-0190 x805 www.mba-link.com -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Orville Sent: Tuesday, November 08, 2005 1:33 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Back End performance Importance: High Hallo everybody,               I’m developing an application for a company and for the very first time I had serious speed problems. I’m sure that the bad performance depends on the network (the database has a BE on server and linked FEs on PC) and I’m more sure that they’ll never modify network SW and HW.               How can I improve the performance of my database? I normalized it, forms and reports are based on tables or simple queries, there’s an intensive use of SQL statements in my VB code but when two users work on DB they’re practically still (in one case there’s also a timeout error, and files are set to work in shared ways).               What can I do? I’m seriously thinking to change the BE from mdb (access) to other but what? SQL server, MySQL, other?               Thanks to everybody,                           Manuel Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access training Microsoft access training course Microsoft access programming Microsoft access tutorial YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.