Run-time error '3027'

[Chuck]

I've upgraded to Windows XP and now have a database
problem that is the same in Access 97 and Access 2002 (I
have both installed). The visual basic command that is
coming up in the debug window is as follows:

DoCmd.TransferText
acExportDelim, "", "qryQuickBooks", "c:\Data\qb.iif",
False, ""

I can't see anything wrong with this. Anyone have any
thoughts? Thanks.

 

[Van T. Dinh]

It sounds like Reference Errors because Access cannot find the References,
probably installed in different locations by Windows XP.

See Douglas J. Steele's article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Chuck]

Boy, I really hoped that was it. But it isn't. I even
downloaded the AddIn reference wizard and all checked out
fine. Thanks, though.

Chuck

 

[Van T. Dinh]

Did you try Douglas' steps of noting down a checked Reference, unchecking
it, getting out and then into the References Dialog and re-checking the
unchecked Reference?

Even though the final References is still the same, the process seems to
shake out errors in the References Collection.

 

[Chuck]

Yes, that's the first thing I tried. Then I tried
unchecking all of them that I could, getting out of the
dialog box, getting back in and rechecking them. That
didn't work, which is why I downloaded the reference
checker.

Chuck

 

[Van T. Dinh]

Error 3027: Can't update. Database or object is read-only.

If the file "c:\Data\qb.iif" exists, try deleting it before the export.
Also,, I normally leave the spec argument empty and not an empty String.
Try:

DoCmd.TransferText acExportDelim, , "qryQuickBooks", _
"c:\Data\qb.iif", False, ""