export to non-proprietary text files

[Don Hicks]

Hello,

I have a database in Access 2000.

One of the database's features involves a macro which exports the data in a
given query into a comma-delimited text file on our network.

When the macro is run by a user, it should write over the old text file with
the new, and other users on our network should be able to open the text
file.

Unfortunately, the text file that is generated only has permissions for the
person who ran the macro, and other users cannot open it.

Is there a way to export to a non-protected text file?

Sincerely,
Don Hicks
Portland, OR

 

[John Nurick]

Hi Don,

This isn't typical behaviour, so there must be something else going on.
AIUI the application will open the text file exclusively in order to
write it, so no other user will be able to access it until the file has
been closed after being written. Is your code doing something that would
keep the file open?

Alternatively, is there something unusual about the permissions on the
folder in question? Try giving all the relevant users full control of
the folder and see if that makes a difference. BTW, what's the network
operating system?

 

[Don Hicks at MESD]

John,

Thank you for the question about the folder permissions...changing the
folder's permissions on the network now allows the employees to open the
text file.

Unfortunately now, in checking out all the security issues in Access, I must
have changed some setting inadvertently...the employees who had previously
been able to open the database now cannot open the database...

Any clues as to how to track that down?

By the way, the Network OS is Win 2000.

Don.

 

[John Nurick]

Hi Don,

First thing is to check the file system permissions on the folder(s)
containing the mdb file(s) for the database. Users need to be able to
create and delete files as well as read and modify them (this is for the
..ldb locking information files).

If that's not the problem, how is the database secured? Exactly what
messages do the users get when they try to open it?