How can I find out the size of each table in my database

The only way to accurately determine the size is to export each table to a separate database, and compare before and after sizes.

You can estimate the size by determining the maximum size of each Field in each table, and then summing those to find the size of a "row", and then multiplying that by the number of rows in the table. This would give you a very rough estimate of the table size - but if you have Memo, Attachment or any other multivalued fields then you really can't use this method.

Also, there are some 3rd party utilities that do this, like Total Access Analyzer:

http://www.fmsinc.com/microsoftaccess/bestpractices.html

You can use a freeware tool like this to do what you are looking for..

http://www.atroplan.com/AccMemReporter.htm

Or

http://www.fmsinc.com/microsoftaccess/documentation/reports/Table_SizeBySize.html

Saurabh...

Table size is also impacted by the number of indexes attached.  So, you would need to include a calculation for indexes in your estimate as well.

http://www.atroplan.com/AccMemReporter.htm works for .mdb formats.

Anybody aware of vba code that I can copy?

Not sure how/where you need this data displayed, ...
But try code like this as a start:

Dim tdf As TableDef
Dim strRecCount As String

    For Each tdf In CurrentDb.TableDefs
        If Left(tdf.Name, 4) <> "msys" Then
          strRecCount = strRecCount & vbCrLf & "The table " & tdf.Name & " has " & DCount("*", tdf.Name) & " records"
        End If
    Next tdf

Note that code like this will take a while to run if you have a lot of tables with a lot of records

Let me know

JeffCoachman

The table size cannot exceed 2GB, so I need to know that size not the record count.

Divided the tables into separate databases and linked to each.  Problem is resolved.