>I need to be able to open dBase files for shared read/write access but the files have non-standard file extensions. Renaming the files is not an option. The ODBC driver assumes a DBF extension on the tables so building a remote view with the view editor won't work because the files don't show up in the pick list.
>
>Any suggestions ?
cMyStrangeFile = 'MyTable.XXX'
USE (cMyStrangeFile) SHARED
You can also construct the view programmatically; the View Designer is pretty limited.