Username as global variable

[Guest]

I have a database in development where I have the need to have records
identify which user created the record by recording the username of the user.
The users are all on Windows 98 OS system which excludes using the NT get
user name function posted at http://www.mvps.org/access/api/api0008.htm

This leads me to 2 questions
1) Is there a way to use a similar Module as the posted on a windows 98
machine?
2) If option 1 is not possible can I use a "Log in" page on startup (without
password) to create a global variable for the season to auto populate a field
in a table when.

I am not familiar with Access Security (in the process of researching) so do
not want to use those built in functions. Any help would be greatly
appreciated.

 

[Pieter Wijnen]

Check http://support.microsoft.com/kb/210088

Specifically
Declare Function WNetGetUser& Lib "Mpr" Alias "WNetGetUserA" (lpName As
Any, ByVal lpUserName$, lpnLength&)

HTH

Pieter

 

[Guest]

Pieter,

Thanks for the direction I can get the module to pull the user name in the
immediate window, how ever I am getting #Error (undefined) when I code a
forms defualt value to the module . Any Ideas?

Barry