DBF WITH EXTENSION OTHER THAN .DBF ( I.E. DAT )



Dear All,

I have few dbase files from older application. They are using .dat as the
extension.
If I rename the file to dbf and using odbc or jet 4.0 ( ole ) I managed to
open connection and read table as it is.
The problem is to make it compatible with older application.

I read in MSDN about Jet 4.0, It is saying that with the previous version of
Jet 4.0, it is allowed to read dbase file with extension other than .dbf
Due to security measure, it has been disallowed

The Problem is :
I have to read .dat as it is w/o renaming the file due to it might be used
when reading the file.
Copying before renaming might be my last effort, as I prefer to be real time
rather than copying the file.

Is there some way to get around this problem ?

Thanks

Regards

Michael


.



Relevant Pages

  • Re: Shell Execute Associations...
    ... the .log file extension may be appropriate. ... I guess the general consensus is that a *.dat extension is a bad ... >Frank Adam Oct 27, 8:15 pm: ... >dim s as string, hFile as integer ...
    (comp.lang.basic.visual.misc)
  • Re: Missing previews in My Pictures
    ... Northerntravel.net and Northerntravel.co.uk is a premier online travel ... "DAT" files. ... But the .dat extension is confusing to other ... actually a .jpg, then rename the file changing the extension to .jpg ...
    (microsoft.public.windowsxp.general)
  • Re: Cant open .dat file
    ... Many, many programs use .dat as an extension for data files, so there is often ... not an association set for .dat files, ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: Missing previews in My Pictures
    ... Northerntravel.net and Northerntravel.co.uk is a premier online travel ... "DAT" files. ... But the .dat extension is confusing to other ... actually a .jpg, then rename the file changing the extension to .jpg ...
    (microsoft.public.windowsxp.general)
  • Re: Missing previews in My Pictures
    ... show up in My Pictures and I can't use them as a background. ... You might look at the properties of a .dat file and maybe figure out its actual type. ... Change the extension accordingly; if it's actually a .jpg, then rename the file changing the extension to .jpg e.g. ...
    (microsoft.public.windowsxp.general)