Search code examples
ms-access-2010

Easy Way to split up a large Table in MS Access

I have a table in a MS Access 2010 Database and it can easily be split up into multiple tables. However I don't know how to do that and still keep all the data linked together. Does anyone know an easy way to do this?

Solution

  • I ended up just writing a bunch of Update and Append queries to create smaller tables and keep all the data synced.