error '3027' cannot update or object is read-only

[Guest_imported]

Hello everyone.

I have a VBA module in an access 2000 database that imports text from a flat file using the TransferText method.

Can anyone tell me why I may get this error? I never had it the first few times I ran the procedure (I included the procedure below).

"error '3027' cannot update or object is read-only"

Const CUS_IMP_EMAIL_FILE As String = "c:\Email_bulk\members_imp_email.dat"
Const CUS_EXP_EMAIL_FILE As String = "c:\Email_bulk\members_exp_email.dat"


Public Sub ImportCusEmailFlat() 'ByVal sImportFileName As String)

Call DoCmd.TransferText(acImportDelim, "MEMBERS_IN Import Specification", "MEMBERS", CUS_IMP_EMAIL_FILE, False)


End Sub


Thanks.

Larry

is_law@vt.edu

 

[Danny]

I've found that strange bug comes out only if you import text files with extention different from the classic extentions for text file.
You can verify this abnormal effect even importing text file from Access menu.
Try to rename your file from .dat to .txt.....

I've got Access 2000 not SP1,... and you? it may be a bug fixed with SP1 ...

Bye.