I'm running MS Access DB roughly 30K records with several users accessing it at the same time (that's what worries me the most) so I'm looking into moving to some SQL server. I have tried exporting the tables and still using the access forms as a GUI through ODBC. I tested MSDE, MS SQL, mySQL which was the fastest but still slower than MS access file it's self, Especially using "Continuous Forms" My question is : (I'm not an expert, I know just enough to setup simple data base and use it..)
What am I doing wrong? Are there some settings in access, ODBC or mySQL I do not know of.. Or perhaps should I forget access as GUI What are my other options. Thanks for any help --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
