Re: Rewrite to internet - 08-20-2005 , 04:29 PM
I would convert the back end to SQLServer. Access will do that for
you. How many problems you will have with that aspect depends on how
you have named your fields. Access lets you get away with field names
that SQLServer will not. There is a tool that will do most of the
work for you (Speed Ferret) but it is $200 the last I looked. It sure
saved me a lot of work when I converted about 10 systems.
I would use ASP or one of the newer .Net variants. Since ASP allows
you to use VBScript which is very close to VBA your learning curve
will be easy. You can simply copy the SQL from your current Access
queries and use them in the ASP code (although there are some changes
due to SQLServer conventions)
I use Dreamweaver for the forms. It works well. I barely had to use
any HTML myself which is good because I barely know it. It also
provides some basic database connections saving you a lot of work.
Lots of books, forums, etc., but not cheap!
I have also seen some tools that claim to convert Access forms to ASP.
I haven't tried them, but depending on what you are doing they might
save you a lot of work and you might not need Dreamweaver if you have
an HTML person on hand.
On Fri, 19 Aug 2005 13:51:36 -0700, "Monty" <monty (AT) chartered (DOT) net>
Re: Rewrite to internet - 08-20-2005 , 11:05 PM
Ira, first thanks very much.
What version of Dreamweaver would recommend? Version 7 or the new 8?
"Ira Solomon" <isolomon (AT) solomonltd (DOT) com> wrote
Re: Rewrite to internet - 08-21-2005 , 09:12 PM
I haven't really researched the new version yet.
Upgrade is $399.
I am trying to finish up a project this week and then I'm going to
look at what Macromedia says about 8.
There is always some danger in a new version, no mater how well it was
tested. You might check to see the upgrade situation if you buy 7
Sometimes there is a free upgrade if you buy within a month or 2 of
the new version.
On Sat, 20 Aug 2005 21:05:51 -0700, "Monty" <monty (AT) chartered (DOT) net>