Access is fun!
Sep. 5th, 2004 01:59 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
andrewduckerAfter becoming increasingly exasperated with Access's complete inability to do anything at a reasonable speed I downloaded PostGres to play with.
Exporting the first table to it from Access failed to work, so I thought I'd break it down the process and see if it worked.
(1) Create a blank table identical in structure to the original table, but without any data in it.
(2) Update this new table with all the data in the original table.
That worked.
Which makes me wonder what, exactly, Access was trying to do the first time that completely _failed_ to work...
Exporting the first table to it from Access failed to work, so I thought I'd break it down the process and see if it worked.
(1) Create a blank table identical in structure to the original table, but without any data in it.
(2) Update this new table with all the data in the original table.
That worked.
Which makes me wonder what, exactly, Access was trying to do the first time that completely _failed_ to work...
no subject
Date: 2004-09-05 07:34 am (UTC)no subject
Date: 2004-09-05 07:45 am (UTC)Mind you, it still seems to do a lot of processing on the client side. I need to separate out my functions and see if I can put some of them onto the Postgres side...