Have I reached MS Access Limitations?

[spero]

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?

 

[Tony Toews [MVP]]

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/

 

[David Portas]

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.

 

[spero via AccessMonster.com]

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!

 

[Tony Toews [MVP]]

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/