Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Run-time error '3027'

0 views
Skip to first unread message

Chuck

unread,
Oct 17, 2003, 1:32:28 PM10/17/03
to
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

unread,
Oct 17, 2003, 1:50:25 PM10/17/03
to
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

--
HTH
Van T. Dinh
MVP (Access)

"Chuck" <c...@doubleplus.com> wrote in message
news:085501c394d4$a31b7890$a001...@phx.gbl...

Chuck

unread,
Oct 17, 2003, 2:09:27 PM10/17/03
to
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

unread,
Oct 17, 2003, 2:41:19 PM10/17/03
to
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.

--
HTH
Van T. Dinh
MVP (Access)

"Chuck" <c...@doubleplus.com> wrote in message

news:2da9f01c394d9$cd900e10$a601...@phx.gbl...

Chuck

unread,
Oct 17, 2003, 3:32:47 PM10/17/03
to
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

unread,
Oct 18, 2003, 6:33:07 AM10/18/03
to
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, ""

--


HTH
Van T. Dinh
MVP (Access)

"Chuck" <c...@doubleplus.com> wrote in message

news:2dba601c394e5$71aa6580$a601...@phx.gbl...

0 new messages