Access App to Web App?

[Guest]

I consider myself to be an "advanced" Access developer, but I have had no
need to ever deal with data access pages or the like ...

I have developed a fairly simple '03 mdb application with 3 tables
(relational) several read forms, etc. The app works the way I want it to,
Now, I would like for it to be available to anonymouse web users to use it
the way it runs in Access.

I'm not expecting "forms" like I'm accustomed to in Access, but the same
functionality in a web page(s)

Am I too hopeful for a simple "conversion" with a few tweaks to get this
thing to run as a web based application? I've fiddled a little with a trial
sharepoint enabled site but this doesn't seem designed (or intended) for what
I have in mind.

P.S. I have Frontpage 2003 as well and perhaps I should post this in the
Frontpage forum as well

Thanks in advance

 

[J. Clay]

There is no way to "Port" your current access app to the web as I wouldn't
at all recommend Data Access Pages. They are IMHO clunky and the viewer of
the page needs to have MS Office Web Components installed for it to work.
In a controlled IntrAnet environment MAYBE, but definately not the web.

You will need to learn ASP.NET (the defacto scripting web programming in
terms of MS technology) or some other web technology (PHP, etc.) and rewrite
your application using this. The host of your web site will have some say
in the matter also, as some support specific technologies and may have
limits on using databases on their servers.

HTH,
Jim

 

[Guest]

Thanks Jim ..

Looking into asp.net, I found ..

http://www.asp.net/webmatrix

This looks "very interesting" and I'll give it a look-see. There seems to
be a number of bugs in this beta version, but for free I guess one can't
complain too much. Any comments regarding this?

 

[J. Clay]

I use this and it work fine for me. I typically hand code pretty much
everything though, so I could pretty much use anything. My ASP.NET bible is
"ASP.NET Unleashed - Second Edition" by Stephen Walther. This book is a
permenant fixture in my backpack that goes from my home office to my work
office. The CD included with the book has WebMatrix on it.

There are several asp.net web sites with sample code that have also been
invaluable.

Regards,
Jim

 

[Guest]

That's some good info, thanks ... I have "invested" probably in excess of
$1,500 in books covering various topics ... but as you get to really digging
into them, invariably you find that one does such a better job of covering
topics (useful topics) then all the others ... and the others just collect
dust.

 

[Alvin Bruney [ASP.NET MVP]]

If you understand OOP concepts, then ASP.NET should not be difficult at all.
It supports the same UI concepts that access is based on. However, if you
are not familiar with OOP, you will need a good book because the waters will
be a bit rough.

--
Regards,
Alvin Bruney

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc