Types

• You must determine the type of error to resolve it. Split database errors include failure to split; a split database that will not run; and a split database that runs with errors for all or just some users.
  
  

Solutions

• If an Access 2007 database won't split automatically, you can create a split database manually by moving the tables to a new database file before linking them to the original file. Operating errors with a split database often occur from inconsistent manual updating of the individual databases or by external factors such as network permissions. In some cases, users must modify custom Visual Basic coding in the database.
  
  

Prevention

• To prevent split database errors, users should split the database as soon as possible during the design stage. If this proves impossible, ensure the database is compacted and operating without errors before splitting. Always make back-up copies before splitting, and before adding new features.