Major project in access
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Where can I get asp.net?
Thanks
Thanks
ASKER
By the way, you mean I cant run MS Access in a browser?
<<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.
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.
ASKER
This is alpha 5 software. Its very robust. Www.alphasoftware.com
Thanks
Thanks
ASKER
Thanks