G
Greg Wilkerson
Does anyone know where to find technical information on the Office Web
Components - Data Source control. I have been tasked with modifying a
Microsoft Access 2003 Page? All I can seem to find is an object model
diagram (does me no good). This page accesses SQL Server via a
trusted connection (Windows authentication). The task that is giving
me the most trouble is determining what user is making the database
request. This is easily retrieved from the database via "select
current_user". What I can't figure out is how to configure the data
source control to query the database server for this info. Unless I'm
mistaken, I can't use jscript to get this (which is what has led me to
think about just querying the database. I ask for the technical
documentation only because it seems to be pretty difficult to
configure this control via the GUI. Maybe I'm missing something, and
if so please let me know.
For a little more background, this page is used to add a record to a
SQL Server table, so there is already one data source control on the
page. The looks to have been created with the page wizard (I
inherited this, I didn't originally write it).
My ultimate goal is to populate a textbox on this data entry form with
the userid that created the record. I thought about using cookies,
but I'm not sure that is acceptable.
TIA,
Greg Wilkerson
Components - Data Source control. I have been tasked with modifying a
Microsoft Access 2003 Page? All I can seem to find is an object model
diagram (does me no good). This page accesses SQL Server via a
trusted connection (Windows authentication). The task that is giving
me the most trouble is determining what user is making the database
request. This is easily retrieved from the database via "select
current_user". What I can't figure out is how to configure the data
source control to query the database server for this info. Unless I'm
mistaken, I can't use jscript to get this (which is what has led me to
think about just querying the database. I ask for the technical
documentation only because it seems to be pretty difficult to
configure this control via the GUI. Maybe I'm missing something, and
if so please let me know.
For a little more background, this page is used to add a record to a
SQL Server table, so there is already one data source control on the
page. The looks to have been created with the page wizard (I
inherited this, I didn't originally write it).
My ultimate goal is to populate a textbox on this data entry form with
the userid that created the record. I thought about using cookies,
but I'm not sure that is acceptable.
TIA,
Greg Wilkerson