VB + Databases, best method [Resolved]

[ChrisL]

I have only ever used Access to make databases with forms that interact with it and am facing a dilemma here!

I have made a notes program, well the forms and all the interactions with it, all im trying to figure out now is, how do i store these notes to my database?

Would i create the note and the database record at the same time? If so how would i update the database with any changes i made because i wouldnt know the unique ID?

Or would i create the database record when I have finished creating the note and get the unique ID then?

I am so confused as to what to do in regards to databases in .NET?

Can anyone give me any pointers for storing records or creating records in .NET with Access?

Docs or tips would be great please!