Sharepoint Linked Tables (1 Viewer)

PhysioWizard

New member
Local time
Today, 08:19
Joined
May 16, 2014
Messages
1
I have a sharepoint site that is used for my company. It contains 130 tables (aka "lists"). I have successfully linked those tables in Access to run reports off of. My issue is two-fold:

First, the linked tables do not display the "Name" and "Type" field. I had an issue where the sharepoint defined these as "Multi-field" columns and when I used VBA code to append to table I got a -3025 (?) error. I had to go back and chang them to "Single line" text.

Second, if instead of linking them, I pull them in as static tables, the name and type fields come across fine (great!) but I lose 3 other columns. These 3 columns are present if they are just linked.

We don't have an IT department that can help, and the internet has been less than helpful. After 4 hours of slamming my head against the wall I am hoping that someone else can share their wisdom in this area. I understand VBA to a very limited extent (though I am learning).

Thanks in advance,

Josh
 

Users who are viewing this thread

Top Bottom