Thread: MS Access hangs upon data import

MS Access hangs upon data import

From

jason.tuttle@usbank.com

Date:

13 March 2012, 18:06:55

postgres db version: 8.3
driver version: 09 00 0200
MS Access: Office 2003
workstation: winXP

I am trying to import a large table to MS Access. After selecting the table, and then ok, the import starts. It hangs after the status bar gets to full (100%).

I am able to import smaller tables successfully.

I have searched the web and found nothing on this.

Jason Tuttle
US Bank Voice Engineering *Call Center Applications
612.492.2883

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.

---------------------------------------------------------------------

Re: MS Access hangs upon data import

From

Adrian Klaver

Date:

13 March 2012, 18:56:15

On 03/13/2012 11:06 AM, jason.tuttle@usbank.com wrote:
> postgres db version: *8.3*
> driver version: *09 00 0200*
> MS Access: *Office 2003*
> workstation: *winXP*
>
> I am trying to import a large table to MS Access. After selecting the
> table, and then ok, the import starts. It hangs after the status bar
> gets to full (100%).

When you say import are you talking about linking a table and then
viewing it or importing the contents of a linked table into a new table?

>
> I am able to import smaller tables successfully.
>
> I have searched the web and found nothing on this.
>
> Jason Tuttle



--
Adrian Klaver
adrian.klaver@gmail.com

Re: MS Access hangs upon data import

From

jason.tuttle@usbank.com

Date:

13 March 2012, 19:37:41

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.

Jason Tuttle
US Bank Voice Engineering *Call Center Applications
612.492.2883

From: Adrian Klaver <adrian.klaver@gmail.com>
To: jason.tuttle@usbank.com
Cc: pgsql-odbc@postgresql.org
Date: 03/13/2012 01:56 PM
Subject: Re: [ODBC] MS Access hangs upon data import

On 03/13/2012 11:06 AM, jason.tuttle@usbank.com wrote: > postgres db version: *8.3* > driver version: *09 00 0200* > MS Access: *Office 2003* > workstation: *winXP* > > I am trying to import a large table to MS Access. After selecting the > table, and then ok, the import starts. It hangs after the status bar > gets to full (100%). When you say import are you talking about linking a table and then viewing it or importing the contents of a linked table into a new table? > > I am able to import smaller tables successfully. > > I have searched the web and found nothing on this. > > Jason Tuttle -- Adrian Klaver adrian.klaver@gmail.com

Re: MS Access hangs upon data import

From

Adrian Klaver

Date:

13 March 2012, 19:43:46

On 03/13/2012 12:37 PM, jason.tuttle@usbank.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
adrian.klaver@gmail.com

Re: MS Access hangs upon data import

From

"Fred Parkinson"

Date:

13 March 2012, 19:52:19

I have used access and postgresql together for about 12 years and I can report that some things in access work better than others, even if they appear to be doing the same thing.

So try this:

first link to the table you want to import.

next create a 'make table' query of the linked table.

run the make table query to create a local copy of the table.

Success????

>>> <jason.tuttle@usbank.com> 03/13/2012 11:06 AM >>>
postgres db version: 8.3
driver version: 09 00 0200
MS Access: Office 2003
workstation: winXP

I am trying to import a large table to MS Access. After selecting the table, and then ok, the import starts. It hangs after the status bar gets to full (100%).

I am able to import smaller tables successfully.

I have searched the web and found nothing on this.

Jason Tuttle
US Bank Voice Engineering *Call Center Applications
612.492.2883

Re: MS Access hangs upon data import

From

jason.tuttle@usbank.com

Date:

13 March 2012, 20:09:43

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
612.492.2883

From: Adrian Klaver <adrian.klaver@gmail.com>
To: jason.tuttle@usbank.com
Cc: pgsql-odbc@postgresql.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.tuttle@usbank.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 adrian.klaver@gmail.com