hi,

I have a large Access 97 mdb, used by 60 people.

I get them to log into Sybase at the splash screen stage in order to access 

data on sybase tables. - ie UserID = 'smithW'



I assign the UserID to a variable and then reuse it through out the 

database to use in pass thru queries. Ie pass the UserID to a table when it 

updates etc, so records can be kept of who updated or appended what..





The problem is- i've had a few errors where the pass thru queries don't 

work cause of blank fields namely the UserID field- it just vanishes.



I cant work out why im losing the value of it!!

any ideas on how to store the UserID properly?



Thanks