Permission Issues

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

softspoken

Thread Starter
Joined
Mar 22, 2010
Messages
55
I have a database that 2 people have access too. They both have the same permissions but one can export and the other one cant. Can some one help with what needs to be done so that the other person has the option to export...

(Access 97)
 

OBP

Joined
Mar 8, 2005
Messages
19,896
I can't say that I have ever heard of this problem.
What are they trying to Export?
If you Automate the Export with VBA can they both use it without the same problem?
 

softspoken

Thread Starter
Joined
Mar 22, 2010
Messages
55
One of them is just trying to export a report or query that is produced in the database. I dont have a clue as to why one can and one cant.
 

softspoken

Thread Starter
Joined
Mar 22, 2010
Messages
55
just to there desktops so that they can send out the reports ... its as simple as it sounds .. its just that one doesnt have the ability to export .. it doesnt give him the option ..
 

softspoken

Thread Starter
Joined
Mar 22, 2010
Messages
55
they would probably send it by email after it is exported .. but thats the problem .. he doesnt have the option to export. its grayed out ..
 

OBP

Joined
Mar 8, 2005
Messages
19,896
But they will probably not stop Access VBA form exporting it or better still from emailing it for them.
 

softspoken

Thread Starter
Joined
Mar 22, 2010
Messages
55
haha i dont even know what that means ... do you mean use come code to have it automatically exported or emailed? what works for one would have to work for both of them because one can work fine within the database and the other one cant export .. so if you pust code in there .. both have to agree to do so.
 

OBP

Joined
Mar 8, 2005
Messages
19,896
A command button with VBA code would allow them to directly email a report from within Access.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

No members online now.
Top