Dealing with the Access 2003 255 field limit on tables.

Quite often I've had the misfortune of having to create Access applications. If you're reading this then you understand the problem with the 255 field limit. The best way I've found to combat this is to create a view in Excel using the External Data tool, then turn the query I use for that into an OLAP cube, then set the cube to auto-refresh when opened. The problem is that you're limited to 65,536 rows of data, so you may have to make several of these.