[AccessDevelopers] Back End performance

[Orville]

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.