Solved

Major project in access

Posted on 2011-03-24
6
270 Views
Last Modified: 2012-05-11
I have been asked to take oour database that we have to  our intranet.  The major developments that I have to do are these.
1.  Create a logon for users to sign on and enter the database thru our intranet.
2.  To allow users to see only their data when they sign on.
3.  Users should be able to run reports out of the database when they signon, (of course the reports should be for only their data), by use of buttons or links.

Could someone please advise me on how best to tackle this.

We have sharepoint in our establishment.  Dose that make a difference?

All this will be done on MS Access 2010.

Thanks
0
Comment
Question by:Kdankwah
  • 4
  • 2
6 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 35206751
<<All this will be done on MS Access 2010>>

 You have a couple of options:

1. Don't use Access.  Write the app in something else, like ASP.net

2. Use Access 2010 with Sharepoint and create a web database.  This requires Access Sharepoint Services, which is part of the Enterprise Edition of Sharepoint.  It is a costly option.

3. Use the services of something like www.eqldata.com

JimD.
0
 

Author Comment

by:Kdankwah
ID: 35206800
But the database is in Access already.  Does that make a difference?   I also have Alpha 5 software.

Thanks
0
 

Author Comment

by:Kdankwah
ID: 35206910
Where can I get asp.net?

Thanks
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:Kdankwah
ID: 35206946
By the way, you mean I cant run MS Access in a browser?
0
 
LVL 57
ID: 35207274
<<But the database is in Access already.  Does that make a difference?   I also have Alpha 5 software.>>

   If you want to stick with Access, your options are limited to the ones I listed, plus one other, which I discuss below.  I know nothing about Alpha 5 and can't help you there.
 
<<Where can I get asp.net?>>

  http://www.asp.net/

  and understand that using ASP.net means a total re-write of the app.

<<By the way, you mean I cant run MS Access in a browser? >>

  Not on it's own, no.

  You can use a service like www.eqldata.com, or you can setup a terminal services server, with Citrix on top, and run it in a browser that way, but your really not running it as a web app.  All you have is a window to a remote terminal session through a browser.  From the users viewpoint however, they are running the app "in a browser".

   Your other option is a Access 2010 web database with Sharepoint Enterprise and Access Services, but as I said that's costly and there are restrictions on what you can do within a web database that will be published to Sharepoint.  

   For an app that is already written, www.eqldata.com or RDP/Citrix are it.

JimD.



0
 

Author Comment

by:Kdankwah
ID: 35207331
This is alpha 5 software. Its very robust. Www.alphasoftware.com
Thanks
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

757 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now