Normaly companies or programmers upgrade to SQL if their database size near to exceed to MsAccess limitation (2GB) and requires more backend securities and advanced data processing.
Speedwise? if you will use MsAccess.mde as FE against SQL BE then it will be more slower compare to AccessFE.mde to AccessBE.mdb. As said, Access Project will do the tricks as it has Stored Procedure on it but never tried. However I still believed that its always depends on the programmer techniques to speed-up the process of the application. Some points I can suggest which I used to do and thus greatly speed-up the process. - Always use unbound forms - Always populate your subforms on Load or Timer Event - Make sure all Recordset and connection are close after usage. - If it is a normal action query process, use the access standard Append, Update, Delete queries rather than VBA code. - Try to avoid using Do Until rs.eof instead use For.. Next - For reports, sometimes I populate the Source on Open event and sometimes I append the result on a temp table and based my reports on that. - there's a lot more.... hth, George -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of arnold choo Sent: Monday, December 04, 2006 1:20 PM To: [email protected] Subject: [ms_access] Microsoft Access vs Microsoft SQL Hi there, I have doubt about the use of Microsoft SQL. Why some large organizations choose to use MS SQL to run their business rather than Access? Was it because SQL is meant for the back end processing and the Access is more on the front end user interface? In my company, the boss wants to convert Access to SQL due to its time consuming in processing large amount of data....Is there any other way that I can still stick to Access and get the same result done?? (fast processing speed) Thank you guys! Arnold C. H. --------------------------------- Want to start your own business? Learn how on Yahoo! Small Business. [Non-text portions of this message have been removed] Yahoo! Groups Links
