Results 1 to 2 of 2

Thread: Recordset Locking

  1. Feb 3rd, 2005, 03:54 PM #1
    JerryL
    JerryL is offline

    Thread Starter
    New Member
    Join Date
    May 2003
    Location
    Muncy, Pa
    Posts
    7

    Recordset Locking

    I have a VB6 App adding records to an Access/2000 database using ADO recordset with adLockOptimistic. THis should permit multi-user access but ot only permits one user accessing the database at a time.

    Why?

    Any suggestions would be greatly appreciated.

    Thanks

    JerryL
    Where are we going, and what's with this handbag?
    Reply With Quote Reply With Quote
  2. Feb 3rd, 2005, 09:03 PM #2
    erickwidya
    erickwidya is offline
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Re: Recordset Locking

    check this link

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width