I have an application using a Pervasive 8.5 database. I need to access the
existing files via ODBC using the existing indexes in a new application. I
created DDF's for the files but each time I access through ODBC, all
accesses to any file read the entire file each time.
I read similar threads on the NG and the solution was to adjust the DFF's. I
did that and the consistentcy test in the PCC passed the definition but
because I was in linked mode, the data files were modified and this has
affected sorting on my original applications.

I would like to accomplish this without changing the data files but have had
no luck so far.

Can I change the DDF's to access the data via ODBC using the indexes without
changing the data files?

Thanks,

Al.




--
------------------------------------------------------------
Free Web Email & Filter Enhancements.
http://www.freewebemail.com/filtertools/
------------------------------------------------------------

In the Table designer, the "Linked" mode does in fact modify both the
SQL schema and the database files. As you have already experienced
changing the underlying data files may lead to side affects.
"Unlinked" mode only changes the SQL schema without changing the
underlying files. The best you can do is make the SQL schema match
the existing data files which will hopefully have all the indexes
needed.

Leonard

On Mon, 31 May 2004 15:45:15 GMT, "Al Henry" <alhenry (AT) telus (DOT) net>
wrote: