topic Re: Personal geodatabase w. geometric network maxed out a 2GB in Data Management Questions https://community.esri.com/t5/data-management-questions/personal-geodatabase-w-geometric-network-maxed-out/m-p/721722#M40929 <HTML><HEAD></HEAD><BODY><SPAN>The max size of an access .mdb file is 2GB, but as it gets close to that limit performance will most likely be poor so moving to a file geodatabase would be a good idea anyway.</SPAN><BR /><BR /><SPAN>If the pgdb has been frequently edited, one thing you could try would be to run the compact tool on it.&nbsp; This should reduce the file size and may allow you to proceed.</SPAN><BR /><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//003n0000007t000000.htm"><SPAN style="text-decoration:underline;">compact</SPAN></A><BR /><BR /><SPAN>Make a back up of your geodatabase, then run the compact tool.&nbsp; See if you still get the error.</SPAN><BR /><BR /><SPAN>As for migrating to the file geodatabase, you can copy and paste the data from the pgdb to the fgdb.&nbsp; </SPAN><BR /><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//003n00000036000000.htm"><SPAN style="text-decoration:underline;">copy</SPAN></A></BODY></HTML> Tue, 21 Sep 2010 22:50:16 GMT IanWittenmyer 2010-09-21T22:50:16Z Personal geodatabase w. geometric network maxed out a 2GB https://community.esri.com/t5/data-management-questions/personal-geodatabase-w-geometric-network-maxed-out/m-p/721721#M40928 <HTML><HEAD></HEAD><BODY><SPAN>I have been mapping a stormwater system using a personal geodatabase that was setup with a geometric network.&nbsp; The personal geodatabase is now maxed out at the 2GB size limit.&nbsp; I kept receiving the error "Could not load data from the data source.&nbsp; If you can correct the problem, press the refresh button to reload data.&nbsp; Possible problems can include bad network connection, invalid field, etc."&nbsp; Being somewhat unfamiliar with Access databases I think this is happening because the database has exceeded the size limit.&nbsp; I want to convert from a personal geodatabase to a file geodatabase with a larger file size limit, but I'm unsure if all of the goemetric network properties will convert.&nbsp; Is it possible to do this conversion?&nbsp; Any suggestions??</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Tue, 21 Sep 2010 14:16:54 GMT https://community.esri.com/t5/data-management-questions/personal-geodatabase-w-geometric-network-maxed-out/m-p/721721#M40928 ZacharyRawe 2010-09-21T14:16:54Z Re: Personal geodatabase w. geometric network maxed out a 2GB https://community.esri.com/t5/data-management-questions/personal-geodatabase-w-geometric-network-maxed-out/m-p/721722#M40929 <HTML><HEAD></HEAD><BODY><SPAN>The max size of an access .mdb file is 2GB, but as it gets close to that limit performance will most likely be poor so moving to a file geodatabase would be a good idea anyway.</SPAN><BR /><BR /><SPAN>If the pgdb has been frequently edited, one thing you could try would be to run the compact tool on it.&nbsp; This should reduce the file size and may allow you to proceed.</SPAN><BR /><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//003n0000007t000000.htm"><SPAN style="text-decoration:underline;">compact</SPAN></A><BR /><BR /><SPAN>Make a back up of your geodatabase, then run the compact tool.&nbsp; See if you still get the error.</SPAN><BR /><BR /><SPAN>As for migrating to the file geodatabase, you can copy and paste the data from the pgdb to the fgdb.&nbsp; </SPAN><BR /><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//003n00000036000000.htm"><SPAN style="text-decoration:underline;">copy</SPAN></A></BODY></HTML> Tue, 21 Sep 2010 22:50:16 GMT https://community.esri.com/t5/data-management-questions/personal-geodatabase-w-geometric-network-maxed-out/m-p/721722#M40929 IanWittenmyer 2010-09-21T22:50:16Z