Home » Other » General » ODBC locking access97 database
ODBC locking access97 database [message #101808] Fri, 12 October 2001 07:47 Go to next message
allen
Messages: 15
Registered: August 2000
Junior Member
the exclusive check box is off (both in access and in the odbc setup), but when the ODBC drives accesses the database, it locks it from being used. We have 2 other databases set-up the same way that work. Any clues?

----------------------------------------------------------------------
Re: ODBC locking access97 database [message #101858 is a reply to message #101808] Thu, 01 November 2001 11:31 Go to previous message
Ted Ims
Messages: 3
Registered: November 2001
Junior Member
I'm assuming Access is locking your ORACLE tables.

If that is the case and you are using Access forms then make sure that the recordset for the form is not performing the locking.

In design mode of a form check the form property "Record Locks" (under the "Data" tab)

RecordLocks (NoLocks/AllRecords/EditedRecord)

Choose your lock method accordingly.

----------------------------------------------------------------------
Previous Topic: Simple Question about file extension
Next Topic: Re: ADO/Oracle: TNS: Could not resolve service name
Goto Forum:
  


Current Time: Thu Mar 28 12:30:48 CDT 2024