asked on

export to .rtf file

I have a simple process that exports a query as an .rtf file....has been working fine...until today....only thing I can think of that is different is that I ran the Jet35sp3.exe....could this have changed something?
the error msg I am getting is "Can't update", Database of object is read-only"

how to I fix this so I can export the file

(DoCmd.TransferText acExportMerge "qryName", "C:\Dir\file.rtf", True)
thanks,
S
points important and easy

stiemark

Check the read-only settings of the database and the file.rtf (if it exists), as well as checking that the user running this has write-access to C:\Dir.

Mark

schuyler

ASKER

the user is the default Admin so it has read/write permissions...and as I indicated...this has been working fine until today...to check the settings you go to the security option correct? unfortunately it is wide open...
the file doesn't exist yet, I'm trying to export it to this location

stiemark

The Jet update may have something to do with it.
I would try exporting to a different location and see if that does anything. Good luck. Sorry I can't be any more help.

schuyler

ASKER

Just tried exporting to my local network drive and I get the same error..thanks for trying Mark....

does it make sense that the sp3 for the jet35 engine would do this?

schuyler

ASKER

it sounds like it is saying the query is read only and it is not....

stiemark

It's possible... anything is possible.

Can you open the db and right click on the query and export it to rtf? That might give a clue as to what's going on.

ASKER CERTIFIED SOLUTION

shanesuebsahakarn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

schuyler

ASKER

shanesuebsahakarn - there are about 40 users of this app, probably 20 actually using it regularly, should I run (or get it pushed to the appropriate pc's) jet35 update on all boxes (nt and xp mix) and....since I don't want to change each registry (or, if done correctly, is this is the best way to go???)...could you explain further how to use the name statement to rename to rft file??
do you have a best practice recommendation?...
thanks

shanesuebsahakarn

Well, personally I would use the renaming method (I don't think it's a good idea to modify the registry if you can possibly avoid it).

You would just do something like this:
DoCmd.TransferText acExportMerge "qryName", "C:\Dir\file.txt", True
Name "C:\Dir\file.txt" As "C:\Dir\file.rtf"

shanesuebsahakarn

BTW, you should definitely run the Jet update. This is recommended as it fixes some otherwise serious bugs in the Jet engine.

schuyler

ASKER

thanks Shanesuebsahakarn...I will try this today and I will get the jet35 engine update to all my users (plus all others using Access 97..sounds like is the best course of action)...

schuyler

ASKER

thanks so much for your help....