• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1480
  • Last Modified:

Quickbooks Not Allowing Me To Grant Access to My Application

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
LunaSkye
Asked:
LunaSkye
  • 2
  • 2
1 Solution
 
surajgupthaCommented:
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
 
LunaSkyeAuthor Commented:
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
 
surajgupthaCommented:
>> 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
 
LunaSkyeAuthor Commented:
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
 
Vee_ModCommented:
Closed, 400 points refunded.
Vee_Mod
Community Support Moderator
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now