I have an Access 97 Database (FE) that has a 97 (BE) on a server. In the database there is a procedure that tra sfers the results of a query to a text file (in a designated folder on the server) for a mail merge.
DoCmd.TransferText acExportMerge, , "qryACK", "\\sql\appel_legal\documents\ack.doc"
This function works fine in Access 97 but when I convert the FE to Access 2000 and try to run the same procedure I get the following error
"3207;Cannot Update,Database or Object is Read Only"
Does anyone have any ideas on why this error happens with the 2000 front end and not with 97?
Thanks
Phil
DoCmd.TransferText acExportMerge, , "qryACK", "\\sql\appel_legal\documents\ack.doc"
This function works fine in Access 97 but when I convert the FE to Access 2000 and try to run the same procedure I get the following error
"3207;Cannot Update,Database or Object is Read Only"
Does anyone have any ideas on why this error happens with the 2000 front end and not with 97?
Thanks
Phil