I am using a VB 6.0 front end with Access 97 DB's.

I cannot upgrade the DB's because the end client only has Access 97 with
no plans to uprade yet.

Is it possible to row level locking with Access 97 DB's ?.

I realise this is available with the JET DB Engine version 4.0.  Can I
use this version with my Access 97 DB's and still use row level locking
?.

Thanks, Mike.

No, It is not available to Access 97 or lower databases.

Scot

Ummmm...are you thinking that each user must have the MS-Access program
installed in order for your VB app to work with data in .mdb files?
Seems to me I read somewhere that you can distribute a VB app with its
.mdb without user having Access at all, let alone a matching version ;-)
--
Jim in Cleveland
If you're writing to me, in my address
change "REAL_Address.see.below" to "worldnet.att.net"

"What's so funny 'bout peace, love & understanding?"
     - Nick Lowe

Thanks for your replies !.

When does row level locking start ?.

Is it with the Jet Engine, i.e. Version 4.0, and can this feature only
be used with Access 98 DB's and above ?.

It must be possible to use an Access 87 DB with Jet V 4.0 ?.

P.S. Jim, I realise that I don't need Access to be installed for my VB
program to work with an Access 97 DB.  It's simply that Access 97 is the
version that my customers end users have, and occasionally use with this
particular DB, and therefore I cannot upgrade the DB beyond this
version.

Hi Mike,

Yes you can use the OLEDB provider for 4.0 with Access 97 databases.
However with 97 databases you cannot use all of the functionality of the
provider (such as Row level locking). FOr that you would have to upgrade
the DB to jet 4.0 (Access 2000)

Scot

Scot,

Thanks.

Mike.