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

x
?
Solved

Major project in access

Posted on 2011-03-24
6
Medium Priority
?
287 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 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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 

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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

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