Problem encountered running a macro in ME and NT

  • Thread starter Thread starter Ed Hamblin
  • Start date Start date
E

Ed Hamblin

Not sure if this should be in the Macros or Export
groupos. 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
 
I am not sure if you have tried this or not, but it is
worth a try:

1. If you copied your database from one system to another
by burning a CD. When you copy your DB off the CD the
file will have ReadOnly set. Right CLick the file in
Explorer, select Properties and turn off the ReadOnly
Property.

2. Try Compact and repair.

3. Create an empty DB and import all Tables, Forms, etc.

Good Luck!

MAC
 
Back
Top