access to web

[kevcar40]

Hi
i have a database that users enter datai into
i am tempted to try and make this a web appliction
What would be the best way to go about this?
any ideas

kevin

[Albert D. Kallal]

Re: access to web

"kevcar40" <kevcar40@btint ernet.comwrote in message
news:d7fefb0d-0799-4fae-b5c3-68385fe91de4@r6 6g2000hsg.googl egroups.com...

Hi
i have a database that users enter datai into
i am tempted to try and make this a web appliction
What would be the best way to go about this?
any ideas
>
kevin

Unfortunately MS access itself has no relationship with the web, and is not
a web based tool at all.

You can however adopt some technologies that will allow you to use your
application remotely. For example you can move the backend data to SQL
server, and then deploy the front is to any computer that has an Internet
connection, and your application will function. While this is not an actual
web based application, it will Allowed anyone with an Internet connection to
use the application.

Another possibility if you don't have a lot of tables, is to link the table
to a share point list. however, once again this will still require that you
have MS access installed and running on the client computer.

Another good approach and one that the eliminates the need to rewrite any
code is to use windows terminal services. I explain some of your options and
give you some ideas and the following article of mine:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

So, for the most part MS access really is not a web based tool, and simply
is the wrong tool if you need a web based system. If you really do need a
web based system, then you'll have to adopt a different set of tools and
technologies that will allow you to create web based forms etc. (a good
possibility in this department would be to use visual studio and asp.net).


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKa llal@msn.com

[Bob Alston]

Re: access to web

>i am tempted to try and make this a web appliction
>What would be the best way to go about this?
>any ideas
>>
>kevin

I have been researching ways to convert access to the web for some time.
No great answers. but some interesting approaches if you are willing to
learn some new software.

Take a look at two articles on my web site:

http://webpages.charter.net/bobalston/Documents/Microsoft%20Access%20Developer%20Transition%20to%20Internet.htm

http://webpages.charter.net/bobalston/Documents/Access-WebConversionSoftware.htm

Finally be sure to take a good look at Iron Speed Developer
(ironspeed.com) , #22 in the list of software at the second article.

bob