Solved

Quickbooks Not Allowing Me To Grant Access to My Application

Posted on 2007-12-04
6
1,438 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

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

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

733 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