TransferSpreadSheet

[border20]

I have a problem with the folowing line

DoCmd.TransferSpreadsheet acExport, 8, "tablenameQ", "C:\test.xls", False

I get an error saying that update is impossible, database or objet is read-only.

But neiter the database or excel document is read-only...

why is this ?
thx

 

[yippie_ky_yay]

Is your excel file open? That could be why! If not, maybe try to make sure that your table is closed too.

Hope that does it!

-Sean

 

[border20]

I tried all that... nothing is working... I tried the same code on another DB on a different computer and it worked... So i'm stuck... maybe its the computer

 

[yippie_ky_yay]

Just change computers then! ...just joking

Start comparing libraries between the two. In VBA go to Tools-References and make sure you have the same ones.

(longshot, but worth checking) Also, go into Tools-Options-General and make sure that the "Track name auto Correct info" is deselected (that seems to cause weird stuff to happen).

Other than that, I can't think of anything else that would be machine dependant right now so I hope that works for you! If not, then hopefully someone smarter is bound to come around.

Let me know how it goes!

-Sean

 

[The_Doc_Man]

Is there a difference in the way you are logging in on the two machines? Could be a rights problem.

Another issue is that your registry holds your login, not Access. Workgroups are a Windows-level function, not an Access-level function. So you might wish to run (carefully!) regedit on both systems. Find string ".MDW" and see which workgroup you have connected yourself to on those machines. If they are different, there is your answer. If their contents are different, that might also be an issue.