Hi,
I have a split database that has approx. 12-15 users. The main table in the back-end is almost 1.8GB and I know access has a 2GB limit. One option I have thought of is creating 2-3 more back-ends to get my max storage up to 6-8GB and then union the tables and funnel them back into the front-end, the users would use the tool the same way, but I wanted to know if publishing the main table (1.8GB) to SharePoint would allow me to circumvent the 2GB max?
thanks!