Records Updateable in MS Access .mdb but not in .adp ?

  • Thread starter AB via AccessMonster.com
  • Start date
A

AB via AccessMonster.com

I have a query that joins a table to another query with some calculated
values.

The same query in a MS Access .mdb file produces a recodset that can be
edited - but in an .adp file, the recordset id Not updateable.

I crearted a form bound to the query, and selected tblStock as the Unique
table, and it is still not updateable?


query below (if it is of any help)
---------------------------------


SELECT qryStock.ID, qryStock.CategoryID, qryStock.QuoteCategoryID,
qryStock.OriginalCategoryID, qryStock.StockNumber, qryStock.Description,
qryStock.ReorderPoint, qryStock.ReorderQty, qryStock.Unit,
qryStock.ListPrice, qryStock.CostMultiplier, qryStock.SellMultiplier,
viewCalculatedStockOnHand.Ordered, viewCalculatedStockOnHand.Received,
viewCalculatedStockOnHand.Backordered,
viewCalculatedStockOnHand.Adjustments, viewCalculatedStockOnHand.[On Hand]
FROM qryStock INNER JOIN viewCalculatedStockOnHand ON qryStock.ID =
viewCalculatedStockOnHand.StockID;
 
S

Sylvain Lafontaine

Your query looks perfectly valid to me. Some things like Bit field or a
sorted view without a TOP 100% clause may render a render not updateable
under ADP on some occasions but that doesn't seem to be your case.

Maybe the problem lays in the way that this query is created or linked to
the form.

S. L.
 
J

J. Clay

If you are using A2k you need to set your Unique Table as the one to be
editable in the form properties. This should not be necessary in A2k2 or
A2k3

I typically try if possible to use one table on a master form and subforms
for all of the related tables. Tends to be cleaner this way.


Jim
 
S

Siddharth Parekh

I have faced the same problem and after looking into it found out that it was a bug from the Microsoft web site.
They seem to have repaired it in the Access 2000 version but not in the 2003 version which i am using.
Siddharth.
I have a query that joins a table to another query with some calculated
values.

The same query in a MS Access .mdb file produces a recodset that can be
edited - but in an .adp file, the recordset id Not updateable.

I crearted a form bound to the query, and selected tblStock as the Unique
table, and it is still not updateable?


query below (if it is of any help)
---------------------------------


SELECT qryStock.ID, qryStock.CategoryID, qryStock.QuoteCategoryID,
qryStock.OriginalCategoryID, qryStock.StockNumber, qryStock.Description,
qryStock.ReorderPoint, qryStock.ReorderQty, qryStock.Unit,
qryStock.ListPrice, qryStock.CostMultiplier, qryStock.SellMultiplier,
viewCalculatedStockOnHand.Ordered, viewCalculatedStockOnHand.Received,
viewCalculatedStockOnHand.Backordered,
viewCalculatedStockOnHand.Adjustments, viewCalculatedStockOnHand.[On Hand]
FROM qryStock INNER JOIN viewCalculatedStockOnHand ON qryStock.ID =
viewCalculatedStockOnHand.StockID;
 
A

A B via AccessMonster.com

FYI

One thing that was suggested is that I make sure that any linked queries
include the primary key for each table, whether I use it or not. I am not
at work now, so I can't try it.

I always wondered why some Views said top 100 percent - Now I know why -it
is because there is a bit field!

AB
 
Top