Error 3027

J

Jamey

We are using Access to create a flat file from an excel
spreadsheet. The system has worked flawlessly until today.
Now the procedure is failing because of a "Run time error-
3027 Can't update. Database or file is read only." We
cannot see any indication that the file or database is
read only. We have not changed this database but also did
not build it. What can be causing this problem and how do
we fix it?
 
D

Dirk Goldgar

Jamey said:
We are using Access to create a flat file from an excel
spreadsheet. The system has worked flawlessly until today.
Now the procedure is failing because of a "Run time error-
3027 Can't update. Database or file is read only." We
cannot see any indication that the file or database is
read only. We have not changed this database but also did
not build it. What can be causing this problem and how do
we fix it?
Click to expand...

How are you creating the flat file, and what file-extension are you
assigning it? Are you using TransferText? You could be having this
problem:

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