Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Can't open Access TableSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v9 Forum

 New Topic 
 
 Post Reply 
[1]  
 Can't open Access Table 
 Author   Message 
  PCBMW1 
  
 Group: Members 
 Posts: 5 
 Joined: 2009-01-02 
 Profile
 Posted : 2009-01-02 07:20:49

Just downloaded the trial version.  Installed and set up per the online instructions.  Also reviewed the Access tutorial to set up Access properly.  I do get data and make successful queries against my QB Pro 2008 data via the VB Demo.  However I can't open any tables in Access 2000.  I get an error "Microsoft Access can't open the table in datasheet view".  When I try to open the table in design view,  I get "Table is a linked table with some properties that can't be modified".  I get this error on all tables that I try to open.  Any help would be appreciated.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-01-02 08:55:20
I can't tell whether your link worked or not. Try looking at: MS Access will not link to ODBC and How do I setup QODBC to work with Microsoft Access 2000?  

  Top 
  PCBMW1 
  
 Group: Members 
 Posts: 5 
 Joined: 2009-01-02 
 Profile
 Posted : 2009-01-02 15:49:53

Tom – thanks for the reply.  I have followed the “How do I setup QODBC to work with Microsoft Access 2000” tutorial and everything seems to go like the tutorial and I do pull the link table names into Access but when I click on the table names I get the “"Microsoft Access can't open the table in datasheet view".  When I try to open the table in design view,  I get "Table is a linked table with some properties that can't be modified". 

 

 

I followed your other suggested link and confirmed my copy of QB Pro 2008 is registered.

 

 

One thing I noticed in the “How do I setup QODBC to work with Microsoft Access 2000” tutorial where one thing went differently is at the “Select Data Source” box – I selected my data souce from the “Machine Data Source” tab, not the “File Data Source” tab as illustrated in the tutorial.  I did this because my DSN can’t be found in the “File Data Source” tab.  I do not know if this makes any difference.

 

 

Otherwise the installation went well, a DSN was created, a connection was confirmed, and I can pull data using the VB Demo.

 

 

Any suggestions to get me up and running would be appreciated. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-01-03 08:39:23
Selecting a "Machine Data Source" is actually better. Select the Queries tab and try Create Query in Design Mode view instead. 

  Top 
  PCBMW1 
  
 Group: Members 
 Posts: 5 
 Joined: 2009-01-02 
 Profile
 Posted : 2009-01-03 13:33:35

No luck – I am able to create in design view the query I want and save the query with the fields I want, but when I try to execute the query, nothing happens.  There are no error messages or no lockup; just nothing happens.  Any ideas?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-01-04 11:09:30

Do you see a "hour glass" on the QODBC Icon in your system tray? I'm guessing "yes". You need to restrict the query to return a sub-set of data instead of all the data. Try a smaller table with less data like:

SELECT * from VendorType

 

  Top 
  PCBMW1 
  
 Group: Members 
 Posts: 5 
 Joined: 2009-01-02 
 Profile
 Posted : 2009-01-04 15:42:30

Maybe a clue? - there is no QODBC icon in my system tray when I am trying to do this.  Come to think of it, I have never seen the QODBC icon in my tray.  I still get a successful VB Demo and good test connection in the setup screen, but can't open Access table. 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-01-05 11:13:33
You must be using a old version of QODBC, please install QODBC v9.00.00.253, see: How can I get the latest version of QODBC?  

  Top 
  PCBMW1 
  
 Group: Members 
 Posts: 5 
 Joined: 2009-01-02 
 Profile
 Posted : 2009-01-05 11:41:54

My version is a 30 day demo version and  is V9.00.00.253.  Would you recommend and re-download and re-install?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-01-05 12:22:20

The QODBC installer needs to be installed for each Windows user. Sounds like you installed QODBC and then logged in as another user. Install QODBC again using the user account you are using now.

BTW: Your Windows user account must have "admin" privileges to use QODBC. If you are still using Windows 98.... don't bother.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to