472,782 Members | 2,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,782 software developers and data experts.

Excel - Access Denied

Hello, I am using a generic AD Domain Account to create an excel spreadsheet,
but I am getting an "Access Denied" error when I attempt to instatiate the
excel object. The generic account does is set up in such a way that I can
not log on to the server with the account but it is a valid account as I have
used it in other applications. The code works perfectly fine when I use my
own account ID and password. So there is something about this account in
relationship to excel which is not set up correctly. I seem to remember that
I got an error on my own account on the server if I had never started excel
under my own account, but I do not recall what the error was. Since I can
not log on with this generic account, what would I need to do to prep the
account for the generic account (assuming that this is what the error is)?

Thanks in advance for your assistance
Jan 16 '06 #1
1 2088
When Excel is run for the first time it installs some settings for you. I
assume this would be stored in the Application Data folder of the user
profile on the server...

C:\Documents & Settings\user\Application Data

But there may be some registry settings that get written for the CurrentUser
as well.

A start if you don't want to log on with the user may be to copy the
contents of the Application Data folder for a user that has logged on in the
past across to the new user that can't log on.

Hope that this helps to point you in the right direction, let me know how
you get on.

--
Kurt Farrar
..NET Developer & Computer Enthusiast

"Jim Heavey" wrote:
Hello, I am using a generic AD Domain Account to create an excel spreadsheet,
but I am getting an "Access Denied" error when I attempt to instatiate the
excel object. The generic account does is set up in such a way that I can
not log on to the server with the account but it is a valid account as I have
used it in other applications. The code works perfectly fine when I use my
own account ID and password. So there is something about this account in
relationship to excel which is not set up correctly. I seem to remember that
I got an error on my own account on the server if I had never started excel
under my own account, but I do not recall what the error was. Since I can
not log on with this generic account, what would I need to do to prep the
account for the generic account (assuming that this is what the error is)?

Thanks in advance for your assistance

Jan 16 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jon Rista | last post by:
Hello. I'm trying to automate Excel in a C# Windows Service. This windows service has to be able to access files on network shares, so it uses a domain account on a WinNT 4.0 domain server, rather...
1
by: sk | last post by:
Please forgive me if the same topic is already posted. But i havent found I have got an error while accessing the excel file as below. Can somebody reply if there is a solution Access is denied....
3
by: hari krishna | last post by:
hi, I am generating excel reports through vb.Net. After creating excel.application and the report is generated, each report leaves Excel in memory. I can see them in task manager in Process tab...
9
by: hari krishna | last post by:
hi, I want to send the data from dataset information to Excel through ASP.Net. there will be no XL installed on web server. web server is win 2000 server machine. I am using visual basic code in...
2
by: Ryan Ternier | last post by:
We've been using Excel for our web apps for quite some time. We're putting the apps on 2003 boxes now and have run unto an error with Excel. It just won't work <darn excel>. It gives us the...
2
by: Alex D. | last post by:
Hi .I cant seem to find a way to authorize asp.net user to create an Excel application using this: Microsoft.Office.Interop.Excel.ApplicationClass excel = new...
8
by: jack | last post by:
Access is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it...
12
by: D. Shane Fowlkes | last post by:
This most likely belongs in another forum but I thought I'd start here. I have a COM Object written in VB6. The DLL will access MS Excel and use it's Object Library to write a customized report...
2
by: kelvinweb | last post by:
Hi All, I don't why alert below error message when I am using "Excel Application". I have to following the instruction, but the error is still here. Please help .. Dim excelApp As New...
0
by: =?Utf-8?B?TW9udGU=?= | last post by:
I am using VB.NET to open and read info from Excel spreadsheets using code similar to this: Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlBooks As Excel.Workbooks Dim...
0
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.