andrewducker: (Default)
andrewducker ([personal profile] andrewducker) wrote2004-09-05 01:59 pm

Access is fun!

After 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...
richardf8: (Default)

[personal profile] richardf8 2004-09-05 07:34 am (UTC)(link)
I us MySQL as a back-end for a lot of stuff. And I use an ODBC driver to connect Access to it. IIRC there is also an ODBC driver out there for Postgres. That, combined with pass-thru queries should be able to get you some fairly snappy performance.