Beginner need Help in using Access 2k with ADO/ASP.Net

[Ghulam]

I am using an MS Access 2k ADP (Converted into ADE) front end and SQL 2
on the backend. Although I taught pretty much myself into these concep
with the help of some publications and users group posts, some time
would like to seek some specific help from fellow members. Now m
organization wants to move the application into Web based AS
interface.

I am a totally beginner in this area although I am pretty much familia
with ADO and VBA codes. Currently I am using Win XP/2k PC’s fo
development. My expectations/questions are :

- Is it possible, I can use the existing MS Access 2k front en
Forms/Reports/Modules for the Web Interface without starting everythin
from the scratch in ADO or ASP.Net? I prefer to use the existing one’
while learning the new technologies.

- Is there any book that you recommend that can give me a push start?
would prefer a book that has step-by-step tutorial including a sampl
application. Also that book can help me with setting up my local PC II
5.0/ODBC/Data Interface etc. and Interface with the Server.

- How about the securing the web page and Server Data? Could you pleas
suggest.

As I mentioned earlier, I am totally new to these concepts. An
suggestions or recommendations will be highly appreciated. Thank yo
fellow members

 

[Brendan Reynolds]

If the organisation specifically wants to move to ASP or ASP.NET because
they are committed to those technologies, then you're into a re-write. ASP
and ASP.NET applications are not created using Access. (It's possible to use
ASP or ASP.NET applications with Jet databases, but that doesn't apply in
your case, as your data is already in SQL Server.)

If, on the other hand, the organisation simply wants to give users remote
access (no pun intended), and are not committed to a specific technology,
then there are alternatives to a re-write, such as using Terminal Services.
Another Access MVP, Albert Kallal, has some very useful articles on this ...

http://www.attcanada.net/~kallal.msn/Wan/Wans.html
http://www.attcanada.net/~kallal.msn/Articles/ThinClientsand.net.html

There are so many good books on ASP, ASP.NET, and other .NET technologies
that I wouldn't like to post a list, because the list would be extremely
long and would still be unfair to all the other authors who's books would
equally deserve to be on such a list. Just check out any of the on-line book
stores, you'll soon find that the problem is not finding good books to read,
it's finding the time to read them all!

If you really want lists, though, just go to www.amazon.com and do a search
on ASP.NET - on the resulting page there are three reader-compiled lists, as
well as Amazon's own list of best selling books on the subject.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.