HOW TO FIX REPLICATED DATABASE WITH PROBLEMATIC TABLES

HOW TO FIX REPLICATED DATABASE WITH PROBLEMATIC TABLES .MDE .MDB

1. Create blank database in MS ACCESS, for example DB1.
2. Import all the tables from the replicated database. Go to File – Get External Data – Import. During the import process a message, record is deleted, will appear if there are problematic tables that can’t be imported, click the OK button.
3. Open the replicated database and open the table that was not imported, in this case it’s the Client table. Get the data of the table by selecting all and then copy the data and paste it to MS EXCEL, save.
4. Create a new blank database, for example DB2, and import the data from the MS Excel file that you save.
5. Open the table in design view of the imported data and edit the field names and field types using the field names and field types of the problematic table.
6. Export the table to MS EXCEL or TEXT file.
7. Open the database that contains the imported replicated database, in this case DB1. Import the problematic table from a blank database of existing database, in this case the client table.
8. Import the data that you edited and exported (MS EXCEL or TEXT file) to an existing table, in this case it‘s the client table.
9. Convert the database into MDE file.
a. Tools – Database Utilities – Convert Database – To ACCESS 2002-2003 File Format.
b. Enter a new filename, for example mydatabase.mdb. Close MS ACCESS once done.
c. Open the converted database, in this case the mydatabase.mdb.
d. Tools – Database Utilities – Make MDE File.
e. Enter a new filename or name it to desired filename.mde since this will be the new database of the client.
10. Test database by linking your application to this database.
HOW TO FIX REPLICATED DATABASE WITH PROBLEMATIC TABLES .MDE .MDB