By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,903 Members | 2,042 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,903 IT Pros & Developers. It's quick & easy.

Access 2007 and SharePoint 2007 linking issues

P: 4
Hi, I created an access database with cascading combo boxes with the information for each combo box stored in separate tables. I wanted to put the database on SharePoint 2007 but when I put it up there, it made me get rid of my primary key and it inserted it's on "ID" primary key. Now instead of getting the text from the tables to populate the combo boxes, it get's the ID number. I have tried several things to get around this such as accessing the specific column (tbl1.Columns!Name) that i needed from the table. There seems to be no way to change the primary key or delete the "ID" field. I even tried using SQL statments to get the particular column from the list. However i have had no luck. Is there anyone who may be able to help me with this?
Feb 16 '07 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,492
I can't help off the top of my head.
Perhaps you could provide an example of what the old version does and what the new version does. The SQL of the ComboBox would be required and an explanation of exactly why the new results you get are not right.
Feb 18 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi, I created an access database with cascading combo boxes with the information for each combo box stored in separate tables. I wanted to put the database on SharePoint 2007 but when I put it up there, it made me get rid of my primary key and it inserted it's on "ID" primary key. Now instead of getting the text from the tables to populate the combo boxes, it get's the ID number. I have tried several things to get around this such as accessing the specific column (tbl1.Columns!Name) that i needed from the table. There seems to be no way to change the primary key or delete the "ID" field. I even tried using SQL statments to get the particular column from the list. However i have had no luck. Is there anyone who may be able to help me with this?
The only thing I can think of is to remove the primary key designation from the primary key and let it get imported as a normal field. Then set the combo box bound column to this key instead of the new primary key.

Mary
Feb 18 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.