I am new to access development, please bear with me if these questions
sound trivial.
I am creating an Access application using link tables. My database
resides in MSDE. I have created multiples tables such as schools,
teachers, etc in MSDE.
1. This is my first question: In order to show user friendly data, I
have created a form displaying queries to display the schools/teachers
information. How do I use the same form to edit/add new data?. When I
open the form which displays the school data, I get a message, "The
Recordset is not updatable"
2. If login and access control is created for the application, is it
possible to display different switchboard automatically and also
capture the username in a field.
3. How do I create autogenerated number for the ID fields since this is
a linked table whenever new records are created.
Thanks for any input.