Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012
    Posts
    7

    Unanswered: Locking Tables feilds

    Hi all I'm back again with some more questions.

    I have a form on a split database with multiple users (taking phone messages). I already have the form set up so the user can only enter new data in it so that there is no mishaps of messages being typed over. However, I want other users (returning calls) to be able to go view the information on the table. I want the users returning calls to only be able to edit certain fields in the table. Is there any way I can lock only the fields that I dont want them to be able to edit?

    Also, another question...

    My ID is my primary key which orders numerically with each record (1,2,3...ect.) I deleted the first couple test records but the ID continues to numer from where the last deleted record left off (4,5,6..ect.). How can I get it to start back at one?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Quote Originally Posted by jkisner View Post
    Is there any way I can lock only the fields that I dont want them to be able to edit?
    1. When the form is in Design view, open the Properties window.
    2. Select the control you want to make read-only.
    3. Select the "Data" tab in the properties window.
    4. Change the value of the Locked property to Yes.
    Quote Originally Posted by jkisner View Post
    How can I get it to start back at one?
    Normally, you should never do that. Values generated in an Autonumber column should be reserved for the internal mechanism of a database and never be accessible to the user for whom they are meaningless.

    Here's a solution, however never use it in a database in production.
    1. Delete all rows from the table you want to reset.
    2. Create a new query and switch to SQL view.
    4. Type this in the query (replace "TableName" by the name of your table and "TableColumn" by the name of the Identity column):
    Code:
    ALTER TABLE TableName ALTER COLUMN ColumnName COUNTER(1,1);
    5. Execute the query.
    Have a nice day!

  3. #3
    Join Date
    Jan 2012
    Posts
    7

    Reply

    Thanks, for the help everything worked out great.
    Thank you.

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •