My company is running a
Sharepoint 2010 enterprise site.
Middle of last year, I was tasked
with creating a web based user interface for an access database that has been
in use for 10 years. I converted the database to 2010 web format, generated the
forms, queries and tables to make the application function. Upon publishing the database to Sharepoint, we
ran into problems with the application.
Some of the problems:
refusing to load and tossing an error
Access services unavailable to process the request errors
extremely slow to process requests.
We contacted Microsoft in
November to get assistance. Finally in late February, we found someone with the
access team who told us that the database was too complex for access services
and that I should be creating a fully qualified web app with asp.net. I am now
looking into this approach.
Here’s what I want to do. Since
the data currently resides in sharepoint, I want to leave it there such that my
web app and the old client database that some people still use, can access the
data in one repository. To achieve this, the client DB, will use linked tables
that point to the sharepoint lists. I will create a similar access database that
points to the sharepoint lists which will be manipulated by asp code. I will
add this application to the sharepoint server such that the application is
available to users via intranet.
So far I’ve figured out how to
create a web application under IIS and set it up with a separate appPool such
that it will work for my users.
Where I need assistance:
When I created the original
access services application, I was able to use a variable (CurrentWebUser) to retrieve
the current sharepoint user that is logged in. I was then able to build my application upon
that login and have it do different things for different users. Now that I am
attempting to recreate the application in ASP, I do not directly have access to
the sharepoint login information.
I did some research and figured
out that I could create a page of asp.net code that would use the sharepoint
object model to return the currently logged in user. ( http://www.fewlines4biju.com/2011/01/how-to-get-user-profiles-details.html
) I could then pass this value to the new web app that I am building. The
problem is that I am not versed in .net development. I’ve been focusing on classic
asp since the hosting company my company is using, does not provide access to
Can someone point me to a good
primer on .net programming that would be able to teach me to create some .net
code that would run inside a sharepoint page?
Yesterday, due to my deficiency in
the user dropdown menu on the page. I got it to work, but the .js file failed
to execute for all users except site administrators and then only in Internet
explorer, not in Firefox or other browsers.
What is the best approach?