Solved

Quickbooks Not Allowing Me To Grant Access to My Application

Posted on 2007-12-04
6
1,425 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now