If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Permission Denied 2007
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 |
#2
|
|||
|
|||
Permission Denied 2007
"John1506" wrote in message
news 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 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 |
#3
|
|||
|
|||
Permission Denied 2007
"JulieS" wrote: "John1506" wrote in message news 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 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". Any other ideas? |
#4
|
|||
|
|||
Permission Denied 2007
"John1506" wrote in message
... "JulieS" wrote: "John1506" wrote in message news 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 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". Any other ideas? 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 |
#5
|
|||
|
|||
Permission Denied 2007
"JulieS" wrote: "John1506" wrote in message ... "JulieS" wrote: "John1506" wrote in message news 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 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". Any other ideas? 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 |
#6
|
|||
|
|||
Permission Denied 2007
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 __________________________________ "John1506" wrote: "JulieS" wrote: "John1506" wrote in message ... "JulieS" wrote: "John1506" wrote in message news 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 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". Any other ideas? 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 |
#7
|
|||
|
|||
Permission Denied 2007
"boblarson" wrote: 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 __________________________________ "John1506" wrote: "JulieS" wrote: "John1506" wrote in message ... "JulieS" wrote: "John1506" wrote in message news 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 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". Any other ideas? 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 Thanks to both of you. It was a Vista problem trying to write to the root directory. John |
#8
|
|||
|
|||
Permission Denied 2007
"John1506" wrote in message ... snip Thanks to both of you. It was a Vista problem trying to write to the root directory. John Glad you were able to get it straightened away John. Julie |
Thread Tools | |
Display Modes | |
|
|