form is suddenly read-only

[Karen H]

I do not have the permissions to download a zip program and so have been paring down the data so that I can send you the attachment.

I am also trying to get caught up since today is only the 4th day we have worked in the last 2 weeks because we have been getting record breaking snows.



Thank you so much for your time and patience.

[RuralGuy]

This site will take a ZIP file up to 2MB's.

[RuralGuy]

The only form in the system does not have the right RecordSource.

[Karen H]

I don't have any zip software and cannnot download and install any as I do not have the correct permissions on my computer.

Try this database. I had removed some of the tables in the query so that it would remain read/write. Sorry for the confusion.

[RuralGuy]

WindowsXP comes with the ability to zip built in. After a Compact and Repair then right click on the mdb and "Sent to Compressed file".

[Karen H]

Ok, try this.

[RuralGuy]

The form still has controls bound to fields that are *not* in the RecordSource of the form *AND* the RecordSource query is ReadOnly! Maybe this link will help: http://allenbrowne.com/ser-61.html

[Karen H]

I checked out the link you sent carefully reading and checking each of the issues that can come up. The only thing I can think it might be is the JOIN. I have copied the sql for the query and listed it below. This issue has been the first time I have ever even known about an SQL statement. To the best of my knowledge everything looks ok.

SELECT [tbl client].*, [tbl client ac hm & ddsd].*, [tbl client guardian].*, [tbl client school & vocation].*
FROM (([tbl client] INNER JOIN [tbl client ac hm & ddsd] ON [tbl client].idclient = [tbl client ac hm & ddsd].[idclient ac hm ddsd]) INNER JOIN [tbl client guardian] ON [tbl client].idclient = [tbl client guardian].[idclient guard]) INNER JOIN [tbl client school & vocation] ON [tbl client].idclient = [tbl client school & vocation].[idclient school & voc];

[RuralGuy]

It is most certainly the Joins. Start a new query with two tables joined and then start adding in the other tables onw at a time until it goes read only. You will then know where the problem lies.

[Karen H]

As soon as I add the 3rd table it becomes read-only. The primary and any of the other tables is fine.

[RuralGuy]

It is read only because the record becomes ambiguous so Access would not know what to change if you were to try. Do you know the difference between Left, Inner and Right joins?

[Karen H]

never heard of a join before this issue. The PK and the FK are the same exact number, with different names. I don't understand what makes it ambiguous.

[RuralGuy]

Did you define the relationship each table has with the others in the Relationship menu? If you right click on the join line it will describe what result you will get with that type of join.

[Karen H]

I had to study about joins. My relationship screen shows a PK in the main table and a FK in each of the other tables. I changed the JOIN propertiesto all be left joins.

When I add the third table to the query the results are read-only.

With many steps I was able to add all the data back into the original table. I guess I will just use it as-is, with too many fields in one table.

Thanks for the patience and help.