Resources for Publishing Access Database to MOSS 2007

Posted on 2010-11-15
Medium Priority
Last Modified: 2012-05-10
I have an Access 2007 database which I set up because a standard list on my MOSS 2007 site is not flexible enough to create complex relationships. Here's my problem. The database looks lovely, but I am having a hard time figuring out how to publish it to SharePoint. I mean I picked publish and pushed the tables from Access to the site, but what I am really look for is some resources I can read which will give me the details about the implications of tying an Access 2007 database to a MOSS 2007 site. I have a bunch of books, but none of them goes into enough hardcore detail. Does anyone out there know of a real reference on the subject? I would really appreciate a link or a book title or something. I'm dying here. :)
Question by:smsdesigns
  • 4
  • 3
LVL 75
ID: 34140502
Just wondering if you are aware of the many new features in A2010 and Sharepoint 2010 ... that might improve the situation ?


Author Comment

ID: 34140512
Yes I am aware but unfortunately, my company is locked in on the 2007 versions with no formal plans to go to 2010. Sigh...
LVL 75
ID: 34140527
Sorry ... I don't have the answer for you ...

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

LVL 75
ID: 34140542
Guess I will pass this along anyway:

Access 2010 Resources:

Maybe you can .., 'unlock' the thinking :-)


Accepted Solution

smsdesigns earned 0 total points
ID: 34140585
Unfortunately, it is a very big company and the decision is way out of my hands. I have to make due with the tools I have.

Author Comment

ID: 34346648
I agree with myself. :)

Author Closing Comment

ID: 34387568
There is no real solution and I didnt know how to close my question.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

624 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