Access Form is Read only

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

Guest

Have linked tables feeding a query with data from query shown on a form.
I require to be able to change or amend data from that form.
Help would be appreicated
 
La said:
Have linked tables feeding a query with data from query shown on a form.
I require to be able to change or amend data from that form.
Help would be appreicated
Click to expand...

could you post the SQL? There's a good chance that resulting recordset
is not updateable. Without the SQL, it's impossible to tell.
 
Access Data Projects don't have random bugs like this.

Lose the training wheels. MDB is for babies.

Spit on people that use it.

-Aaron
ADP Nationalist
 
SQL of Query is as follows:-




SELECT BOATDETAILS.RegNo, Owners.OwnerID, Owners.Name, Owners.Address1,
Owners.Address2, Owners.Address3, Owners.TelNo, Owners.Owned1, Owners.Owned2,
Owners.Owned3, Owners.Owned4, Owners.Owned5, BERTH.Position, BERTH.Area,
BOATDETAILS.BoatName, BOATDETAILS.Owner1ID, BOATDETAILS.[Owner2 ID],
BOATDETAILS.[Length Ft], BOATDETAILS.[Length ins], BOATDETAILS.[Beam FT],
BOATDETAILS.[Beam ins], BOATDETAILS.InsCompany, BOATDETAILS.PolicyNo,
BOATDETAILS.ExpiryDate, BOATDETAILS.StartDate, DDETAILS.SortCode,
DDETAILS.AccountNo, DDETAILS.TransactionType, DDETAILS.AccountName, *
FROM (Owners LEFT JOIN DDETAILS ON Owners.OwnerID = DDETAILS.OwnerID) RIGHT
JOIN (BOATDETAILS LEFT JOIN BERTH ON BOATDETAILS.RegNo = BERTH.BoatReg) ON
Owners.OwnerID = BOATDETAILS.Owner1ID
ORDER BY BOATDETAILS.RegNo;
 
I would start with removing all the paranthesis on your sql statement.

that is a bug from Microsoft; and I've seen it result in AWFUL
performance out of the box.

if you MUST you can go back and add a single pair of paranthesis-- but
it's probably not necessary in 95% of the circumstances.




La said:
SQL of Query is as follows:-




SELECT BOATDETAILS.RegNo, Owners.OwnerID, Owners.Name, Owners.Address1,
Owners.Address2, Owners.Address3, Owners.TelNo, Owners.Owned1, Owners.Owned2,
Owners.Owned3, Owners.Owned4, Owners.Owned5, BERTH.Position, BERTH.Area,
BOATDETAILS.BoatName, BOATDETAILS.Owner1ID, BOATDETAILS.[Owner2 ID],
BOATDETAILS.[Length Ft], BOATDETAILS.[Length ins], BOATDETAILS.[Beam FT],
BOATDETAILS.[Beam ins], BOATDETAILS.InsCompany, BOATDETAILS.PolicyNo,
BOATDETAILS.ExpiryDate, BOATDETAILS.StartDate, DDETAILS.SortCode,
DDETAILS.AccountNo, DDETAILS.TransactionType, DDETAILS.AccountName, *
FROM (Owners LEFT JOIN DDETAILS ON Owners.OwnerID = DDETAILS.OwnerID) RIGHT
JOIN (BOATDETAILS LEFT JOIN BERTH ON BOATDETAILS.RegNo = BERTH.BoatReg) ON
Owners.OwnerID = BOATDETAILS.Owner1ID
ORDER BY BOATDETAILS.RegNo;


[email protected] said:
could you post the SQL? There's a good chance that resulting recordset
is not updateable. Without the SQL, it's impossible to tell.
Click to expand...
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

Parameter Value error in a Subform 0
Problem with 1 Query with Criteria feeding another query 3
"Read Only" Query 0
Access Form Refresh 1
Access Access Report Works on One Machine but not Another 3
access forms 2
Runtime is read only ???? 2
Using the "Forms Object" on more than field in a query table 2

Back
Top