Unable to link to a .Dat file...but .Txt ok

[rizza]

Thanks in advance to all can help,

Our company get's their Phone bills delivered on Cd's, that someone puts in their drive and then opens this MS Access Db and runs some reports.

Well the Tables in that report are linked to the files on the cd. Well the cd data used to come in .dbf format now it comes in .dat format.

I'm trying to just change the old link to point to this new db type but it wont work.

"Cannot Update. Database or Object is read-only" is the error message i get. I've checked that the DB i'm writing to is not read only. I even added .dat to reg settings for the Jet 4.0 ISAM format txt file types...

I have no problems doing what i want when i change the file extension of the .dat file to .txt.

Can anyone help me out here...

Thanks,

RizzA

 

[Rick39]

I have a similar situation and have added the following in a loop to rename the files before I process them

Dim OldName, NewName
OldName = "\\DataStor\Shared\YourPath\YourFile.dat": NewName = "\\DataStor\Shared\YourPath\YourFile.txt" ' Define file names.
Name OldName As NewName ' Rename file.


Hope this helps