<div>
haven't had a chance to test these out so will close question and award equal points then revisit this question when i have time to dedicate to the answer.<br />
<br />
thanks for the input!
</div>


haven't had a chance to test these out so will close question and award equal points then revisit this question when i have time to dedicate to the answer.

thanks for the input!

<div>
<div class="content wysiwyg-content">
on my desktop i have created an Access 2000 database (located on a shared network folder) which has an ODBC connection to several tables in a Quickbooks file.<br />
<br />
I can run the queries using the linked tables fine on my desktop.<br />
<br />
however, i installed the ODBC driver on another user's desktop [he has access 2007] but when i try to run the same queries using the shared Access 2000 database I receive the error <br />
&nbsp; &nbsp; &nbsp; &nbsp; ODBC - connection to {QODBC OEM Driver} failed<br />
<br />
within quickbooks i have tested the ODBC connection and the tests come back positive.<br />
<br />
is the linked ODBC table specific to my machine so only I can run the query?<br />
<br />
thanks!<br />
<br />

</div>
</div>


on my desktop i have created an Access 2000 database (located on a shared network folder) which has an ODBC connection to several tables in a Quickbooks file.

I can run the queries using the linked tables fine on my desktop.

however, i installed the ODBC driver on another user's desktop [he has access 2007] but when i try to run the same queries using the shared Access 2000 database I receive the error 
        ODBC - connection to {QODBC OEM Driver} failed

within quickbooks i have tested the ODBC connection and the tests come back positive.

is the linked ODBC table specific to my machine so only I can run the query?

thanks!



is and ODBC connection machine specific? or how do i run queries?

QuickBooks is an accounting software package geared mainly toward small and medium-sized businesses and offers on-premises accounting applications as well as cloud based versions that accept business payments, manage and pay bills, and payroll functions. QuickBooks includes remote access capabilities, remote payroll assistance and outsourcing, electronic payment functions, online banking and reconciliation, mapping features through integration, improved e-mail functionality, import from Excel spreadsheets, employee time tracking options, pre-authorization of electronic funds and new Help functions.

QuickBooks

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.