Whether you use Microsoft Access to keep track of inventory or to keep a record of customers and clients, managing your tables can become cumbersome as the database grows in size and complexity.
So, when you open up Access and go File->Get External Data -> Link Tables... Then in the Files of Type box choose .dbf, then browse the the database, it doesn't work? The table should appear as a link ...
When you create a Microsoft Access table, Access will automatically create a primary key to your database table. Still, you can also specify the field you want as the primary key for your database ...