Where to go from here w/ MS Access and Web development ?

[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?

 

[Beetle284 via AccessMonster.com]

my access limitations and it is time to do a web base solution? Is it data
access pages now?

Well, definitely not DAP's. They never really worked as intended and
have been deprecated at this point. Prior to now, you would have had to
migrate to a completely different program in order to operate on the web,
however, with the forthcoming Access 2010 we will have the ability to
build an application that will be fully web compatible. There is not a lot
of information out there yet because it is still in beta (the beta recently
went public and is available for download), but there have been several
discussions about it recently in the newsgroup. Here are a couple of
the more lengthy threads that you may find interesting reading;

http://www.accessmonster.com/Uwe/Forum.aspx/databases-ms-access/43460/Access-2010-article


http://www.accessmonster.com/Uwe/Fo...access/43461/Access-2010-with-Sharepoint-2010

 

[Spero]

Sean:

Thanks for the response; the problem on my end is that our office
never saw the need to migrate to the latest and greatest version of MS
office, so I have no clue what is available in more recent versions. I
am 2003 at home and 2000 at the office. I started with VB and had a
hard time with the data structure and I have been working with access
for some time now. I am VERY comfortable with Access and would really
love the ability to publish some of my solutions on the web. I have
played around a little with web dev express and I really have not true
deliverables today that are web based but not being able to publish in
web application is just frustrating!!! I will take your word an
continue on my Access path and wait on the 2010 version. When is it
due out? Again thanks for the response!

 

[Tony Toews [MVP]]

Thanks for the response; the problem on my end is that our office
never saw the need to migrate to the latest and greatest version of MS
office, so I have no clue what is available in more recent versions. I
am 2003 at home and 2000 at the office. I started with VB and had a
hard time with the data structure and I have been working with access
for some time now. I am VERY comfortable with Access and would really
love the ability to publish some of my solutions on the web. I have
played around a little with web dev express and I really have not true
deliverables today that are web based but not being able to publish in
web application is just frustrating!!! I will take your word an
continue on my Access path and wait on the 2010 version. When is it
due out? Again thanks for the response!

The nice thing about the Access 2010 solution for web development is
that only one person will need to purchase A2010. However there will
be some server licensing constraints of which I, and many people, are
still unclear about. That is how much will the server part cost.

I'd suggest visiting my blog below to looking at the Access 2010
specific blog entries for links to extensive discussions on 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/