Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-04-2001, 06:34 AM   #1
fmm
Registered User
 
fmm's Avatar
 
Join Date: Mar 2001
Location: Minneapolis, MN USA
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts
fmm
Weird Weird behavior

This is a strange one:

Assume that the following directory is empty:
R:\claims\projects\xxxxx xxxxx\data\V F P 12

If I try to execute the following command in VBA, it works fine:
DoCmd.TransferSpreadsheet acExport, , "tblReturnedMail", "R:\claims\projects\xxxxx xxxxx\data\V F P 1234567890 1234567890\ReturnedMailVFP.xls", True

However, if the pathname is 1 character longer:
R:\claims\projects\xxxxx xxxxx\data\V F P 123

I get the following error message:
"Cannot update. Database or object is read-only."

If the file already exists in the directory, I can apparently chabge the length of the pathname to whatever I want. For example, the following works (if the xls file is already there):
DoCmd.TransferSpreadsheet acExport, , "tblReturnedMail", "R:\claims\projects\xxxxx xxxxx\data\V F P 1234567890 1234567890\ReturnedMailVFP.xls", True

Any ideas?
Thanks in advance.

__________________
fmm
bass player, mixologist, stupid excel tricks
fmm is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 07:37 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World