Access 97 TransferSpreadsheet 3027 error

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?
 
J

Joe Fallon

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access error 3027 2
Error 3027 3
Error 3027... 2
Export textfile from access 2007 1
Error Number: 3027 -- Can't Update. Database or object is read-onl 1
Access 97 Upgrade 2000 Error In "DoCmd.TransferText acExportFixed" 1
Error 3027 1
export using transferspreadsheet 1

Top