By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,353 Members | 1,555 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,353 IT Pros & Developers. It's quick & easy.

Error 3027: cannot update: database or object is read only

P: n/a
Hi there,

Allthough I searched for previous posts, I was unable to solve my problem.

I try to link my front-mdb with an Excel file using the next line
DoCmd.TransferSpreadsheet acLink, 8, "TblParameters",
"C:\Parameters.xls", True, ""

This works perfect for Access 2000, while for Access 2002 and Access
2003 I get error message 3027: cannot update: database or object is read
only.
The file is linked (fields can be read), but I'm unable to update any
fields.

And of course, I checked that this problem was not related to read-only
attribute, administrator rigths, etc.

Who has any suggestions to solve this?

TIA, Paul
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.