Access Upload to Sharepoint List

Copper Contributor

Please help. I'm extremely frustrated with above functionality. I created frontend in access which works as local files and then uploaded to Sharepoint. There are MANY frustrating things that just don't work, but I'll start with one. I'm posting here as I got no responses from two Access groups in 3 days. I've been working for 10 days to try to solve this problem.

 

My tables/relationships are as below

Screenshot 2023-10-21 114037.png

 

After uploading, the keys (primary and foreign) are changed. It appears the foreign stay, but the some of the primary's are gone. For example, Access above shows a pk of Call.ID. Sharepoint shows below

Screenshot 2023-10-21 112937.png

 

Notice no ID! Also, when i look at the indices

 

Screenshot 2023-10-21 114510.png

 

Notice - NONE! 

 

When using vba to reference the key, I get

 

Screenshot 2023-10-21 111719.png

 

 

This happens after typical vba me.dirty=false which instantiates a key for a new record!

 

Screenshot 2023-10-21 115000.png

 

What the heck IS MICROSOFT DOING? Does anyone use this functionality? I'VE BEEN WORKING ON THIS FOR WEEKS AND HAVE NOTHING BUT PROBLEMS!

 

please help

 

Lex

0 Replies