?
Solved

Major project in access

Posted on 2011-03-24
6
Medium Priority
?
281 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:Kdankwah
ID: 35206946
By the way, you mean I cant run MS Access in a browser?
0
 
LVL 58
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

770 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