Access 2003 - Data Access Page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
the user field would be: UserField = suser_sname()
change the key to be auto-number: click "Identity" checkbox in Access table
design
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Updating tables when you input new data 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
data access page synchronize, update or what? 2
VBA - retrieve data on last create named range from previous inserted named range 0
Same record/Primary key in multiple tables 0
Access 2003 vs 2010 1
Data Access Pages Data Source 2

Back
Top