Permission Denied 2007

  • Thread starter Thread starter John1506
  • Start date Start date
J

John1506

I have a simple data base that I upgraded from 2003 to 2007. Everything
works as expected except a macro (called from a form) that creates a text
file of email address. I get a Access error "Permission Denied". I assume
there may be something I have to change with user permissions, but I can't
figure it out. Any help would be appreciated.

Thanks
John
 
John1506 said:
I have a simple data base that I upgraded from 2003 to 2007.
Everything
works as expected except a macro (called from a form) that creates
a text
file of email address. I get a Access error "Permission Denied".
I assume
there may be something I have to change with user permissions, but
I can't
figure it out. Any help would be appreciated.

Thanks
John
Click to expand...

Hello John,

See the Trust Center settings for permissions about Macros. Click
the Office button, choose Access Options button in the lower right
and then choose Trust Center. If you place the db in a trusted
location, you should be all set.

I hope this helps.
Julie
 
JulieS said:
Hello John,

See the Trust Center settings for permissions about Macros. Click
the Office button, choose Access Options button in the lower right
and then choose Trust Center. If you place the db in a trusted
location, you should be all set.

I hope this helps.
Julie


Thanks Julie, but that did not help. Having the file in a trusted location eliminates the warning message when I open the db, but I still get the “permission denied’ error either when I try to create or write to "C:\EmailAddresses.csv".
Click to expand...

Any other ideas?
 
John1506 said:
Any other ideas?
Click to expand...

Hi John,
Sorry, no, frankly I'm stumped. Any other changes -- same OS etc?
I assume you have permissions from the OS to write to the root of
c:\ ?

Julie
 
JulieS said:
Hi John,
Sorry, no, frankly I'm stumped. Any other changes -- same OS etc?
I assume you have permissions from the OS to write to the root of
c:\ ?

Julie

Actually there was another major change, I moved from XP to Vista. I assumed (I know how that can get me in trouble) that since the error box of “Permission Denied†was created by “Microsoft Office Access†that it was an Access permission problem and not Vista. How do I check if access has permission to write to the root?
Thanks
John
Click to expand...
 
If you are on Vista, you do NOT have permission to copy files into the root
directory. Select a different directory.
 
boblarson said:
If you are on Vista, you do NOT have permission to copy files into the root
directory. Select a different directory.
--
Bob Larson
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________
Click to expand...
Thanks to both of you. It was a Vista problem trying to write to the root
directory.
John > >
 
Back
Top