What is the recommended safe limit of an Access database? We will be looking to store up to 300 records in one table and possibly well over 100 additional tables containing numerous pairs of fields. <BR><BR>I guess the 300 records in one table is not a problem, but I have concerns over the 100+ additional tables containing long lists of records with 2-3 fields in each. Will the 100+ additional tables strain Access? We prefer to keep with Access as long as possible before moving to SQL server.<BR><BR>I look forward to hearing your replies.<BR><BR><BR>Ashley