[dba-SQLServer]OLEDB Connection

Julie,
    Even though Access ADP's are hooks as front ends to SQL Server.  The
views and sprocs (stored procedures) are still very much Sql Server.  Thus
the SQL Server knows nothing about [Froms]![forms]![frmmacolalabel]![swidth]
also you can't parametrize a view.  but you can build a stored procedure
that uses a view as one of it's based tables.

Thus the calculation you want to have happen can't the way you are doing it
here.  Refrences to forms or reports from the view or sproc will not
resolve.  you must pass them as paramters to sprocs via the input param in
the form or report.

-Francisco
http://rcm.netfirms.com
----- Original Message -----
From: "Julie Reardon-Taylor" <prosoft6 at hotmail.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Tuesday, February 18, 2003 8:34 AM
Subject: RE: [dba-SQLServer]OLEDB Connection

<snip>

:  The view in the
: .adp keeps putting quotes around my expression and treating it like text.
:
: For example, one of the expressions calculates area.
: =[forms]![frmmacolalabel]![swidth] * [forms]![macolalabel]![length]
:
: What am I doing wrong?  I'm using the Alias column to put the "Area" in.
:
: Help!
:
:
: Julie Reardon-Taylor