Access 2010 Fe Sharepoint/office365 Be, This Recordset Is Not Updatable?

[Garindan]

Hi all, I have just finished moving a small company database to Office365/Sharepoint and was pleased I accomplished it Updated the backend to make it web compatible, linked the front end to sharepoint lists etc.

I was getting ready to hand it over for use and have found a couple of 'major' problems

First, it's REALLY slow to access data. Secondly when the data is open any attempt to change it comes up with 'This recordset is not updatable' in the status bar, and makes that little sound you hear when things aren't working/allowed. Any ideas?

I thought access 2010 and sharepoint 2010 were meant to make local copies and sync to speed up data access but it doesn't seem to be the case, have I missed something?

Cheers for any help!!! Quite stressed now

 

[Garindan]

Any idea's on this?

I was wondering if it might be something to do with my relationships? I'm a little confused about those. The database was split a year or so ago and after splitting the back end had relationships and the frontend also had relationships?

I have found that I can create a blank web database and import the tables with no relationships and no lookups, just separate tables, and then using the front end it still all works. Is this right? Is it because of the front end relationships? And how might that affect a sharepoint database?

The tables I had uploaded and tried, and that were uneditable, had lookup relationships added to them. But now I'm confused about what relationships I need and where lol