| ODBC locking access97 database [message #101808] |
Fri, 12 October 2001 07:47  |
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  |
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.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
