Read only table

H

hkhella

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?
 
B

B_A_R_T_M_A_N

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top