emailing reports

I created a report that selects data from a subform. I added a command
button and followed the wizard thur and asked it to email a report (already
created). It works fine when I run it, however when other users run it(on
there pc) they get an error reading some else is in the file (read only) or
it is a table created in an earlier version of Access. I have the file on a
network shared drive. It is a small design program. Supposedly we all have
the same version of access loaded on our pc's. Any suggestions. I did just
did reload my version perhaps I enable a feature that was set up in
general?????

1. All users of the database must have at least read, write, create, delete
(or modify) privileges to the folder holding the database file. Not just the
database .mdb file, but the entire folder.

2. Open the database and go to Tools, Options, and Advanced Tab. Set the
Default Open mode to Shared and the Default Record Locking to Edited Record.
(While you are in the Options area, go over to the General tab and turn off
Compact on Close and Name AutoCorrect. Trust me on this.)

3. The database should be split with the back end holding the tables on the
network drive and a copy of the front end, with the queries, forms, and
reports, on each user's computer.

4. Are you by chance creating a temporary table to run this report? That can
cause multi user problems, but #3 above should fix that.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"tonkaplayer" wrote:

I created a report that selects data from a subform. I added a command
button and followed the wizard thur and asked it to email a report (already
created). It works fine when I run it, however when other users run it(on
there pc) they get an error reading some else is in the file (read only) or
it is a table created in an earlier version of Access. I have the file on a
network shared drive. It is a small design program. Supposedly we all have
the same version of access loaded on our pc's. Any suggestions. I did just
did reload my version perhaps I enable a feature that was set up in
general?????

"tonkaplayer" wrote in message
...
I created a report that selects data from a subform. I added a command
button and followed the wizard thur and asked it to email a report
(already
created). It works fine when I run it, however when other users run it(on
there pc) they get an error reading some else is in the file (read only)
or
it is a table created in an earlier version of Access. I have the file on
a
network shared drive. It is a small design program. Supposedly we all
have
the same version of access loaded on our pc's. Any suggestions. I did
just
did reload my version perhaps I enable a feature that was set up in
general?????

bbbbnn,;;;

"tonkaplayer" a écrit dans le
message de groupe de discussion :
...
I created a report that selects data from a subform. I added a command
button and followed the wizard thur and asked it to email a report
(already
created). It works fine when I run it, however when other users run it(on
there pc) they get an error reading some else is in the file (read only)
or
it is a table created in an earlier version of Access. I have the file on
a
network shared drive. It is a small design program. Supposedly we all
have
the same version of access loaded on our pc's. Any suggestions. I did
just
did reload my version perhaps I enable a feature that was set up in
general?????