Converting Access to Website - ASP

[Jasmine]

Could anyone recommend an excellent 3rd party software vendor that
specialize in converting
Msaccess program into ASP .

I have a working Msaccess application which I need to publish on the Company
Website for
Client access.

I've seen programs that converts tables to asp , but is there something that
converts a MDE file
to a full workintg ASP program.

I would take anything I get at this time -

Any help directing me to a good source would be extremely valuable.

Thanks for any suggestions.

 

[Michel Walsh]

I seriously doubt such thing exists, even if you include ASP.Net 3.5 (which
can have a more similar property-like syntax), because of the nature of the
controls themselves, without speaking of poor optimization that would occur
in a line-by-line conversion of the code.

Access is already a (rich) muti-users aware "tool", no need to use an
intermediate like a Web Browser to connect it to your database. Or can you
consider to use Terminal Server, for your "clients"? Sure, that means your
application is two-tiers, or, in Access words, a 'split application, with a
front-end (for the end users) and a back-end (for the data itself).


Vanderghast, Access MVP

 

[Sylvain Lafontaine]

The only tool that I've heard of is
http://dbconvert.com/convert-accessforms-to-web-mysql.php and it doesn't
convert to ASP but to PHP. IMHO, the fact that PHP is used instead of ASP
shouldn't be a problem because most providers offer it and if you have your
own web server, it's pretty easy to set up. BTW, don't forget that ASP is
now deprecated and has been replaced with ASP.NET. (Don't think that
because they share the same three letters that ASP.NET is a close brother to
ASP. In fact, somebody could even argue that there is more difference
between ASP and ASP.NET than between ASP and PHP.).

However, I never tried this product myself so I cannot give you any
recommendation about its real capabilities.

 

[Sylvain Lafontaine]

Also, you have made a mention of a MDE file instead of a MDB file. I
suppose that it's an error; however, if it's not and you are really talking
about a pre-compiled MDE file than you'll have even more trouble trying to
find a product capable of converting it to a web application.

 

[Sylvain Lafontaine]

Sorry, posted to the wrong sub-thread! My previous message was a follow-up
to my other answer.

 

[Jasmine]

So what you guys are saying in a nutshell is -

There's no way -

No way at all ?

I'm amazed with all our Technology Ingenuity that there's isn't a single
solution to my problem

I'm definetly doomed.

 

[Sylvain Lafontaine]

Oh sure, there is a way: using your own 10 little fingers.

BTW, you didn't describe in full the exaction situation with your clients
but if there is only a handful of them who want to access the application
then it's possible that using a remote client connection over a VPN such a
Terminal Service or Thinsoft could be a solution to your problem.

Using TS is the most common solution of accessing an Access application over
the WAN.

 

[mscertified]

You will have to completely rewrite the application in ASP or ASP.NET which
is a completely different technology. Ideally your database should not be Jet
but be a real database like SQL server.
Try Googling Access and Web, you will find lots of products that claim to be
able to webify Access applications.
If you needed a web application, you really should not have developed it in
Access in the first place.

-Dorian

 

[Rick Brandt]

So what you guys are saying in a nutshell is -

There's no way -

No way at all ?

I'm amazed with all our Technology Ingenuity that there's isn't a
single solution to my problem

I'm definetly doomed.

Given that it takes about one tenth the time to develop a sophisticated
Access app compared to a sophisticated web app that works against a database
don't you think that if such a conversion tool existed that every web
designer would be building their pages with it?

What you are talking about is not some trivial tool that no one has bothered
to crank out yet. If it existed and worked well I suspect it would become
THE way to develop web based database applications and it would make the
creator very wealthy in no time at all.

There's a reason that good web developers make good money, because it's not
a simple task.

 

[Michel Walsh]

Jet not a real database? says who?


Vanderghast, Access MVP

 

[Jasmine]

Thank for your thoughts.

I've decided to VPN into the application

The need to webify the Access application was only thought of yesterday by
management,

 

[Albert D. Kallal]

So what you guys are saying in a nutshell is -

There's no way -

No way at all ?

I'm amazed with all our Technology Ingenuity that there's isn't a single
solution to my problem

You can deploy and pump out your application to a web site without rewriting
one line of code, and the application can be used for many windows computer
with a web browser.

Your problem is your specific question was to convert an access applicaton
to ASP, and that is a mountain Everest, grand canyon, large, humongously
differnt question then wanting to use your applicaton over the web.

You can most certainly run your application through any web browser anywhere
on the Internet and you won't have to rewrite one line of code or modify
your application one bit. You simply have to use windows terminal services
and Microsoft's Internet services together.

deploying your application into a web browser is in a completely different
question than having something that magically we write all of your code into
ASP. So, sure you can deploy your application to a web browser, but that has
absolutely no relationship of any kind to the actual question to you
asked...

I talk about and give some thoughts on some other additional solutions that
you can use to to deploy and use your access application over the Internet
here:

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

 

[mscertified]

I suppose we cannot expect management to think more than one day ahead!