Jim Lawrence
accessd at shaw.ca
Tue Mar 1 10:54:52 CST 2011
So what is your opinion about using asynchronous or synchronous connection to a MS SQL BE from an Access FE? You would definitely be the man and could put this whole controversy to rest. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Monday, February 28, 2011 2:41 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access and SQL Server ____________________________________________________________________________ ___________ Note: This e-mail is subject to the disclaimer contained at the bottom of this message. ____________________________________________________________________________ ___________ "Are any of your developing full blown ACCESS/SQL Server applications for clients? If so what type of an app is it?" When I was at Coles Group a year or so back I was part of a team of developers that built and maintained a whole suite of custom applications that were built on a common template. All the apps were based on a template which in turn was based on a SQL Server BE with MS Access FE (mde of course). We were starting to move any new apps to a web UI and away from MS Access. Many of these apps were critical for the day to day running of large national retail businesses. To give you some idea Coles Group is one of Australia's largest retailers with more than 2,600 stores throughout Australia and New Zealand, over 400,000 shareholders and more than 190,000 employees. My good friend Beny build a complex logistics app, which was used for scheduling all store deliveries based on availablity and type of truck (Some trucks can only fit in certain bays for example, some truck have to be in the cold store etc). Damn clever with a great UI. Some of these apps had hundreds of concurrent users 24/7, although many also lead a far less demanding life. The financial control system I build had about 50 users over a WAN. It was fast, stable and accurate. Gotta love that :) The big advantage was even though each application was build for a totally different purpose, it had a common platform and build, which meant that any of the development team could work on it if the main developer was away or busy. I miss working with SQL Server. Current role is 100% access based. Feel a bit left behind to be honest... :-/ cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav Sent: Monday, 28 February 2011 11:57 PM To: Access Developers discussion and problem solving Subject: [AccessD] Access and SQL Server Hey All Thanks I have got to try out Stuart suggestion for updating stored procedures in SQL Server using ACCESS. I am not finding any significant differences in speed when using ACCESS tables and queries versus SQL Server tables and pass through queries, I assume that is because I am doing my testing on my local machine and not on a network (or Web). Are any of your developing full blown ACCESS/SQL Server applications for clients? If so what type of an app is it? -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ____________________________________________________________________________ ___________ The information transmitted in this message and its attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information, by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete this e-mail and associated material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files, with the permission of the sender. This message has been scanned for viruses. ____________________________________________________________________________ ___________ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com