[AccessD] Data Access Pages

Susan Harkins harkins at iglou.com
Sun Aug 3 09:00:01 CDT 2003


Julie, set the page's Recordset Type property to Dynaset (Inconsistent
Update).

Susan H.

> Susan,
>
>
> Here is the sql statement.  Hope this helps.  Why so many restrictions on
> DAP's?
>
> SELECT CardInventory.item_no, CardInventory.item_desc_1,
> CardInventory.prod_cat, CardInventory.loc, CardInventory.item_weight,
> CardInventory.user_def_fld_1, CardInventory.user_def_fld_2,
> dbo_IMLSMST_SQL.ser_lot_no, CardInventory.user_def_fld_3
> FROM dbo_IMLSMST_SQL INNER JOIN CardInventory ON dbo_IMLSMST_SQL.item_no =
> CardInventory.item_no
> WHERE (((CardInventory.loc)="c"));
>
>
>
> Julie Reardon-Taylor
> PRO-SOFT OF NY, INC.
> www.pro-soft.net
>
> _________________________________________________________________
> MSN 8 with e-mail virus protection service: 2 months FREE*
> http://join.msn.com/?page=features/virus
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>



More information about the AccessD mailing list