Sharepoint lists are a poor choice for an Access BE since they are not a relational database. If your tables are limited to a few thousand rows and you don't nee anything except very basic RI, you'll probably be fine. But there are better ways to use Access over the internet. Citrix is the best.
Could not agree more. To get them to behave optimally, I had to de- normalize my three main tables which was on the verge of malpractice.
However, I work with a classified government system that is so locked down that installing new software is virtually impossible. I asked about the possibility of SQL and Citrix, two systems the gov already uses and although there IS a procedure in place to obtain the service, it takes an act of congress and about 3 years to bring about. Madness.
But I was pleasantly surprised by the speed and efficiency of the Access 2010 Caching feature(s). My table structures are abismal but only I know it. One of my remote activitys is in the Middle East while the server is in Italy...we are able to share the same BE without significant latency.
There are some issues with connectivity and I do have to "get under the hood" to fix mutated records from time to time but it is much better than the system we had.
Hopefully the approval for Citrix services will come through before I leave, otherwise, the poor fool who has to come behind Me and clean up my mess is going to have to do it...