Solved

Quickbooks Not Allowing Me To Grant Access to My Application

Posted on 2007-12-04
6
1,435 Views
Last Modified: 2013-11-26
My Computer:
Windows XP Pro SP2
AMD Athalon 64 3500 +2.20 gHz - 3 GIG of Ram
MS Visual Studio 2005 - Professional Edition
using: VB.Net

Quickbooks:
Quickbooks Pro 2005
Multi-user mode

I have written an application in VB.net to manage our projects.  This application has been able to connect to OTHER quickbooks company files, however in this case - the file is not allowing me to grant access to that application or not.

FROM QUICKBOOKS HELP:
" The first time an application tries to access a company file, you will see an authorization window. You can then decide whether to authorize the application to:.. etc.."

WIth the other company file, this "Authorization window" popped right up.  In this file, no window pops up, and I am NOT able to grant access.  The application doesnt appear in the list of authorized applications in the Edit->Preferences menu. (obviously..)

SETTINGS:
Checkbox "Dont allow any applications to access the company file"
- This is UNCHECKED (Allowing access)
I am in Multi-User Mode

I have a user setup in quickbooks already - this user has access to EVERYTHING.. just like an admin.  My application logs in as that user.

I NEED to have quickbooks grant access to this application. There is NO reason for this to be happening. I KNOW it works, since it worked fine on the other company file.  Is there anything I can try? Maybe force it to acknowledge my app?

Thank you!

- Andrew
0
Comment
Question by:LunaSkye
  • 2
  • 2
6 Comments
 
LVL 21

Expert Comment

by:surajguptha
ID: 20404042
To be honest i havent worked with Quickbooks but i would like to try and suggest you a way....

The file that doesnt display the authorization window may be a incorrect file. Can you try openning this file and see if is not corrupted or written using some older version of quickbooks?

Is this file on a network share?
0
 
LVL 6

Author Comment

by:LunaSkye
ID: 20404129
Hello Surajguptha,

Both company files are active and working quickbooks company files.. THey are opened and used every day in our office. Both files work, and dont appear to be corrupt in any way.  The one that WORKED, is newer however..  I'm not sure if the older one was created in a previous version or not... how do I check that?

Yes - Both company files (the working, and the not working) are on a network share.

- andrew
0
 
LVL 21

Expert Comment

by:surajguptha
ID: 20404234
>> I'm not sure if the older one was created in a previous version or not... how do I check that?

can you try openning the older file and save it as a new file?? or probably create a new file and paste the contents of the files that doesnt seem to accept authorization?
0
 
LVL 6

Accepted Solution

by:
LunaSkye earned 0 total points
ID: 20565138
Noone - ANYWHERE - has been able to fix my problem..
I am going to cancel this question - and ask for refund

HOWEVER....................
I was able to fix my own problem - this may be of value for anyone trying to do quickbooks programming in the future.

When validating an application to connect to quickbooks, several things have to be true.
1. you must have that company file open on the SAME COMPUTER that application is open on.
2. you must be logged in as ADMIN
(Heres the biggie)
3. the PATH to the company file must be the SAME in both cases.
* I had the company file open on my computer as "Y:\QBData\Company.qbw", but when my application was accessing the file, it was not using a drive letter shortcut.  the "Y" drive was actually "\\Server\Share\", so the final path looked something like this: "\\Server\Share\QBData\Company.qbw".

The fact that the PATH to the company file was different (even though it pointed to the same company file), disabled the validation.  It returned the cryptic errors telling me that the company file was already open, or that the administrator must first validate the access, etc..

I got around it by not resolving the network path in my application.. i stuck with the shortcut drive letter.  In so doing, the two paths were EXACTLY the same... and therefore the validation window came up, and we all lived happliy ever after.

NOTE: Once the application is validated, you can access the company file by any path you choose. In my case, i only VALIDATE using a shortcut drive letter path. When my application actually touches the QB data, it uses the full URL "\\server\share" etc..  The only time the paths have to match exactly is when you are VALIDATING the file access.

Thank you all for at least READING this.. I hope this helps other QB programmer.

- Andrew
0
 
LVL 1

Expert Comment

by:Vee_Mod
ID: 20593823
Closed, 400 points refunded.
Vee_Mod
Community Support Moderator
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question