Permission settings on exported text files

[Don Hicks at MESD]

Hello,

I am having permission problems with a text file exported from an Access
2000 database.

The database resides on a network and can be opened by a handful of
employees.

The database contains a macro with a "Transfer Text" command which exports
the results of a particular query to a comma-delimited text file which also
sits on our network. Each time the macro is run, a new text file should
write over the old one.

I need the text file to be openable by anyone on the network, not just the
handful of employees using the database.

Unfortunately, the text file currently generated only allows the employee
who generated it to open it. No one else may open the file, whether they be
one of the handful of employees using the database, or any of my agency's
other employees.

And, when employee B tries to run the macro after employee A has run the
macro, it fails because employee B does not have the permissions to write
over A's text file.

Could this be caused by some security settings within Access? I have been
unable to find supporting information on this issue.

Sincerely,
Don Hicks
Portland, OR

 

[Joan Wild]

I am having permission problems with a text file exported from an
Access 2000 database.

The database contains a macro with a "Transfer Text" command which
exports the results of a particular query to a comma-delimited text
file which also sits on our network. Each time the macro is run, a
new text file should write over the old one.

I need the text file to be openable by anyone on the network, not
just the handful of employees using the database.

Unfortunately, the text file currently generated only allows the
employee who generated it to open it. No one else may open the file,
whether they be one of the handful of employees using the database,
or any of my agency's other employees.

Sounds like the file is being saved in a folder that doesn't have sufficient
permissions for all to see it. It wouldn't be an Access security issue.