[AccessD] Access Front-End via Web Enabled

You can pretty much use your WinForms code (classes and modules) in ASP.NET
with some tweaks to allow for web-specific features.

1. Session variables - functions pretty much like global variables.
Web-based apps are stateless so you will need a way to track each user via
their SessionID and other Session variables you define.

2. Passing values from one page to another - Session variables take up
server memory and resources so this is not a recommended way for passing
values. You use the Request object to read the querystring (that long line
of gobblygook you see on the URL) or read the form values that the server
keeps track of.

3. Disconnected recordsets - there's no such thing as bound forms in a
web-based app. You will need to learn the tricks and intricacies of
disconnected recordsets and how to best code CRUD (Create, Retrieve, Update,
Delete) operations.

Those are some of the "little things" you have to adjust to when
transitioning to or considering .NET development.
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, August 16, 2007 8:16 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Front-End via Web Enabled

I haven't worked with it at all in several years because virtually all our
development is WinForms using VB.Net.  I never worked with ASP, so I don't
know how different ASP.Net is.  There are lots of books on it, which should
help.  The biggie is getting used to the .Net object model where EVERYTHING
is an object and there are multiple ways to do something, some of them more
right than others.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Julie Taylor
Sent: Thursday, August 16, 2007 8:10 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access Front-End via Web Enabled

Hi Charlotte,

Thank you for answering me.  Was it difficult to get into?  Is the
transition from Access a difficult one?

By the way, for all of you members in Italy..........I was there this
summer.  Absolutely beautiful country.  People were wonderful.
You have such a treasure!

My photos are on my website, if anyone would like to see them.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, August 16, 2007 10:57 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Front-End via Web Enabled

You won't like the answer:  ASP.Net

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Julie
Reardon-Taylor
Sent: Thursday, August 16, 2007 7:20 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access Front-End via Web Enabled

Looking for some opinions on what people are using for a web-enabled access
database.  I have used replication for some applications, but would now like
to move the front-end to a browser so that the input can be done via a web
page over a wireless connection.

Have toyed with data access pages, but not sure if that is a good solution.

This application has three subform levels and the scripting may be an issue
in DAP.

Did I read a posting on AccessD at some point that DAP are going to be out
in the next version of Access?

What are other people using as forms via the www?



Julie Reardon
PRO-SOFT OF NY, INC.
44 Public Square Suite #5
Watertown, NY 13601
Phone: 315.785.0319
Fax: 315.785.0323
www.pro-soft.net
NYS IT Services Contract CMT026A
NYS Certified Woman-Owned Business