Forum Discussion
Export and Link Access Query to SharePoint Online
I guess we have to agree to disagree. At this point, I've seen three screen shots and no SQL and I'm unable to even hazard a guess as to what your problem is. You've failed to be specific about the actual problem other than that it's about 75% there or something to that effect.
You want to create a new SharePoint list from a query? And have that List be updateable? That's something I'd have to SEE to be able to comment on at all.
One last attempt, though. If you can provide a copy of the accdb with enough sample data to work with and see what is supposed to happen, I could try to explore it, but in the absence of specifics, it's not possible. I'd also need that SQL from that Query, and no just a screen shot of the tables in the designer.
So 45 minutes later trying several times to simply upload a db for you. Last thing I'm going to try before closing shop and completely moving away from all msft products. I attempted to rename the db SyncTest.jpg so you could rename it to SyncTest.accdb. Did that work?? Nooooo. It's only 616KB
As a database:
- The attachment's synctest.accdb content type (image/jpeg) does not match its file extension and has been removed. Then renaming to .jpg
- The attachment's synctest.jpg content type (image/jpeg) does not match its file extension and has been removed.
This is crazy, I give up with this nonsense. See, no matter what you try to do there's always a Microsoft fly in the ointment. Thanks for trying to help but that proverbial wall has shown up yet again.