Access 97 TransferSpreadsheet 3027 error

  • Thread starter Thread starter J Villa
  • Start date Start date
J

J Villa

I get a "3027 - Can't update. Database or object is read-
only" error message when I use the vba
TransferSpreadsheet from Access 97 to Excel 97. If I use
a short file name, I don't get the message. If I user a
longer file name, I do. Is this coincidence or is it the
problem? How long can the file name be?
 
I have seen similar problems using Foxpro and dBase files.
Using DOS 8.3 file names and paths usually solves it.

I never saw it with Excel though.

You can check MSKB if you want. There may be an article that addresses this
issue.
 
Back
Top