Any Sharepoint users here?

[cdoyle]

Hi,

Just wondering if there are any Sharepoint users here, that are using Access in their sites?

Since Access 07 removes data access pages, I've been trying to find another way to display data from a exisiting database on our intranet.

We are using Sharepoint, and I think this is going to be my only option.

Here is the problem, Sharepoint does not seem to really support relational databases. I have a table that uses lookup tables, and I can't seem to get the actual data from the lookups, to display in Sharepoint.

So basically when viewed from Sharepoint, the users just see the numerical entry instead of what the actual data is.

I did find this
http://workerthread.wordpress.com/2009/02/03/using-access-2007-to-update-sharepoint-lists/

but basically, they are making the lookup be at table level it appears. That is normally looked down at isn't it? Causes problems or headaches later on?

I just can't believe there is no way to just make a query in Sharepoint to pull the data together and display it.

anyone have any suggestions?

 

[KenHigg]

I found this:

http://databases.about.com/b/2007/11/06/using-sharepoint-with-microsoft-access.htm

Haven't had a chance to read it but sounded like it may help...

 

[cdoyle]

I found this:

http://databases.about.com/b/2007/11/06/using-sharepoint-with-microsoft-access.htm

Haven't had a chance to read it but sounded like it may help...

I've seen these, but don't think it solves my problem.
I could create a 'access view' but that just creates an 07 database that the user I guess downloads to view reports or something.

Most users here only have 03 so that wouldn't work anyways.

I wish Access didn't discontinue Data Access Pages, they've been working great for this for the past few years.

 

[Pat Hartman]

If your users can live with day old data, copy the data they need and de-normalize it so that no lookups will be needed. I wouldn't use sharepoint as my database for an OLTP application since it doesn't support RI and is very limited in the number of rows it can process at one time.

 

[Simon_MT]

Instead of putting a god damn ribbon on Access 2007, what we really want is a good to translate Access to the web. But that would be useful, rather than a ribbon that is as useful as a "fanny full of cement".

Simon