Therefore, many techniques you may have picked up in optimizing your operations with linked tables may be inapplicable and we need to consider new ones. I’ve said it before and I’ll say it again: SharePoint is anything but a true relational database. There are some key differences between the two we will discuss later in the article.Īs linked tables go, SharePoint Lists are definitely a horse of different color. Therefore, if you know something about them, you’ll also know something about web tables.
If you’re using the new web database with Access 2010, the “web tables” are in fact SharePoint Lists by a different name. Now we’ll examine the main object you’ll interact with SharePoint within Access: Lists. In a recent post, I discussed how SharePoint and Access address similar audiences and provide easy solutions to different problems. Note: This is the second part of a three part series, you can find part one here and the third part here.
BEST WAYS TO USE SHAREPOINT SOFTWARE
Microsoft Access Database Inconsistent State Error.