Have I reached MS Access Limitations?
in [Tables]
|
From: spero on 28 Nov 2009 16:32 I have been working with MS Access for about five years. I have been able to grow my solutions from a simple mdb with a couple of hundred records to adp with sql backend with a couple of hundred thousand records. I always had a controlled audience and all my users have MS office but I am seeing myself coming to a crossroad. I am thinking of another project to a larger audience. I was thinking about an adp solution to a sql backend, (is this a correct statement?) users who do not have access can download the free runtime. But, maybe I have reached my limit and it is time to go to a web solution. For those of you out there that have matured from a well rounded access guy, what was sw development that made it an understandable and user friendly web development environment? Basically what is the next step if I think I reached my access limitations and it is time to do a web base solution? Is it data access pages now?
From: Tony Toews [MVP] on 29 Nov 2009 15:16 "spero" <u56537(a)uwe> wrote: >I have been working with MS Access for about five years. I have been able to >grow my solutions from a simple mdb with a couple of hundred records to adp >with sql backend with a couple of hundred thousand records. I always had a >controlled audience and all my users have MS office but I am seeing myself >coming to a crossroad. I am thinking of another project to a larger audience. >I was thinking about an adp solution to a sql backend, (is this a correct >statement?) users who do not have access can download the free runtime. But, >maybe I have reached my limit and it is time to go to a web solution. For >those of you out there that have matured from a well rounded access guy, what >was sw development that made it an understandable and user friendly web >development environment? Basically what is the next step if I think I reached >my access limitations and it is time to do a web base solution? Is it data >access pages now? What limitations do you perceive? Why do you need to go to a web solution? Users outside your corporation? Access 2010 does support web development now. See my blog in my sig below. ADPs haven't had any significant enhancements for several releases now so while they're not a dead end yet they may very well be. DAPs? I'd forgotten they even existed. I think they don't exist in A2010. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a free, convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/ Granite Fleet Manager http://www.granitefleet.com/
From: David Portas on 1 Dec 2009 17:28 "spero" <u56537(a)uwe> wrote in message news:9fcec865bf5c4(a)uwe... >I have been working with MS Access for about five years. I have been able >to > grow my solutions from a simple mdb with a couple of hundred records to > adp > with sql backend with a couple of hundred thousand records. I always had a > controlled audience and all my users have MS office but I am seeing myself > coming to a crossroad. I am thinking of another project to a larger > audience. > I was thinking about an adp solution to a sql backend, (is this a correct > statement?) users who do not have access can download the free runtime. > But, > maybe I have reached my limit and it is time to go to a web solution. For > those of you out there that have matured from a well rounded access guy, > what > was sw development that made it an understandable and user friendly web > development environment? Basically what is the next step if I think I > reached > my access limitations and it is time to do a web base solution? Is it > data > access pages now? > ..NET, Java and PHP are by far the most common development languages for web-based database applications. They should certainly be high on your list of development options. Access ADP is a legacy feature and not one recommended by Microsoft for new developments. -- David Portas
From: spero via AccessMonster.com on 1 Dec 2009 19:28 Thanks, I really like the idea of access 2010 have this feature, I can use this time to dev the app and when 2010 comes out "go for it". It has been very disappointing not to migrate your app to the web, I have seen some ugly sites that have some sort of access support, it is just like running the db in a citirix client. I truly hope MS comes to the table an lets us publish solutions to the web and hope it is more like a web dev GUI in 2010! I have to believe that there will be access users long after we are gone so just give us the tools to get it to the web! -- Message posted via http://www.accessmonster.com
From: Tony Toews [MVP] on 1 Dec 2009 21:21 "spero via AccessMonster.com" <u56537(a)uwe> wrote: >Thanks, I really like the idea of access 2010 have this feature, I can use >this time to dev the app and when 2010 comes out "go for it". It has been >very disappointing not to migrate your app to the web, I have seen some ugly >sites that have some sort of access support, it is just like running the db >in a citirix client. I truly hope MS comes to the table an lets us publish >solutions to the web and hope it is more like a web dev GUI in 2010! I have >to believe that there will be access users long after we are gone so just >give us the tools to get it to the web! There are limitations. We don't know much, if anything, about the SharePoint server stuff that it's running on and will be available. Nevertheless you down download the A2010 beta yourself and play with it. Also check my blog in my sig below for several discussions relating to A2010 and web services. There are a bunch more discussions which I will be making another blog posting about in the next day or so check back. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a free, convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/ Granite Fleet Manager http://www.granitefleet.com/
|
Pages: 1 Prev: multivalued lookup columns Next: New to the whole DB world |