You need to change the following settings in the registry.



HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0

\Engines\Text\DisabledExtensions (define the extension which you need e.g 

DAT)



'For Ref: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q245407



Maqsood Ahmed



> hi all

> 

> i developed  application using access97 ,,there is a pice of program to 

import dat 

> file  in access97 it's fine 

> but when i convert it to access200 it allways alert me that "object or 

data base 

> read only " i check  database and file it  r/w per.  

> 

> when i convert the extention of the file to .txt  it is work fine also 

but i still 

> need to import text file with .dat extention   

> 

> "

> OLD_FILE_NAME = [FILE_NAME] + ".DAT"

> TABLE_NAME = "CORRECT_TEMP"

> DoCmd.TransferText acImportFixed, "YY", TABLE_NAME, PATH_NAME + 

OLD_FILE_NAME

> "

> 

> thank you 

> abed

Hi  Maqsood;



I had this exact problem (my files must have the .dat extension) wand was getting the same 

error message.  You can find 4 solutions to this problem at:



                 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304206



There is a registry fix as is suggested below.  Since I will distribute my application I choose the 

coding solution and I can tell you it works fine.



Cheers,

Joe





> You need to change the following settings in the registry.

> 

> HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0

> \Engines\Text\DisabledExtensions (define the extension which you need e.g 

> DAT)

> 

> 'For Ref: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q245407

> 

> Maqsood Ahmed

> 

> > hi all

> > 

> > i developed  application using access97 ,,there is a pice of program to 

> import dat 

> > file  in access97 it's fine 

> > but when i convert it to access200 it allways alert me that "object or 

> data base 

> > read only " i check  database and file it  r/w per.  

> > 

> > when i convert the extention of the file to .txt  it is work fine also 

> but i still 

> > need to import text file with .dat extention   

> > 

> > "

> > OLD_FILE_NAME = [FILE_NAME] + ".DAT"

> > TABLE_NAME = "CORRECT_TEMP"

> > DoCmd.TransferText acImportFixed, "YY", TABLE_NAME, PATH_NAME + 

> OLD_FILE_NAME

> > "

> > 

> > thank you 

> > abed