Read only table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need some help. I created a DB with 5 tables. The main table is linked to
3 tables as a one-to-many and the 4th is linked as a one-to-one. I am
attempting to open the DB using another Front end database program called
Lotus Approach. When I attempt to open the tables using Microsoft Access
Driver (*.mdb), I receive a message stating the file is read only for the 3
related tables on the many side of the one-to-many relationship. I do not
receive such a message when I open the main table or the table that is linked
as a one-to-one. Can someone assist me with how to correct this so I may
open the tables and edit them in Lotus Approach?
 
Check the indexes on the 3 one to many tables. Make sure you have a
primary key defined. Also may check that the key that links them from
the main is indexed.
 
Back
Top