Web solution from Access....

[Guest]

How can I turn my Access database into a web based solution.

Is there an easy way to create web based data entry/search/query/print
report screens for my access database without using other softwares..
converting from access froms/queries/reports? I have outside programmers
writing this html stuff in Cold Fusion.. using my mdb database. Seems like
it is getting too difficult to manage. I thought Access was supposed to be
portable to the web. Is cold fusion right/better for a database app?

thx

 

[Brendan Reynolds]

For an internal intranet, you may be able to use Data Access Pages, but
these are deprecated in the next version of Office (see the URL below) so I
would not really advise it.

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=86&Number=1057772

For the public Internet, Microsoft's solution for data-centric web-based
applications is ASP.NET. See the URLs below.

http://www.asp.net/Default.aspx?tabindex=0&tabid=1
http://msdn.microsoft.com/asp.net/

I can't comment on ColdFusion or other third-party solutions, as I do not
have any experience with those tools.

 

[CA_IT]

There are several solutions, a couple of which Brendan has already hit on.

These solutions run the entire range from

Notepad - you can open notepad and start typing html. This of course
requires a lot of html knowledge, but is free

Visual Studio - tools in this group are probably the easiest to use, but,
can cost pretty big bucks.

and everything in between.

The first thing to look at, is where are you going to host this dynamic web.
The webhosting software and configuration limit what solutions are do-able.
For example, if your host is running IIS, and the admin will not support
PHP, then looking at a php solution is a waste of time. Each type of host,
and configuration, has it's own benefits and issues, and everyone has their
opinion of what is best.

If your host supports asp ( active server pages ) then personally I would
probably recommend you check out the free version of visual studio express,
available for download from www.microsoft.com. It is strong enough to do
most anything a newer/smaller web should need. And, this will be nails on a
chalkboard to many developers, but, if you already own a recent version of
FrontPage ( xp or newer ) use it! FP got a bad reputation with it's early
versions, and it earned that reputation. However, it is now a decent tool
for making small webs. It is very intuitive for people already familiar
with office, and it is easier to use than most other softwares. It is
however limited, but, I would be you are not building a website for Bank of
America, so, it is probably plenty powerful enough for your needs.

Good Luck!