Microsoft Access 2003 as Back-End and Web Interface

I have 20 Team Members who are using a MS Access 2003 database application on Windows XP sp2. I designed this application 2 years ago and till date the application is working like a charm. Now as per our requirement we need to access our application across the country and this seems a challenge to me. Therefore, I need help from the Experts.

The functionality my application is currently performing are as below:
1) LogIn Authentication: Users needs to login with their login credentials---> after logged in they will be re-directed to the main page. At the back-end User Permission is also defined so users will be able view tasks as per the permission is defined.
2) Users will be able to enter, save, edit records.

Now my questions are below:
1) What tools/softwares I need to create this kind of application?
a) When I am testing this at my Windows XP sp2 client.
b) When I am publishing my finished application to the web?

2) Is this possible with Adobe Dreamweaver (I am familier with languages like ASP, PHP)?

3) Is this possible with MS Access 2003 Data Access Page?

4) Is my web server needs to support MS Access as database back end?

Any help with this is much appreciated. Thank you.
LVL 9
suvmitraAsked:
Who is Participating?
 
Gustav BrockCIOCommented:
OK:

1) Can be done, of course, but hard work if you don't know how.

2) Fine for 20 users, despite that many will tell you otherwise.
Visual Studio works fine with Access database.

3) I prefer C# and ASP.NET but lots of other options are available and will work fine as well. Matter of taste and other experience. But Visual Studio rocks.

No one can tell you "how", you will have to learn.

For a simple app, however, you may be able to short-cut the entire project by using a tool like CodeCharge. A free trial is for download:

http://www.yessoftware.com/products/product_detail.php?product_id=1

/gustav
0
 
Gustav BrockCIOCommented:
Now, you don't tell how many users but a fifth option which requires zero development costs/time is to use er terminal server solution.
This one is easy to set up (Microsoft Terminal Server is not):

http://www.thinsoftinc.com/index.aspx

Also, your option 3 is to stay off by all means.

/gustav
0
 
suvmitraAuthor Commented:
Hi gustav,
I am sorry for the missing information. Now, here is my requirement:
1) Back-End : Microsoft Access 2003
2) Web based Front End (User may use Internet explorer and Mozilla); (How do I create this? What is the good tool for creating this type of web application?)
3) Users: Probability 20 users may try to login to the application at the same time by entering the URL at the address bar or they may click on a link which will redirect them to the Login screen of the application.
4) This would be a globally accessible tool like this one:
https://replicon.nar.capgemini.com/cgi/rt.exe
5) I need a step by step guide to create a web based application where I can use MS Access 2003 as Back-End.
Appreciate your help on this.
Regards,
Suva
 
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Gustav BrockCIOCommented:
I would use Visual Studio for this:

http://www.microsoft.com/Express/

As this will be a complete rewrite of your application in ASP.NET, there is no step-by-step guide other than to learn and understand the tool and then recreate the functionality of your application.
A login screen, however, is easily build - it is a standard feature of VS.

/gustav
0
 
suvmitraAuthor Commented:
Thank you Gustav,
I am open to try for anything to resolve this. Please concentrate on my primary needs.
1) I want to re-create the solution by my own.
2) I will be using MS Access 2003 as my back end.
I am basically lost here because of my lack of knowledge on publishing my MS Access database globally.
I need someone to help me out by providing me certain answers like..
1) Is it possible to use MS Access 2003 as my web server back-end?
2) Tell me a good server side language / tool (ASP.NET; PHP) / (Visual Studio/ Dreamweaver) which can solve the purpose.
3) If somebody is already experienced with publishing MS ACCESS globally then please help me out with the blue print.
/Suva
0
 
suvmitraAuthor Commented:
Gustav, you are EXCELLENT!
I will try with CodeCharge. I have already used visual studio 8. I used IIS 6.0 as my local server and my web application works fine with SQL Server. But as I stated earlier I have not worked with MS Access neither I tried to put the application into web.
However, The CodeCharge seems good to me I will try for it. But I am actually more interested to know about a tutorial/blog/self-paced training material which may guide me to create this kind of web-application.
Is there any existing solution you aware of where end users are doing data entry in a web interface and the back end is MS Access?
Thank you,
Suva
0
 
Gustav BrockCIOCommented:
Oh, so many sites and resources ... but do start here:

http://www.microsoft.com/learning/vstudio/2008/default.mspx

with so much free stuff (videos are good for starting) that you can be kept busy for a couple of weeks or more!

/gustav
0
 
suvmitraAuthor Commented:
I really appreciate Gustav,
I'll definitely find time and go through all. At present everything I found is seems "Hard Way" but my search is for someone who already worked with the idea "Microsoft Access as Back End and Web Interface to connect the database". Thank you for your help, you are the one who is continuously trying to help me out. I need to submit this project within next two weeks so please get in touch and help me out any way. In the mean time I will also use this thread for more help.
/Suva
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
 
suvmitraAuthor Commented:
Hi All!
Is there anybody to help me out with the process / guideline?

Appreciate your any help on this.

/Suva
0
 
suvmitraAuthor Commented:
CodeCharge is good. With this I may have a try.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.