[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Microsoft Access 2003 as Back-End and Web Interface

Posted on 2009-02-23
11
Medium Priority
?
1,192 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:suvmitra
  • 6
  • 5
11 Comments
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 23719365
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
 
LVL 9

Author Comment

by:suvmitra
ID: 23719767
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
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 23719977
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Author Comment

by:suvmitra
ID: 23720175
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
 
LVL 52

Accepted Solution

by:
Gustav Brock earned 1500 total points
ID: 23720295
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
 
LVL 9

Author Comment

by:suvmitra
ID: 23721352
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
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 23722095
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
 
LVL 9

Author Comment

by:suvmitra
ID: 23723061
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
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 23723270
You are welcome!

/gustav
0
 
LVL 9

Author Comment

by:suvmitra
ID: 23729115
Hi All!
Is there anybody to help me out with the process / guideline?

Appreciate your any help on this.

/Suva
0
 
LVL 9

Author Closing Comment

by:suvmitra
ID: 31550458
CodeCharge is good. With this I may have a try.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question