August 30, 2008 03:29am pdt

Member Login

Hall of Fame

Yearly

1Robbie_L... 475,766
2tedbilly 444,395
3zephyr_hex 267,670
4liebrand 178,599
5cobrachen 170,815
6Pillalamarr... 128,090
7clayfox 121,425
8moss_guru 119,545
9NBSO_ISS 109,825
10cmv131 86,525
11DaleHarris 73,731
12adaco 72,330
13TechSoEasy 64,675
14rich_0794 63,150
15JamieMcA... 60,250
16ApexCo 58,135
17zell71 55,445
18whoajack 47,120
19bhanukir7 39,100
20Addihul 34,475
21furu 32,700
22tnorcross 27,350
23vivekthan... 22,800
24olca02 20,580
25gamesmei... 19,350

	[x] Attachment Details

Connecting Sharepoint to existing Access Database

Zone: MOSS-Sharepoint

Tags: sharepoint, access, database

We have an in house Database created in Access that we would like to have connected to a sharepoint web site that we are creating. We have a factory that needs to get some information out of the access database in a timely fashion and sharepoint seems to be the best way to get them the information that they need. I have not been able to find out how to get my current access forms and reports to show in sharepoint. I can see how to get a sharepoint list to become an access table, but can't find out how to do the reverse of that.

In essence what I am looking for is a way to show an access report or form in sharepoint. If neither of those are possible then a query would work fine so long as it queried current information in the database.

Just to rule out a couple of options, for some security reasons we do not want to have microsoft office installed on the computers that the factory workers will be using. We also have been using sharepoint for a short time as an internal messageboard and the factory guys are getting used to the look and feel of sharepoint, and we do not want to add any extra complexity to their setup as most of them are fairly computer illiterate. I also do not want to have to create a table or list in sharepoint and push it to access, because we have 10 years of data in the access database and it would be time and cost prohibitive to recreate that information. We need to keep the existing data that is in access and simply have it show in sharepoint.

Thanks for any help!

Start your free trial to view this solution

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.8

Question Stats

Zone: Networking

Question Asked By: VoodooFrog

Solution Provided By: zephyr_hex

Participating Experts: 3

Solution Grade: A

Translate:

Loading Advertisement...

Open Discussion

Comment by PHESupport

Zephyr ,

I have the same situation as VoodooFrog and iam trying to acess the url wssdemo.com. I could not because its asking for credentials. Could you please send me the link.

Thank you,
Raj.
raj.kalgara@phe.com

20080723-EE-VQP-34