Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Can't Update: read only.." when exporting table to TXT, XLS 1

Status
Not open for further replies.

locky

Programmer
Mar 6, 2000
2
CA
Greetings all,<br>
<br>
When using the transferSpreadsheet, transferDatabase, or transfertext I get an error &quot;Can't Update: Database or object is read only&quot; even though there is no existing external object to replace<br>
<br>
Any ideas...<br>
<br>
Thanks<br>
<br>
Locky
 
I guess you're on a network?<br>
It COULD be one of several things.<br>
The database is on a differnt domain.<br>
the database is corrupted slightly.<br>
Your permissions are not Full Control on that Share or the .MDB itself.<br>
<br>
Try to copy it to your c:\drive and if it works its a permissions thing if not then there is corruption.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
 
Doug,<br>
<br>
Thanks for the feedback. I'm seeing this with more than one mdb, on more than one workstation, and occurring when trying to create the exported file.<br>
<br>
Initially I thought this was a network rights issue, but the network directory has &quot;full control&quot; rights assigned, I have tried creating the result files on C;\ , that fails also.<br>
<br>
Maybe there's some sort of update going on in the mdb when you do an export, ie to the table itself.<br>
<br>
The file server has the latest NT service packs applied<br>
I've also checked for viruses etc....<br>
<br>
Tks VM<br>
<br>
Locky
 
paste your code here<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top