If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Have I reached MS Access Limitations?
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? |
#2
|
|||
|
|||
Have I reached MS Access Limitations?
"spero" u56537@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/ |
#3
|
|||
|
|||
Have I reached MS Access Limitations?
"spero" u56537@uwe wrote in message news:9fcec865bf5c4@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 |
#4
|
|||
|
|||
Have I reached MS Access Limitations?
"spero" u56537@uwe wrote in message news:9fcec865bf5c4@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 |
#5
|
|||
|
|||
Have I reached MS Access Limitations?
"spero" u56537@uwe wrote in message news:9fcec865bf5c4@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 |
#6
|
|||
|
|||
Have I reached MS Access Limitations?
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 |
#7
|
|||
|
|||
Have I reached MS Access Limitations?
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 |
#8
|
|||
|
|||
Have I reached MS Access Limitations?
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 |
#9
|
|||
|
|||
Have I reached MS Access Limitations?
"spero via AccessMonster.com" u56537@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/ |
#10
|
|||
|
|||
Have I reached MS Access Limitations?
"spero via AccessMonster.com" u56537@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/ |
|
Thread Tools | |
Display Modes | |
|
|