E
Ed Hamblin
Not sure if this should be in with Macros, or with
Exporting data. I built an ACCESS 2000 database with a
macro that is supposed to transfer a fixed width text file
into a folder after a table has been updated (Transfer
Text action). I can run this macro successfully on a non-
networked machine with Windows 98 SE OS, and it works just
as it should. I try to use it on my laptop with Windows
ME (non-network) or at work with Windows NT OS (network
with Administrator rights) and I get an error message that
says Database or Object is Read Only. None of the
attributes are set to read only. Interestingly enough,
when I converted the database to an ACCESS 97 version
from ACCESS 2000, and ran it on an NT machine with the
Office 97 suite, it worked. I can also do the text
transfer from the ACCESS 2000 database if I forgo the
macro and run the query, then using the File>Export menu
path. After I choose to export as text and the Export
Text Wizard appears, I select the Advanced button on the
wizard. After the next screen screen opens, using the
Specs button, I select the proper Specification I built;
the file will save in the proper text format where it is
supposed to. I would prefer for my target user group to
be able to do it by pushing the macro button on the form
following the other "user friendly" functions I have built
into the form. What steps do I take to get this ACCESS
20000 macro to work on an ME or NT machine? TIA...
EH
Exporting data. I built an ACCESS 2000 database with a
macro that is supposed to transfer a fixed width text file
into a folder after a table has been updated (Transfer
Text action). I can run this macro successfully on a non-
networked machine with Windows 98 SE OS, and it works just
as it should. I try to use it on my laptop with Windows
ME (non-network) or at work with Windows NT OS (network
with Administrator rights) and I get an error message that
says Database or Object is Read Only. None of the
attributes are set to read only. Interestingly enough,
when I converted the database to an ACCESS 97 version
from ACCESS 2000, and ran it on an NT machine with the
Office 97 suite, it worked. I can also do the text
transfer from the ACCESS 2000 database if I forgo the
macro and run the query, then using the File>Export menu
path. After I choose to export as text and the Export
Text Wizard appears, I select the Advanced button on the
wizard. After the next screen screen opens, using the
Specs button, I select the proper Specification I built;
the file will save in the proper text format where it is
supposed to. I would prefer for my target user group to
be able to do it by pushing the macro button on the form
following the other "user friendly" functions I have built
into the form. What steps do I take to get this ACCESS
20000 macro to work on an ME or NT machine? TIA...
EH