Exporting to excel file cannot update database or object is read-o

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

I created a Macro to TransferSpreadSHeet from a Query that I cready to make a
graph. I had it working fin but then I tried it on a second computer on my
network and since then I have not been able to get it to work. I get the
Cannot update. Database or object is read-only.

I have checked the file and it is not protected, I have moved it to the
local drive and I still get the error.

Can someone tell me the steps to create a macro to export my file to a excel
file and upadate the data in the file?
 
How long is the path and file name string for the file, The limit is 64
characters.

Otherwise, tell us the values of the arguments for your TransferSpreadsheet
macro..
 
I don't think I am exceeding the limit.
Transfer Type - Export
Spreadsheet Type - Microsoft Excel 8-10
Table Name - "Effeciency Data Query for exporting"
File Name - "C:\Documents and Settings\vn028328\Desktop\Monthly.xls"
Has Field Name - Yes
Range -

I've tried to change the file name several times but it does not matter I
still get the same issue.

Thanks for your help!!
 
Let's try an experiment. Use File | Export menu and do a manual export of
the table to the desired EXCEL filename/path. Does that export work without
an error?

Does "vn028328" folder exist under "Documents and Settings" on the PC that
is giving the error?

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
 
Ken,

I can manually export them to any file and location, I only get this issue
when I tyr to transferspreadsheet using the macro.

Yes vn028328 location is on my computer as well.

Maybe I should use code instead only I am new to access and not sure how to
write the code.
 
Action TransferSpreadsheet

Transfer Type Export
Spreadsheet Type Microsoft 8-10
Table Name Effeciency exporting
File Name "D:\VN02832\Monthly"
Has Field Names No
Range


That is what I have in the macro
 
Remove the " characters from the File Name argument.
D:\VN02832\Monthly

If that doesn't work, insert an = character at the front of the File Name
string:
="D:\VN02832\Monthly"

I assume that the D drive is mapped the same way on both PCs?
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
 
Back
Top