HEELP: How to lock a recordset in an ODBC-data source?

[Marc Lisketing]

Hi everyone!

In our current project we have to lock and unlock records in an ODBC-data source (FoxPro 2.6 data
files). The ODBC-driver only supports optimistic record locking. But we need unconditionally pessimistic
record locking. Besides, we want to know if a record is already locked or not.

We have tryed to solve the problem for a few weeks. Without any success. I can´t be possible that
there is no way to do this or that no one every heard of this?

Here are some further details about our project:

- Visual Studio 6.0 (SP2)
- MS FoxPro ODBC driver (v 3.51.171300)
- ODBC-DLLs (v 3.510.3002.13)

When anyone has an idea to solve this problem, please give me a notice!

Marc

[davidramsey]

What have you tried so far? I assume that you have already tried the SetLockingMode member function. Also, is it necessary to use ODBC to hit the tables? It is possible to run a link into an Access database at runtime. Using DAO may give you more functionality given the fact that it won't be using the ODBC drivers any longer.

TKE Dave