Share DBF between Visual Basic and Clipper 5.2e

[Hawk521]

Due to a convergence of technologies and our purchased MRP system, I have a problem that could be solved if I can safely access a DBF file simulataneously with Clipper 5.2e and Visual Basic (we are using version 6.0).&nbsp;&nbsp;Presently we are &quot;linking&quot; to the DBF file from within an Access MDB database and using this for the VB SQL access.&nbsp;&nbsp;I'd rather avoid ODBC if I can for performance considerations.<br><br>I need to lock a record for update.&nbsp;&nbsp;My concern is that I don't know if VB can &quot;see&quot; a Clipper record lock (and vice-versa).&nbsp;&nbsp;Can anybody shed light on this for me?&nbsp;&nbsp;Is there any source of documentation that would answer my question?&nbsp;&nbsp;Or do I just have to build a test environment to settle this question?<br><br>Thanks for any help.<br>John McDermon<br><br><br>

 

[CMCDOJO]

I know this might not be what you are looking for, but if you use the Advantage Database Server (ADS) you will be able to use compatible file and record locking. ADS is a fantastic product if your clipper apps are running in a networked environment. The only way to access the Clipper files from VB using ADS is through ODBC, but you will find the the greater performance provided by ADS will more than offset any overhead incurred by ODBC. As for the Clipper apps you will simply need to recompile with the appropriate rdd's. <br><br>Information on ADS can be found at <A HREF="

http://www.advantagedatabase.com"

TARGET="_new">

http://www.advantagedatabase.com</A>.

 

[fbizzell]

You might also look at CODEBASE. I think it will handle the access of Clipper DBF files through Visual Basic.