transfer text problem

[gbanks]

I use the line below to transfer a query (as a .dat file)to a network drive. I converted the database from 97 to 2000 and this stopped working. I got an error message that said the Cannot update. Database or object was read-only. When I run this in 97 it works fine but in 2000 it fails. I checked the file at it's not a read-only file. Any thoughts? Thanks..

DoCmd.TransferText acExportFixed, "RPT_STC Address Rpt Export Specification", "RPT: STC Address Rpt Query", "H:\eib\int.dat",

 

[FoFa]

Yes, one of the new features of A2K and greater is they do not allow you to over write system files (.DAT is a system file extension). You have 2 options.
Option 1 - Export it with a .TXT (or other usable extension)
Option 2 - perform a registery hack to allow .DAT extensions
Add any extensions you wish to export to this reg. entry
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions

Be very careful adjusting your registery....