Access 2003 Data Access Page - SQL Server - NT Login

G

GregCrossan

I have a data access page which I am getting ready to use to add / edit records in a SQL Server 2000 table.

I need to find a way to do two things, which I am finding to be difficult.

-> Update the 'UserField' (in the table) with the users NT login info (userName)

-> For new records - update the 'Key' field with the highest existing value in the table + 1

To me this should be simple, but I am having a heck of a time getting anything I try to work..

I have never coded vb/j script in the past... so bear with me.

Thanks
 
Top