I'm using a linked text file to load configuration data into a database. The file "xxxx.dat" is created by another program, and is a simple, comma delimited file. I created a linked table to read this file, then run queries based on the contents of the linked file as well as other database tables.
All of a sudden, when I try to run the queries, I get the following error message
Can't Update. Database or Object is Read-Only.
I'm certain it's not database corruption, since the backup copies have exactly the same problem. I've run compact and repair on the backups, with no effect. I can manually open up the file, delete it, or rename it, so I don't think it's a sharing violation.
I tried re-creating the link, but I get the same error. If I rename the file to "xxxx.txt", I can create the link. Obviously, I could write code to rename the file every time I want to run the update, but I'd just as soon keep the current system. The system has never before had a problem linking with these files, regardless of their name.
Any ideas?
All of a sudden, when I try to run the queries, I get the following error message
Can't Update. Database or Object is Read-Only.
I'm certain it's not database corruption, since the backup copies have exactly the same problem. I've run compact and repair on the backups, with no effect. I can manually open up the file, delete it, or rename it, so I don't think it's a sharing violation.
I tried re-creating the link, but I get the same error. If I rename the file to "xxxx.txt", I can create the link. Obviously, I could write code to rename the file every time I want to run the update, but I'd just as soon keep the current system. The system has never before had a problem linking with these files, regardless of their name.
Any ideas?