Run-time error 3027

[CIS]

Hello,

Could you please help me with Error 3027 in Access 2000 database? It was
working fine until recently. Users attempt to update records and get VB
message "Cannot update. Database or object is read-only." The database
consists of two files – front end and back end, user has full rights, Windows
XP SP2, Access 2003 SP3. The error is generated at this line - rfqSet.Edit.
Thanks!

===============
Private Sub Button78_Click()
'On Error GoTo Button78_Click_err
Dim SQL$
Dim Criteria$
Dim RFQNUM As Long
Dim ZRPOSET As Recordset
Dim rfqSet As Recordset
Set ZRPOSET = dbAFH.OpenRecordset("Select * from JoinZRPOZRPOItem where
ZRPONumber = " & txtRFQZRPONumber, DB_OPEN_DYNASET)
Set rfqSet = dbAFH.OpenRecordset("Select * from JoinRFQRFQItem where
RFQNumber = " & txtRFQRFQNumber, DB_OPEN_DYNASET)

'Find This RFQ
rfqSet.MoveFirst

'Find Matching ZRPO
ZRPOSET.MoveFirst

'Update Header Information
rfqSet.Edit
rfqSet("RFQCustomerNumber") = ZRPOSET("ZRPOCustomerNumber")
rfqSet("RFQComments") = ZRPOSET("ZRPOComments")

RFQNUM = rfqSet("RFQNumber")

rfqSet.Update
===============

 

[ruralguy via AccessMonster.com]

Is there any chance the Office SP3 has been applied? If not then wait for
SP4.
If it has then you will want to apply the HotFix that corrects many of the
problems
created by the SP.

Description of the Access 2003 post-Service Pack 3 hotfix package: December
18, 2007
http://support.microsoft.com/kb/945674

 

[CIS]

RG,

Office SP3 was applied on this system a while back. Thank you for providing
a link to the HotFix. It was applied today, however, error 3027 still
reoccurs.

Thanks,
CIS

 

[ruralguy via AccessMonster.com]

You're welcome. Have you looked at the mdb's in explorer to see if somehow
they were set to read only? Does everyone have their own copy of the
FrontEnd om their PC and *only* the BackEnd is shared?

RG,

Office SP3 was applied on this system a while back. Thank you for providing
a link to the HotFix. It was applied today, however, error 3027 still
reoccurs.

Thanks,
CIS

Is there any chance the Office SP3 has been applied? If not then wait for
SP4.

[quoted text clipped - 43 lines]

 

[CIS]

The database is not set to be read only. I can add new records. However,
error 3027 still appears when editing records as described. I am
troubleshooting this database as a single user. I tried it on a couple of
different PCs and my laptop. I get this error even under Access 2007.

 

[ruralguy via AccessMonster.com]

How are the permissions on the BackEnd? Where is the BackEnd located? Do
you have the same problem when the BackEnd is local?

 

[Linq Adams via AccessMonster.com]

If you're running this under 2007,is the folder for mdb declared as "Trusted?
"

Open A2007, click the "Office" button in the upper left, go to Access Options
/ Trust Center and add the source file of the db to the list of trusted
locations.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[CIS]

RG/Linq,

I added file location to the Trust Center in A2007 on my laptop. Both front
end and back end files are local - still get the same error when trying to
edit/update a record in one of the tables. Tried in Access 2003 on a few
different computers with local files - the same problem.

Thanks,
CIS

 

[ruralguy via AccessMonster.com]

I hope Linq has some more ideas because I'm fresh out. Sorry!

 

[CIS]

RG,

Thanks for your input. I suspect the problem has to do with Ofice 2003 SP3.
Not sure what to do about it, I seacrhed Technet and Googled around. I
applied post-sp hotfix as you recommended, but still have the same error.
Thanks anyways!

 

[ruralguy via AccessMonster.com]

If it is an SP3 caused problem and the HotFix does not fix it then the only
other solution I know is to re-install Access and update it just short of SP3.