Solved

Major project in access

Posted on 2011-03-24
6
274 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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…
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…

816 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

10 Experts available now in Live!

Get 1:1 Help Now