Passing Variables between Data Access Pages

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

Guest

I'm trying to find out how to pass variables from one Data Access Page to
another. I have seen many answers to questions like this on Google but I
don't think the respondents understand what a Data Access page is. For
instance I have a Login html page, I validate the User ID and Password then
navigate to another html page and want to pass the User ID and Password
entered to that second page.
 
Ken,

Thanks for the response, we would rather not allow cookies if possible. Do
you know of another way? This seems like a lot of overhead to pass data back
and forth in a web page.
 
I konw of only two ways to "pass data" directly between data access
pages..... cookies and using the "ServerFilter" property of a hyperlink
control on the first page in order to filter the second page using the
"WHERE" type string that you put in that server filter property.

I suppose another way would be to run a query (using ADODB) from the first
page in order to write a value into a table in the database, and then open
an ADODB recordset in the second page in order to read that value... a bit
of overhead but should work. You'd need to run the "read" query in the
second page's BeforeInitialBind to get the value and then apply it to the
ServerFilter property for the page's Recordset.

--

Ken Snell
<MS ACCESS MVP>
 
Ken, can you expound on using the "Server Filter" method? I have 5 linked
pages that need to be controled by the first page.
 
Back
Top