tag:blogger.com,1999:blog-7344884.post6074270132724403340..comments2023-09-12T19:30:53.407+10:00Comments on vb123: Niche or Mainstream Access ~ Is this the magic pillGarry Robinsonhttp://www.blogger.com/profile/02982437572659313887noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7344884.post-85588415173839276612008-02-27T09:04:00.000+11:002008-02-27T09:04:00.000+11:00I can confirm the relevance of Terminal Services. ...I can confirm the relevance of Terminal Services. I find that the real virtue of Access is speed of implementation. My major customer is remote from me and frequently needs a new facility which I develop overnight in a front end/back end environment and deliver as a separate password protected module. Terminal Services has eased this process dramatically.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7344884.post-80503160652526932142008-01-03T01:39:00.000+11:002008-01-03T01:39:00.000+11:00I work at major financials, and my recollection is...I work at major financials, and my recollection is that they implement Citrix. The remote Access solution is great, as long as the costs are kept down.<BR/><BR/>At one client we were able to piggy-back on an existing solution, and the performance was excellent for the teams distributed across US, Europe, and Asia. More recently, an Access application that replicates between NY and London worked great locally, but was horrible for those on continental Europe.<BR/><BR/>I had always advocated Citrix, but project lead wouldn't follow up. When she left and I had a chance to push Citrix for Asia, I found the costs prohibiitve, at least within the project constraints. The IT staff required 2 servers per 20 userrs, the minimum, and first year implementation was $80,000, at which we balked.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7344884.post-12551843554847891742008-01-01T14:07:00.000+11:002008-01-01T14:07:00.000+11:00My business has been MS Access for over 8 years, a...My business has been MS Access for over 8 years, and currently have over 120 cutomers nationwide. We use the classic front-end/back-end configuration with linked tables.<BR/><BR/>Of course we have ran across a few IT departments that are SQL or nothing, but for the most part IT is happy to know that we will be responsible for trouble calls and maintaining the software, rather than IT. <BR/><BR/>We have just begung to work with WinConnect, and see it as a great way to extend Access even further.<BR/>In addition, we are planning to move to an Access front-end and SQL Server back-end with linked tables. This gives us the RAD of Access and the stored procedures advantage of SQL.<BR/><BR/>Richard OAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7344884.post-87105195748266862902008-01-01T02:33:00.000+11:002008-01-01T02:33:00.000+11:00IT depts hate Access because of a fundamental orga...IT depts hate Access because of a fundamental organizational discrepancy. IT depts love central planning (think 1970's management). All decisions are made once by a central planner, implemented once, and the users have to live with that. Access users live in a more de-centralized mode of decision making, where decisions, databases, and processes are allowed to bubble up from the front lines.<BR/><BR/> --Rick BAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7344884.post-8319650440020546672008-01-01T02:27:00.000+11:002008-01-01T02:27:00.000+11:00In my experience IT depts hate Access because (1) ...In my experience IT depts hate Access because <BR/>(1) IT depts only like what they can centrally control. They don't like applications that the user can modify and break, and then call the help desk to fix. Access databases are viewed like mushrooms that grow under the desk and are probably poisonous.<BR/>(2) IT depts always set up Access databases incorrectly. IT always takes the short cut of everyone using the same front end hosted on a network drive. Users don't know how to set up Access databases either. Therefore the databases are viewed as being unreliable. <BR/><BR/> --Rick BAnonymousnoreply@blogger.com