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

Problem Using TransferText

P: n/a
Sue
Using WindowsXP and AccessXP in 2000 Mode

When I run the following code, I get error 3027
"Cannot Update. Database or object is read only."

StrFolder = "C:\Comic Box\WebStore Interface Database\UpLoadChangeFiles\"
StrFile = "NewStoreItem" & Format(Now(), "yymmddhhnn") & ".txt"
DoCmd.TransferText acExportDelim, "NewStoreItem Export Specification",
"QryPFrmAddNewItemToWebstore", StrFolder & StrFile, False

However, when I go to File Export and export QryPFrmAddNewItemToWebstore to
C:\Comic Box\WebStore Interface
Database\UpLoadChangeFiles\NewStoreItem03092205172 0.txt, I don't encounter any
problem and the text file is created in the path.

Does anyone have an idea why manually it works and transfertext does not?

Thanks for all help!!

Sue
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Sue" <sm********@earthlink.net> wrote in message news:<gL*******************@newsread1.news.atl.ear thlink.net>...
Using WindowsXP and AccessXP in 2000 Mode

When I run the following code, I get error 3027
"Cannot Update. Database or object is read only."

StrFolder = "C:\Comic Box\WebStore Interface Database\UpLoadChangeFiles\"
StrFile = "NewStoreItem" & Format(Now(), "yymmddhhnn") & ".txt"
DoCmd.TransferText acExportDelim, "NewStoreItem Export Specification",
"QryPFrmAddNewItemToWebstore", StrFolder & StrFile, False

However, when I go to File Export and export QryPFrmAddNewItemToWebstore to
C:\Comic Box\WebStore Interface
Database\UpLoadChangeFiles\NewStoreItem03092205172 0.txt, I don't encounter any
problem and the text file is created in the path.

Does anyone have an idea why manually it works and transfertext does not?


Not yet, but when you manually export, are you using the export
specification "NewStoreItem Export Specification" that you were
attempting to use with TransferText?

Bruce
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.