VB SCRIPT Username

Hi I have created a data access page in Microsoft Access

The page is based on a query which I would like to set the criteria to the current Windows logged in user

I tried using environ("username") I am told that VBA does not work in VB Script

How on earth Can I get it to work so that when a user opens the data page from internet explorer they can see only the records based on their user name and not the whole table with everyone else's records?

Any help would be VERY much appreciated

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!