Convert Access Forms to web application


S

Shivonne

Hi all,

I have been asked to investigate whether there is any automated tool to
convert MS Access applications into .NET web applications with a SQL backend.
I've taken a look at 2 currently on the market - DBForms and Microtools
Access Whiz. Both of them handled the data conversion fine but didn't do a
good job of the forms.

Has anyone out there looked at anything similar? My main requirement would
be a good automated converter for the Forms part of the app - whether it's to
classic ASP or .NET (VB or C#) isn't an issue as the conversion to .NET can
be done at a later stage.

Thanks as always
 
Ad

Advertisements

S

Shivonne

Hi Mark,

I took a look at these tools - it seems they are better suited to providing
a web front end to the data component of an Access DB rather than converting
an existing Access Forms app.

Thanks

Shivonne
 
T

Tom van Stiphout

On Tue, 24 Mar 2009 14:11:27 -0700, Shivonne

If you understand how different the Access forms package and its VBA
language is from .NET development, you realize why it's exceedingly
difficult to provide a good tool to do that. Which, if it existed,
you'd want to buy for a few hundred bucks. Which makes it a losing
proposition for the tool developer.

Tools that do a good job of switching between the Windows world and
the Web world typically use some meta-language or macro-language that
can be interpreted both ways. XAML is such a language. For example
here:
http://weblogs.asp.net/scottgu/page...ing-a-digg-desktop-application-using-wpf.aspx
Scott Guthrie is showing how simple it is to convert a Silverlight
browser app into a WPF desktop app.
No such luck for Access/VBA, I'm afraid. If you do find a good tool,
please post back and let us know.

-Tom.
Microsoft Access MVP
 
M

Mark Andrews

Sorry man I tried.

Shivonne said:
Hi Mark,

I took a look at these tools - it seems they are better suited to
providing
a web front end to the data component of an Access DB rather than
converting
an existing Access Forms app.

Thanks

Shivonne
 
Ad

Advertisements

S

Shivonne

That's pretty much what I expected unfortunately. So far the best option
seems to be the DBForms tool but it doesn't take the code across (only the
screen front-end) so there's still a lot of coding for developers to do.

If I do find something good out there I'll post back and advise.

Thanks for the assistance.
 
D

David W. Fenton

Both of them handled the data conversion fine but didn't do a
good job of the forms.

This is to be expected. The web is stateless and this has certain
important implications for UI design. Access is completely stateful
and bound, and that determines its UI capabilities. Those cannot be
translated to the Web directly -- they have to be completely
re-engineered to use a stateless UI design. That cannot be
automated, in my opinion.
 
Ad

Advertisements

Joined
Sep 21, 2014
Messages
1
Reaction score
0
have you tried Caspio?

caspio com / extend / platform-extensions / ms-access-database-online / convert-ms-access-to-web.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top