How to change an written access program to a a web application?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I've started my new job about 1 and 1/2 mnths ago, there is an written
access application , and here is University with 20000 employees and now I
have to install and debug this application for thousands of clients inside of
my work, actually it is a system tracking for Vacation and Personal Hoilday
and Sick times of employees.

Is it possible to change an written access program to a a web application?

I want each client can pull up their own employees from accessing to this
application(New one written by me) through the internet.

What should I know for internet programming?

This program does not have primary and foriegn key, no relation between
tables, and not user friendly.

This University bought from Oracle company a lot of software, like Employee
self service application, I don't know if I am able to change this Access
application to Oracle database and programming.

I want this application can be accessed through the internet to all clients,
so I don't need to install individually on each machine.

Can I do it in Access or PLSQL(Oracle) or VB.Net or ASP.Net or Java and Java
Script?
This place is a university and offer most of those above classes.

Please advise me.
Thanks
Tara
 
hi Tara,
I've started my new job about 1 and 1/2 mnths ago, there is an written
access application , and here is University with 20000 employees and now I
have to install and debug this application for thousands of clients inside of
my work, actually it is a system tracking for Vacation and Personal Hoilday
and Sick times of employees.
How important is that application?
I want this application can be accessed through the internet to all clients,
so I don't need to install individually on each machine.
Can I do it in Access or PLSQL(Oracle) or VB.Net or ASP.Net or Java and Java
Script?
You can't do it in Access or PLSQL. The others are platforms offering
web solutions.
This place is a university and offer most of those above classes.
Ask the information science department.


mfG
--> stefan <--
 
Where will the app be hosted? Will you be free to set up your own server or
choose your own hosting service, or will you be required to use an existing
server or hosting service? Probably the University will expect you to use
their existing servers, yes? If so, you need to talk to your administrative
people to determine what technologies are available to you. There's no point
in spending your time developing an app that depends on a specific
technology only to find that the app is expected to be hosted on a server
that does not support the chosen technology.
 
Stefan Hoffmann said:
hi Tara,

How important is that application?
It is very important.
You can't do it in Access or PLSQL. The others are platforms offering
web solutions.
So if I take ASP.Net or Java classes they will teach me which database I have to use for my web application?
Ask the information science department.


mfG
--> stefan <--
 
Yes they have their own existing server, and I asked them already and
unfortunately they could not help me. Probably I should rewrite this
applicatin in Access and then go to some classes and then make a descision
regarding web application.

But any way thanks for your advice.
Tara
 
Well, if you were planning on replacing the Access app with a Web app in the
short term, I would not recommend rewriting the Access app - there's no
point rewriting something that you're about to replace. But it sounds as
though the Web app may be a long-term project, and that you may continue to
use the Access app for quite some time, so in that situation it may be worth
rewriting or refactoring the Access app.

In the meantime, check out Terminal Services and Remote Desktop as an
alternative means of providing users with remote access ...

http://technet2.microsoft.com/windowsserver/en/technologies/featured/termserv/default.mspx

In the longer term, though, in order to have any chance of success,
regardless of whether you use a Web app or Terminal Services, you are going
to need the help of the people responsible for administering your
organisation's servers. If they can't or won't help you, there's no way the
project is going to succeed. It would not be surprising if they were a bit
hesitant. Protecting the servers is, after all, what they get paid for. You
might find them more forthcoming if you can get someone who has been with
the organisation longer and has more experience of developing server-based
applications involved in the project.
 
Back
Top