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

 

[AccessAce]

By reading the files off of the CD, the operating system will mark the file as read-only. After copying the file to a hard drive, you have to go back and trip the flag on the file to remove the read-only mark. Then you can open access and it should work.

I think there's a solution in there somewhere.

 

[rizza]

Sorry, but that doesnt work. I've done that. The fact is it used to read the old DBF files off the cd, but now that i have .dat files it wont...

Anybody else wanna try...

Thanks for your help thought,

Brian