$_SESSION variable equivalent in Access

the_net_2.0

Banned
Local time
Today, 08:52
Joined
Sep 6, 2010
Messages
812
can anyone relate to tracking sessions in Access? Sometimes I use the SESSION variable in PHP to time page movements, but not all the time. I was wondering if there was something similar in Access. I know there are no super globals, but I'm curious to know how the veteran programmers here handle this.

I'm thinking it would be OK to issue a global or public variable upon successful logins with FEs that are all using the same BE. Would there be any problem with this? I have read that all variables not destroyed by the time the program is shut down will be when the program is closed. Are there any thoughts on this?

thanks!
 
A Session Variable is html using a Cookie, I do not know of any equivalent in Access.

Simon
 
A table that you can write the user's session details to should do the trick.
 
thanks guys!

expanding this further, what I'm wondering about is if I have 50 frond ends out there and one back end on the server, what would be the best way to issue user-specific reports? I am currently doing this, but interested in how others have gone about it.

now that I think about it though, the way I'm doing it now probably is the only way. writing to the current user table and simply pointing to it when need be?
 
That would be the way I would do it rather than distributing user-specific reports. That way you wouldn't have to roll out the FEs if a change was made to some of the reports.
 
That would be the way I would do it rather than distributing user-specific reports. That way you wouldn't have to roll out the FEs if a change was made to some of the reports.

thanks much!
 

Users who are viewing this thread

Back
Top Bottom