Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds


  Asked By: Jena    Date: Aug 10    Category: Sharepoint    Views: 664

I have an Access 2003 database with 52 tables in it. (This is all
Quickbooks info exported to Access real time via a 3rd party app) I want to
link 2 of the tables to my WSS site. Sales reciept and Invoice. That's it!
The rest of the tables are irrelevant on the WSS site for the most part.
When I follow the link tables wizard in any of the three books I have
from microsoft, Access inside out, frontpage inside out and Sharepoint
products and Technologies, it only shows one table in the database to link:
"all items". I get to a point where I can link the table to the list and all
is well. I exported the two tables to the site list and so far so good.
Now, when I use the link tables to list wizard it only shows one table! "All
Items" and this table is empty.
Is there a simple way to manually select the tables I want to link to the
lists or do I have to do something differently?

Does anyone have experience linking Access databases to WSS 2003 and would
you help me out on or off list?



2 Answers Found

Answer #1    Answered By: Pramod Jituri     Answered On: Aug 10

I am facing the need to link an Access DB as well. If someone has the
answer, please share with the group or include me in the off-list

Answer #2    Answered By: Daya Sharma     Answered On: Aug 10

Maybe we can work together on this one, I'll be putting a few hours into it
today and feel like I'm pretty darn close.. The only problem i'm having is
selecting the correct tables to link to the sharepoint list since there are
52 tables to choose from and the wizard only shows 1 table to link in the
database "All Items".

I'll slap together a diagram of my efforts and post a link to some
screenshots here in a little bit.

Didn't find what you were looking for? Find more on Access Or get search suggestion and latest updates.