Re: Access vs Oracle

A major difference of Oracle and Access that I have seen is the ability of oracle to transaction processsing in a much busier environment than Access is capable.

For example, I believe Access uses something they call Optomistic Record locking. If a user tries to read a record another user has locked, a error will be generated that the record is unavailable.

In oracle, the use of Rollback segments allows multiple people to read/update/delete records at once by keeping both current and previous record values.

Access will run small shop databases which do not have many users to collide, while Oracle is used for mission critical applications with a need to have a high level of tuning and availability.

--

        \\||//	Indecision is the key to flexibility 
        /    \		
        []--[] 		 Allen Lucas  	 
       @  /\  @		Chicago Bridge & Iron
        {----}		Plainfield, Il  60544 
          ^^					alucus_at_concentric.net


===================================================================