Database checks

Results 1 to 3 of 3

Thread: Database checks

  1. #1
    j Guest

    Default Database checks

    What do I need to check so that multiple people can insert records into an access database.<BR>SQL server takes care of locking but what about access ?

  2. #2
    Join Date
    Dec 1969

    Default RE: Database checks

    The easiest way to do this is to add all the users you want to have access rights to the table to an NT Group. Then under SQL Server Enterprise manager, add a new login and add that group to this login and give that login the access rights to the tables that they will be using.

  3. #3
    Join Date
    Dec 1969

    Default RE: Database checks

    Access also tries to take care of locking, and here is a related resource for you:<BR><BR>Cursor & LockType Performance Report - 6/27/1999<BR><BR>Test was done for inserting recs instead of just getting them.<BR>Use adOpenForwardOnly cursor (the default) whenever possible for speed, but use adOpenStatic if want to use objRS.MovePrev or objRS.RecordCount.<BR>Use adLockReadOnly lock type (the default) whenever possible for speed, but use adLockOptimistic when updating and deleting or adLockPessimistic if leaving a recordset open for editing which of course one shouldn&#039;t do on the Web anyway.<BR><BR>Best regards,<BR>-Paul<BR><BR> - Web Database Developer<BR><BR>Developer Tips Page<BR><BR><BR><BR>

Posting Permissions

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