Skip site navigation (1) Skip section navigation (2)

Re: MS Access hangs upon data import

From: jason(dot)tuttle(at)usbank(dot)com
To: "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: MS Access hangs upon data import
Date: 2012-03-13 20:09:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Thanks everyone for the responses. I'm realizing that we don't actually 
need to pull all the records, and linking the tables is working properly.

After I upgraded the driver version and turned on the "Use Declare/Fetch" 
setting, things started working.

You've all been a good help.

Jason Tuttle
US Bank Voice Engineering *Call Center Applications

From:   Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To:     jason(dot)tuttle(at)usbank(dot)com
Cc:     pgsql-odbc(at)postgresql(dot)org
Date:   03/13/2012 02:43 PM
Subject:        Re: [ODBC] MS Access hangs upon data import

On 03/13/2012 12:37 PM, jason(dot)tuttle(at)usbank(dot)com wrote:
> I'm selecting import - and Access freezes during the table import (after
> selecting the table).
> I tried "linking" and records are populating when I double click. But it
> doesn't populate the whole table. I have to keep scrolling down to get
> the records to continue to populate - that's not going to work.

When the table is linked the records are all there, it just pulls over 
what it needs to display. If you want it to pull over everything click 
on the last record arrow. You will see the record counter increment to 
the full record count. The caveat is that means you are dumping the 
whole table on the client which is probably not what you want. You have 
to think of linked tables as remote tables, something you pull from as 
needed. If you create forms/reports/queries against they will work by 
pulling what you ask for.

> Jason Tuttle
> US Bank Voice Engineering *Call Center Applications
> 612.492.2883


Adrian Klaver

U.S. BANCORP made the following annotations
Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.


In response to

pgsql-odbc by date

Next:From: Duffey, Blake A.Date: 2012-03-14 17:09:58
Subject: using pgsql-odbc using client certificate auth
Previous:From: Fred ParkinsonDate: 2012-03-13 19:51:56
Subject: Re: MS Access hangs upon data import

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group