Access 2003 - Data Access Page

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
 
T

tyrdrannoy

the user field would be: UserField = suser_sname()
change the key to be auto-number: click "Identity" checkbox in Access table
design
 
Top