Solved

Quickbooks Not Allowing Me To Grant Access to My Application

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Adding queries and macros to many Microsoft Access Databases. 7 73
Name space syntax error 12 39
Connection String 16 43
SQL Exceptions 3 36
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…
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…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
A simple description of email encryption using a secure portal service. This is one of the choices offered by The Email Laundry for email encryption. The other choices are pdf encryption which creates an encrypted pdf of your email and any attachmen…

914 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

16 Experts available now in Live!

Get 1:1 Help Now