Accessing MS Access Application through the Web

[Guest]

Hello,

I have created an MS Access Application with forms, queries, reports etc...
Now the customer wants all users to be able to use the application from
their homes via the internet.

I was wondering if someone has an idea where I should start?
Can you point me to a place on the net I can learn more about putting an MS
Access Application on the net?

Thanks in Advance

 

[Norman Yuan]

The general meaning of "access via the Internet" is to use a web browser to
access a web resources, mainly, web pages (static pages like *.html, or
dynamic pages like *.asp, *.aspx...). In this sense of Internet access, no,
you cannot use MS Access App via the Internet.

On the other hand, you can set up VPN via the Internet so that a remote user
can connect to the LAN where the Access DB located, as if he is in the LAN.
But, the connection speed may make the app totally useless.

So, basically, if you want to make your data available on the Internet, you
need re-write a web app, using ASP, ASP.NET, or other web app technology.
Even the database itself may need to be convert to a more robust database
engine (Access DB, or Jet DB is not suitable or web application in general,
unless you have fairly low traffic).

 

[Guest]

Oh Wow... did not think it would be that complicated

Would PHP do the job to or just ASP?
I don't know either but just was wondering if I have to learn one of them
anyway, which would be more usefull?

--
Blessings,
MM Spirit Guide
http://www.MMSpiritGuide.com

The general meaning of "access via the Internet" is to use a web browser to
access a web resources, mainly, web pages (static pages like *.html, or
dynamic pages like *.asp, *.aspx...). In this sense of Internet access, no,
you cannot use MS Access App via the Internet.

On the other hand, you can set up VPN via the Internet so that a remote user
can connect to the LAN where the Access DB located, as if he is in the LAN.
But, the connection speed may make the app totally useless.

So, basically, if you want to make your data available on the Internet, you
need re-write a web app, using ASP, ASP.NET, or other web app technology.
Even the database itself may need to be convert to a more robust database
engine (Access DB, or Jet DB is not suitable or web application in general,
unless you have fairly low traffic).

 

[Norman Yuan]

PHP and many other tools do the job (web app). But, again, Jet DB may not be
suitable for web app, accessed via the Internet, depending on how many
users, how the app designed, and how the security should be... (but do get
me wrong, it can be used in some cases). Server type DB is always favorite
on the Internet (SQL Server/MSDE/MySQL...).

Oh Wow... did not think it would be that complicated

Would PHP do the job to or just ASP?
I don't know either but just was wondering if I have to learn one of them
anyway, which would be more usefull?

 

[Albert D.Kallal]

Oh Wow... did not think it would be that complicated

Would PHP do the job to or just ASP?
I don't know either but just was wondering if I have to learn one of them
anyway, which would be more usefull?

You can deploy the application to users on the internet. If those users are
not "general" users, but employees, and people who "KNOW" the application,
then you can set up remote use of that application, and this can occur
across the web, and you do NOT have to re-write one line of code.

I explain how do do this here:

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