If you are dealing with a greater amount of records in a Microsoft Access database, it’s recommended to use a SQL server as a backend database to handle those and get rid of unpleasant surprises. Usually those servers are connected via JET/ODBC – and that’s where the fun starts.