Accessing a table through ODBC

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

I want to access a database under Oracle 9.x using Access
FrontEnd. The problem is that a data record is not locked
when a user is working on this data record. This means
that several persons can work with the same data record at
the same time. A warning pops up only when they want to
save their changes.

What are the options of locking a data record when a user
is working on it? Can I activate the lock through VBA code
(in Access) or what can I do?

Before migrating to ORACLE, the data was saved in an
Access MDB. The lock at the data record level was managed
by Access.

Thank you very much for your support.

Best regards,

Robert
 
You can still manage the Lock with Access through the form properties.

Also, I am not sure what the Oracle Syntax would be, but in SQL Server you
can specify the lock level. For instance:

UPDATE UserSettings WITH NO LOCK SET AccountingSystemConnection = NULL

This will set the table with NO LOCK on it. Check the online help for
Oracle, search for something like Locks, or check this link, it might help
or lead you in the right direction:

http://databasejournal.com/features/oracle/article.php/2223371

HTH,
Randy
 
Back
Top