Solved

Major project in access

Posted on 2011-03-24
6
278 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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