Disconnecting dBase indexes?

[Phydos]

I currently link to dBase (the dos version) tables using MS-Access, however, I need to disconnect the dBase indexes before doing this (using dBStructure as I don’t have a licensed copy of dBase). Is there a way to remove the index and disconnect them using either VBA or Access (or any other method - maybe some compiled exe available somewhere)?

Thank you,
Phydos music & media

http://www.phydos.com

 

[cfneumann]

set the mdxbyte to 00h, how many cross postings are there? Christopher F. Neumann
[dBASE Charter Member]
Blue Star Visual dBASE graduate
ICCP certified TCP/IP Network Analyst

http://cfneumann.us

 

[Phydos]

One in dBase, and one in visual dbase (hoping that there would be some pre-compiled exe to do the job of detaching the indexes), and one in Access forum (maybe someone has had the same problem in the past).

Thanks for your reply in each – I’m looking into it now, but not exactly sure what you mean – haven’t used dBase for about 8 years.

Phydos

http://www.phydos.com

 

[cfneumann]

In dBase this resets the index flag:

nhandle = new file()
nhandle.open(mydbf,"rw&quot
nhandle.seek(28)
nhandle.write(chr(0))
nhandle.close()

Notice that the 28th byte is set to 0. It is 1 when there is an index. Christopher F. Neumann
[dBASE Charter Member]
Blue Star Visual dBASE graduate
ICCP certified TCP/IP Network Analyst

http://cfneumann.us

 

[cfneumann]

You have a CDX index, this is a NOT dBase table/index!! Christopher F. Neumann
[dBASE Charter Member]
Blue Star Visual dBASE graduate
ICCP certified TCP/IP Network Analyst

http://cfneumann.us